No announcements
Found 2262461 threads
-
0 Votesstored procedure sql server with return
If you don't use the RETURN in any place then the execution will go till the end of the procedure and the values will be returned at the end.Answered | 8 Replies | 3030 Views | Created by ELKADIRI - Tuesday, June 19, 2012 9:51 AM | Last reply by Ram Dhilip - Tuesday, June 19, 2012 12:14 PM
-
2 Votes
stored procedure return code
Try this: CREATE PROCEDURE dbo.TestProcedure AS BEGIN PRINT '----------------- In sp before delay -----------------' WAITFOR DELAY '00:00:10' ...Answered | 3 Replies | 3793 Views | Created by Pete Newman - Wednesday, December 14, 2011 10:51 AM | Last reply by HeSitated - Wednesday, December 14, 2011 11:00 AM -
0 Votes
Stored procedure return value
Is it possible now to get a *real* return value of a stored procedure?Answered | 11 Replies | 72887 Views | Created by Tom_A_B - Friday, July 18, 2008 1:09 PM | Last reply by Eldis - Tuesday, May 12, 2009 10:19 AM -
2 Votes
Sql Server stored procedure issue
We call a stored procedure to Sql Server 2008.Answered | 3 Replies | 910 Views | Created by Peter Campanale - Friday, July 22, 2016 2:35 PM | Last reply by Olaf Doschke - Monday, July 25, 2016 2:35 PM -
0 Votes
Convert SQL Server Stored Procedure into MY SQL Stored Procedure
Is it possible to use MS SQL Server in Linux OS ?Answered | 5 Replies | 1804 Views | Created by Prabhu.R - Wednesday, October 14, 2015 8:58 AM | Last reply by Prabhu.R - Thursday, October 15, 2015 4:54 PM -
0 Votes
Question on SQL Server Stored procedure
>But which result would it return from the first procedure?Answered | 3 Replies | 3642 Views | Created by Manisha_G - Wednesday, August 17, 2011 8:14 PM | Last reply by Chirag Shah - Wednesday, August 17, 2011 11:16 PM -
0 Votes
Extended stored procedures in SQL Server
Please see the links ...Answered | 5 Replies | 6104 Views | Created by CSharp Enthusiast - Friday, December 2, 2011 11:26 PM | Last reply by CSharp Enthusiast - Tuesday, December 6, 2011 10:48 PM -
0 Votes
Store Procedures in Sql Server 2008
BOL: Create a Stored Procedure BOL: SQL Stored Procedures BOL: CREATE PROCEDURE ...Answered | 6 Replies | 1113 Views | Created by Engr. Zabih Ullah - Wednesday, October 29, 2014 3:52 PM | Last reply by Kalman Toth - Wednesday, October 29, 2014 6:23 PM -
1 Votes
return column names in stored procedure sql 2008
The user will have a series of textboxes that are the column names being returned from select procedures.Answered | 7 Replies | 10131 Views | Created by DaveDB - Wednesday, September 28, 2011 7:31 PM | Last reply by Mariano Gomez - Wednesday, September 28, 2011 8:31 PM -
0 Votes
Stored Procedure Return Problem
ms_insRepairOrderLinesDup @LineID, @NewLineID output; Also you should not use the stored procedure return value to ...Answered | 3 Replies | 955 Views | Created by David Chase89 - Thursday, July 24, 2014 5:12 PM | Last reply by davidbaxterbrowne - Thursday, July 24, 2014 7:26 PM -
3 Votes
Stored Procedure Language in SQL Server
Yes, With SQL Server 2005 and above you can use .NET languages to create stored procedures.Answered | 3 Replies | 6184 Views | Created by Raptor_45 - Tuesday, March 5, 2013 4:49 AM | Last reply by Vishal Gajjar - Tuesday, March 5, 2013 7:03 AM -
5 Votes
Return Value in stored Procedure
But you should generally prefer a return value over an out param.Answered | 5 Replies | 2517 Views | Created by A Shashi - Monday, June 18, 2012 1:11 PM | Last reply by Chuck Pedretti - Monday, June 18, 2012 1:34 PM -
0 Votes
Sql Server Stored Procedure Error
The function Returns the last identity value, inserted in the current Batch; if you haven't inserted a row, the functions Returns a NULL value and that's the reason for the error.Answered | 2 Replies | 2455 Views | Created by diddi10 - Wednesday, April 3, 2013 9:24 PM | Last reply by Olaf Helper - Thursday, April 4, 2013 5:27 AM -
2 Votes
SQL Server Stored Procedure Standards
Use of proper error msg to return error msg and procedure @@ERROR_MSG or @@ERROR_PROCEDURE.Answered | 10 Replies | 3882 Views | Created by ITBobbyP - Tuesday, January 6, 2015 3:08 PM | Last reply by Shivendra Kumar Yadav - Wednesday, January 7, 2015 2:45 PM -
0 Votes
Return in stored procedure
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.seAnswered | 4 Replies | 2600 Views | Created by rajemessage - Wednesday, April 25, 2012 2:01 PM | Last reply by Erland Sommarskog - Monday, April 30, 2012 9:07 AM -
0 Votes
SQL server Procedure stores plan
And this applies both to plans to stored procedures and ad-hoc queries.Answered | 6 Replies | 1605 Views | Created by vikas kumar pathak - Sunday, December 15, 2013 1:11 PM | Last reply by TiborK - Friday, June 6, 2014 12:54 PM -
0 Votes
stored procedure return table header
Ed Price (a.k.a User Ed), SQL Server Experience Program Manager (Blog, Twitter, Wiki)Answered | 2 Replies | 12863 Views | Created by boobyy - Friday, June 20, 2008 4:29 AM | Last reply by Ed Price - MSFT - Friday, May 11, 2012 4:26 AM -
0 Votes
Stored Procedure with multiple return types
I made a separate stored procedure which has the exact fields I wanted.Answered | 2 Replies | 5246 Views | Created by chrischang03 - Friday, May 28, 2010 3:22 PM | Last reply by chrischang03 - Sunday, May 30, 2010 6:23 PM -
3 Votes
Stored Procedures in SQL
In SQL Server 2000, the overhead was much larger.Answered | 17 Replies | 9632 Views | Created by Shobin Mathew - Wednesday, May 28, 2008 1:37 PM | Last reply by Jim McLeod - Wednesday, December 1, 2010 10:28 PM -
2 Votes
Know if Sql Server Stored Procedure is encrypted or not
syscomments works with SQL 2000, but it's a deprecated view and won't work with future SQL Server versions.Answered | 4 Replies | 9230 Views | Created by Ori_ - Monday, October 29, 2012 11:54 AM | Last reply by Olaf Helper - Wednesday, October 31, 2012 5:20 PM - Items 1 to 20 of 2262461 Next ›
No announcements
