No announcements
Found 1553679 threads
-
1 VotesStored procedure executed in stored procedure
Hi IqPerf, You can also use OpenQuery to select data from a Stored Procedure.Answered | 4 Replies | 5078 Views | Created by lgPerf - Wednesday, April 27, 2011 2:12 PM | Last reply by Naomi N - Wednesday, April 27, 2011 3:04 PM
-
1 Votes
execute stored procedure as a dataset
Hi, For use a stored procedure in dataset follow these steps as: In the dataset : Select Stored ...Answered | 2 Replies | 3297 Views | Created by tsql_new - Monday, December 10, 2012 5:46 PM | Last reply by Avanish Tomar - Tuesday, December 11, 2012 6:54 AM -
0 Votes
EXECUTE AS clause with stored procedures
I would be curious to know what you think about EXECUTE AS.Answered | 6 Replies | 7484 Views | Created by Cipherlad - Thursday, August 6, 2009 4:36 PM | Last reply by LeeFAR - Monday, August 10, 2009 2:29 PM -
0 Votes
execution permission to Stored Procedure
If you want the user to have specific execution permissions then you do: grant execute on your_stored_procedure to [the_user] if you want the user to be ...Answered | 1 Replies | 8135 Views | Created by krishna_sql - Friday, March 18, 2011 5:21 PM | Last reply by JustinRush - Friday, March 18, 2011 5:44 PM -
0 Votes
HOW TO EXECUTE A STORED PROCEDURE
One way you can see how the stored-proc is executing is through the PROFILER.Answered | 4 Replies | 5077 Views | Created by justin_rock - Tuesday, November 30, 2010 2:51 PM | Last reply by Manoj Pandey (manub22) - Tuesday, December 7, 2010 10:58 AM -
0 Votes
Executing the Stored procedure
I have a stored procedure that is using try catch block.Answered | 5 Replies | 4922 Views | Created by anki2010 - Friday, April 8, 2011 1:00 AM | Last reply by Paresh Prajapati - Friday, April 8, 2011 12:10 PM -
2 Votes
Count stored procedure executions
If the stored procedure executes something several times inside the stored procedure, for example, with some kind of a loop, then you ...Answered | 2 Replies | 2721 Views | Created by Matt11380 - Monday, February 28, 2011 9:40 PM | Last reply by Noam B - Tuesday, March 1, 2011 7:46 AM -
0 Votes
slow execution of stored procedure
Hi Pranavgaidhani, You could use execution plan to analyze the T-SQL command.Answered | 2 Replies | 1839 Views | Created by Pranavgaidhani - Friday, April 12, 2013 9:58 AM | Last reply by Maggie Luo - Tuesday, April 16, 2013 10:11 AM -
0 Votes
Executing a SQL stored procedure
>>Can anyone advise what code to use for executing a stored procedure and not returning a dataset.Answered | 4 Replies | 608 Views | Created by system243trd - Saturday, April 9, 2016 7:03 AM | Last reply by David_JunFeng - Monday, April 11, 2016 2:36 AM -
0 Votes
Stored procedure execution plans
Hi Sean, Query compilation typically doesn't take too long unless your stored procedures are quite complicated - but I wouldn't expect more than a couple of ...Answered | 3 Replies | 7046 Views | Created by Sean Connolly - Monday, April 12, 2010 6:43 AM | Last reply by Plamen Ratchev - Monday, April 12, 2010 2:26 PM -
0 Votes
Control Store Procedure Execution
there's no direct way to impose this restriction as far as I know apart from implementing a control table based approach where log each instance of execution of procedure for each ...Answered | 1 Replies | 516 Views | Created by Priya Bange - Tuesday, August 7, 2018 1:29 PM | Last reply by Visakh16 - Tuesday, August 7, 2018 1:39 PM -
0 Votes
Executing Multiple Stored Procedure
forum=transactsql ), SQL Server will perform serial execution by default.Answered | 2 Replies | 683 Views | Created by lilutchay - Tuesday, February 12, 2019 5:43 PM | Last reply by Tom Cooper - Tuesday, February 12, 2019 8:15 PM -
0 Votes
Stored procedure execution Timeout
We are running stored procedure to upload data through linked server to application server.Answered | 3 Replies | 5785 Views | Created by DBA_LEARNER - Tuesday, March 19, 2013 8:52 PM | Last reply by Kalman Toth - Thursday, March 21, 2013 4:23 PM -
1 Votes
Controlling Execution in Stored Procedure
A stored procedure will single thread and will execute statements one after the other.Answered | 1 Replies | 4953 Views | Created by Jas_The_Ace - Monday, December 28, 2009 12:38 AM | Last reply by Arnie Rowland - Monday, December 28, 2009 12:47 AM -
0 Votes
execute stored procedure
Hi, I would suggest you to not call the stored procedure directly from orchestration (i.e. .Net assembly) if its ok with your overall system design .Answered | 6 Replies | 6395 Views | Created by sinner1988 - Wednesday, March 14, 2012 10:01 PM | Last reply by Steef-Jan Wiggers - Saturday, March 17, 2012 11:16 AM -
1 Votes
Execute Stored Procedures Asynchronously
I use this slow stored procedure in combination with the Entity Framework 4.0 - objects are created through views - updates, inserts and deletes through ...Answered | 4 Replies | 12211 Views | Created by Marc Loeb - Saturday, November 12, 2011 7:55 PM | Last reply by Marc Loeb - Tuesday, November 15, 2011 2:16 PM -
1 Votes
Urgent - Store Procedure Execution
Please advice is there a way i can check if the store proc execution is completed or not.Answered | 7 Replies | 645 Views | Created by Priya Bange - Sunday, February 7, 2016 6:14 AM | Last reply by Erland Sommarskog - Sunday, February 7, 2016 4:07 PM -
0 Votes
Population table from result obtained by a stored procedure
You can use INSERT EXECUTE, but the number of columns returned by SP should match the prepared table (it could be a temp table with the exact same structure as the expected result).Answered | 1 Replies | 5300 Views | Created by vishal.... _ - Wednesday, March 17, 2010 2:10 AM | Last reply by Naomi N - Wednesday, March 17, 2010 2:23 AM -
0 Votes
dynamic execution of a stored procedure
Hi Darwin101, Please refer to the following ...Answered | 1 Replies | 3445 Views | Created by Darwin101 - Monday, October 3, 2011 3:09 PM | Last reply by Eileen Zhao - Tuesday, October 4, 2011 8:46 AM -
0 Votes
delete a stored procedure while executing
I'm able to drop the sp during execution.Answered | 14 Replies | 3336 Views | Created by prasadbuddhika - Tuesday, August 21, 2012 11:13 AM | Last reply by SQLZealots - Wednesday, August 22, 2012 8:56 AM - Items 1 to 20 of 1553679 Next ›
No announcements
