Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

maximum number of output parameters we can use in Stored procedure Expand / Collapse
Author
Message
Posted Saturday, November 14, 2009 12:24 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 25, 2014 2:36 AM
Points: 40, Visits: 152
Hi,

Please tell me what is the maximum number of output parameters we can use in Stored procedure.

If this number is different in different versions of sql server like in SQL SERVER 2000, SQL Server 2005 and 2008 then please tell me all.



Thanks
Rajneesh
Post #819044
Posted Saturday, November 14, 2009 1:48 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,646, Visits: 1,947
It is 2100 Parameters, not sure if it has been increased in SQL 2008.


Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
Post #819058
Posted Saturday, November 14, 2009 1:52 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, November 4, 2012 12:23 PM
Points: 1,893, Visits: 3,932
Hi

I have to ask this: What are you trying to do?

Data should be stored top down, not left to right

Greets
Flo



The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL

How to Post Data/Code to get the best Help How to Post Performance Problems
Post #819060
Posted Saturday, November 14, 2009 2:09 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,646, Visits: 1,947
Data should be stored top down, not left to right

Flo


Good Question Flo and wonder if someone would use that many Parameters.



Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
Post #819066
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse