Search Results

Search found 1086 results on 44 pages for 'sp'.

Page 23/44 | < Previous Page | 19 20 21 22 23 24 25 26 27 28 29 30  | Next Page >

• how can i know which store procedure is running using sql server 2005

  - by kumar

  How can i know which store procedure is running using sql server 2005. and also how to print that SP?

  Read the article

• Jumping into argv?

  - by jth

  Hi, I`am experimenting with shellcode and stumbled upon the nop-slide technique. I wrote a little tool that takes buffer-size as a parameter and constructs a buffer like this: [ NOP | SC | RET ], with NOP taking half of the buffer, followed by the shellcode and the rest filled with the (guessed) return address. Its very similar to the tool aleph1…

  Read the article

• Sprite not moving when using a function from another class SFML c++

  - by user2892932

  I have a Game.cpp, and I am calling a update function in my Player class. In my player update Function I have it to check for keyboard input, and it seems to work, but whenever I try to call the .move() function, it seems to not work. I get no errors either. I am new to sfml, and decent with c++. Help is appreciated! #include "Player.h" …

  Read the article

• In chrome with a greasemonkey extension, how can I modify an `<a...>` construct to strip out the onc

  - by Ross Rogers

  I want to modify an internal webpage to strip away some of the onclick behavior of certain links. The internal webpage has a bunch of links like: <a href="/slm/detail/ar/3116370" onclick="rallyPorthole.showDetail('/ar/view.sp','3116370','pj/b');return false;">foo de fa fa</a> How can I do an extension to Chrome so it does…

  Read the article

• Which user account is running SQLCMD in T-SQL Script without -U and -P option?

  - by niteshg

  I am using sqlcmd in a T-SQl script to write a text file to a network location. However SQLCMD is failing to write to that location due to access permission to the network folder. SP is being run under my user account which has access to the network folder. Could you please help me under which account sqlcmd will run if I do not specify…

  Read the article

• Dynamic sql vs stored procedures - pros and cons?

  - by skyeagle

  I have read many strong views (both for and against) SPs or DS. I am writing a query engine in C++ (mySQL backend for now, though I may decide to go with a C++ ORM). I cant decide whether to write a SP, or to dynamically creat the SQL and send the query to the db engine.# Any tips on how to decide?

  Read the article

• Global temporary tables getting data from different session in Oracle

  - by Omnipresent

  We have a stored procedure in Oracle that uses global temporary tables. In most of our other stored procedures, first thing we do is delete data from global temporary tables. However, in few of the stored procedures we do not have the delete's. Are there any other options other than adding the delete statements? Can something be…

  Read the article

• Stored procedure with output parameters vs. table-valued function?

  - by abatishchev

  Which approach is better to use if I need a member (sp or func) returning 2 parameters: CREATE PROCEDURE Test @in INT, @outID INT OUT, @amount DECIMAL OUT AS BEGIN ... END or CREATE FUNCTION Test ( @in INT ) RETURNS @ret TABLE (outID INT, amount DECIMAL) AS BEGIN ... END What are pros and cons of each approach…

  Read the article

• Select a column returned by a stored procedure

  - by vaibhav

  I have a stored procedure which is returning me about 50 columns. I want to write a query, where I will be able to select a particular column from the list of column returned by the SP. I tried writing select RSA_ID from exec(uspRisksEditSelect '1') But Its throwing me an error. I think we need to write some dynamic sql for it. But…

  Read the article

• Dynamic select clause in SQL Server from XML

  - by Rohit

  I have to query a view and include only those columns which are defined in the XML which comes as a parameter to my SP. Can i include that XML in select clause and extract all columns defined in that XML. Please tell a way to do this.

  Read the article

• Ms Access DB used by website

  - by Steven

  Hi Guys, I have been asked to update a legacy website. I was originally build in asp using a MS Access DB to store some user details. However I am aware that the DB can be downloaded if you use the correct url. What is the best way to stop this without stopping the website having access to the DB? Thanks Sp

  Read the article

• How can I make exception handling for all existing SQL server 2005 Stored Procedures, view and funct

  - by Space Cracker

  we have a portal that have SQL server 2005 database that contain about 1750 stored procedures , 250 view and 200 function and 95% of them not have handling exception in their code .. we search about any way that allow us making such a global exception handling in SQL that receive any exception happen in any SP,view or function and…

  Read the article

• Way to partialy match a Ruby string using Regexp

  - by Fabiano PS

  I'm working on 2 cases: assume I have those var: a = "hello" b = "hello-SP" b = "not_hello" 1 - Any partial matches I want to accept any string that has the var a inside, so b and c would match. 2 - Patterned match I want to match a string that has a inside, followed by '-', so b would match, c does not. I am…

  Read the article

• Drop group of stored procedures by name

  - by Kate

  I have group of stored procedures with names like 'somename_%'. Are there any way to delete that SP with one query, forexample DROP PROCEDURE where name like 'somename_%' .

  Read the article

• SharePoint Designer for Mac?

  - by Glen Hunt

  I'm looking for some way of editing SharePoint ASPX pages on my Mac, using either a local text editor or some kind of remote-into-the-SP-server solution (like emacs with tramp). I know that Cyberduck has the ability to open WebDAV servers with NTLM authentication, but I've been unable to get that to work. So far, the only…

  Read the article

• How to identify document in SharePoint

  - by saveug

  You can put your documents in SP - cool, but, when its time to reorganize folders structure what I should do with old links? Is there a way how to identify document instead of using URL where path to the document is used? I need something like permanent link: http://mysharepoint/doc-123, where 123 is the document…

  Read the article

• Where does sql server stores the stored proecdure code?

  - by NoProblemBabe

  I once needed the lines of the stored procedures, to be able to trace whether i have a reference to some function, procedure or table, or sometimes to try to find something inside of the sp's code. Where does the sql server stores the procedures's code?

  Read the article

• MS Sql Server Object Creation / Alter Script

  - by Chris Klepeis

  Hi, In Sql Server when you select to modify a SP or UDF it loads the objects alter query in a query window. Are these queries accessible in a system table so I can store the alter statements somewhere? It looks like syscomments has some objects but not all of them. Thanks

  Read the article

• Load Balancer Timeout

  - by Anilkumar

  "This website is temporarily unavailable. Please check back later. Unfortunately there were no suitable nodes available to serve this request." When I request a stored procedure from my program (SP is taking 2 minutes to execute) the above error is getting. I believe this is because of Load balancer Time out.…

  Read the article

• Why (and when to) use stored procedures?

  - by mr.b

  What would be appropriate scenario when stored procedures should be used? I stumbled upon implementation where almost whole data manipulation was handled by store procedures, even simplest form of INSERT/DELETE statements were wrapped and used via SP's. So, what's the rationale for using stored procedures in…

  Read the article

• Can I lock tables in an IF statement in MySQL?

  - by MalcomTucker

  This is throwing a syntax error - --from body of a stored proc IF (name = in_name) SET out_id = temp; ELSE LOCK TABLE People WRITE; INSERT INTO People (Name) VALUES (in_name); UNLOCK TABLE; SELECT LAST_INSERT_ID() INTO out_id END IF do I…

  Read the article

• Knowing the type of the stored proc when invoking from C#

  - by dotnetdev

  I am making a windows service to be able to run operations on a sql server database (insert, edit, etc) and invoke Stored Procs. However, is there a way for me to know the type of the SP? When invoking from C#, I need to knof if it is returning 1 value, or more, or none (so I can use executereader, scalar,…

  Read the article

• Detect when a users session has exipred

  - by Steven

  Hi, Can anyone tell me how to detect when a users session has exipred in asp? I want to redirect users to a logged out page once the session has expired Thanks Sp

  Read the article

• How to treat 64-bit words on a CUDA device?

  - by pikkio

  Hi, I'd like to handle directly 64-bit words on the CUDA platform (eg. uint64_t vars). I understand, however, that addressing space, registers and the SP architecture are all 32-bit based. I actually found this to work correctly (on my CUDA cc1.1 card): __global__ void test64Kernel( uint64_t *word ) { …

  Read the article

• Adobe 9 Check box required field

  - by Steven

  Hi, I've created reports in Adboe that have checkobxes and set then to required fields. But when i click the submit button all fields but the check boxes are validated. I.e If i dont complete the required textbox field the report will not submit, but when i do and the required checkbox fields are not…

  Read the article

< Previous Page | 19 20 21 22 23 24 25 26 27 28 29 30  | Next Page >