No announcements
Found 569549 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 | 5059 Views | Created by lgPerf - Wednesday, April 27, 2011 2:12 PM | Last reply by Naomi N - Wednesday, April 27, 2011 3:04 PM
-
0 Votes
stored procedure
Stored procedure basics http://msdn.microsoft.com/en-us/library/ms191436(v=SQL.90).aspx Types of Stored ...Answered | 4 Replies | 4414 Views | Created by Classic Run - Friday, April 30, 2010 1:53 AM | Last reply by Ramesh Rathod - Friday, April 30, 2010 10:30 AM -
0 Votes
stored procedure
I'm trying to make a stored procedure in a small database I created.Answered | 3 Replies | 5043 Views | Created by Classic Run - Friday, April 30, 2010 2:10 AM | Last reply by eralper - Thursday, May 6, 2010 11:18 AM -
3 Votes
Difference between Stored Procedure and extended Stored Procedure
http://www.nullskull.com/q/10014003/tell-me-the-difference-between-stored-procedure-and-extended-stored-procedure.aspx https://stackov ...Answered | 4 Replies | 1170 Views | Created by MU DBA - Wednesday, August 8, 2018 11:18 AM | Last reply by Erland Sommarskog - Wednesday, August 8, 2018 9:48 PM -
0 Votes
Stored Procedures
Compilation step is required only once when the stored procedure is created.Answered | 6 Replies | 2553 Views | Created by shivashankara - Wednesday, June 13, 2012 9:23 PM | Last reply by Erland Sommarskog - Wednesday, June 13, 2012 10:00 PM -
0 Votes
stored procedure
Hi Surya, You can use the generate script wizard to script out the procedure definition to a .sql file and then execute the .sql file on other server.Answered | 2 Replies | 882 Views | Created by Surya.chamala - Monday, December 9, 2013 4:44 PM | Last reply by Alankar Chakravorty - Monday, December 9, 2013 4:57 PM -
0 Votes
Store Procedure
Then inside the SP use the temp table, check here.Answered | 4 Replies | 3381 Views | Created by Surjya - Friday, March 30, 2012 5:38 AM | Last reply by Manoj Pandey (manub22) - Friday, March 30, 2012 6:26 AM -
0 Votes
A Stored Procedure to Create a Set of Stored Procedures
If the procedures are the same for every database why not just put them in the 'model' database and the create database statement will copy them to the new database.Answered | 3 Replies | 4183 Views | Created by Nick Olsen - Tuesday, October 19, 2010 2:52 PM | Last reply by Nick Olsen - Tuesday, October 19, 2010 3:11 PM -
0 Votes
Stored Procedure
If I understand this correctly, you first run a stored procedure that saves data into a table.Answered | 8 Replies | 3833 Views | Created by Binggoy - Monday, October 3, 2011 5:08 AM | Last reply by Steen Schlüter Persson - DK - Monday, October 3, 2011 8:39 AM -
0 Votes
Convert Existing Stored Procedure To CLR Stored Procedure
Your stored procedure is almost completely SQL statements, so converting it to .NET would not only be slower, but possibly less secure (because users would need direct table access).Answered | 1 Replies | 6944 Views | Created by azinyama - Monday, November 5, 2012 8:55 AM | Last reply by Bob Beauchemin - Monday, November 5, 2012 5:59 PM -
0 Votes
Create a stored procedure within another stored procedure
Hi mr gvee i want to create a stored procedure that get name of database and create four stored procedure(INSERT,UPDATE,DELETE,SELECT) for every ...Answered | 3 Replies | 3494 Views | Created by saeed zarei - Thursday, March 28, 2013 3:40 PM | Last reply by Naomi N - Thursday, March 28, 2013 4:14 PM -
0 Votes
stored procedure
http://blog.sqlauthority.com/2007/04/13/sql-server-stored-procedures-advantages-and-best-advantage/ Best Regards, Iric Please ...Answered | 3 Replies | 2522 Views | Created by suresh Nelluri - Tuesday, August 28, 2012 2:27 PM | Last reply by Iric Wen - Thursday, August 30, 2012 7:26 AM -
1 Votes
stored procedure
Ofcourse you can use OUTPUT to return data from a stored procedure, you can also use OPENQUERY or a temp table to capture the ...Answered | 8 Replies | 3241 Views | Created by SirIndian - Tuesday, May 8, 2012 7:14 AM | Last reply by vinaypugalia - Tuesday, May 15, 2012 4:56 AM -
0 Votes
stored procedure
How to optimise stored proceedure?Answered | 4 Replies | 2437 Views | Created by valavalas - Wednesday, March 21, 2012 11:17 PM | Last reply by Kalman Toth - Thursday, March 22, 2012 1:04 AM -
0 Votes
Reference a Stored Procedure from another Stored Procedure.
The procedure can then use object_name(@@procid) to get the name of the procedure.Answered | 6 Replies | 4339 Views | Created by holt.rh - Monday, January 10, 2011 5:52 PM | Last reply by holt.rh - Tuesday, January 11, 2011 1:08 PM -
0 Votes
stored procedure
Separate Stored Procedures would be faster as there will be no if conditions and more manageable-------------------------------------------------------- Surender ...Answered | 2 Replies | 2045 Views | Created by nikijain - Thursday, June 21, 2012 12:10 PM | Last reply by --CELKO-- - Thursday, June 21, 2012 4:34 PM -
0 Votes
stored procedure
but when i run the script, it prompts error message, then i have to add "GO" at the end of each stored pro. why?Answered | 1 Replies | 717 Views | Created by --_-- - Thursday, October 17, 2013 3:56 PM | Last reply by Olaf Helper - Thursday, October 17, 2013 4:03 PM -
1 Votes
Stored procedure
Also, when I execute the stored procedure in SQL all commands runs successfully.Answered | 11 Replies | 988 Views | Created by ErikVatsvaag - Thursday, July 17, 2014 11:34 AM | Last reply by Kalman Toth - Friday, July 18, 2014 12:39 PM -
1 Votes
Call a stored procedure from a stored procedure
Hi Dave, According to your code, we are confused that which one of stored procedure need to be inserted into the one result.Answered | 5 Replies | 1443 Views | Created by Dave Parker - Saturday, October 5, 2013 2:30 AM | Last reply by Ch. Rajen Singh - Sunday, October 13, 2013 1:46 AM -
0 Votes
stored procedure
hey guys I need help on how to create a stored procedure in SQL Server Management Studio Please dont ask one line questions your search is as good as mine.Answered | 4 Replies | 1839 Views | Created by dennismwanza - Monday, June 1, 2015 11:11 PM | Last reply by Shanky_621 - Tuesday, June 2, 2015 7:24 AM - Items 1 to 20 of 569549 Next ›
No announcements
