maximum number of output parameters we can use in Stored procedure

• rajn.knit07

  Right there with Babe

  Points: 714

  More actions

  November 14, 2009 at 12:24 pm

  #137272

  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

• Bru Medishetty

  SSC-Insane

  Points: 23606

  More actions

  November 14, 2009 at 1:48 pm

  #1079402

  It is 2100 Parameters, not sure if it has been increased in SQL 2008.

  ---

  Bru Medishetty

  Blog -- LearnSQLWithBru

  Join on Facebook Page Facebook.comLearnSQLWithBru

  Twitter -- BruMedishetty

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  November 14, 2009 at 1:52 pm

  #1079404

  Hi

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

  Data should be stored top down, not left to right 😀

  Greets

  Flo

• Bru Medishetty

  SSC-Insane

  Points: 23606

  More actions

  November 14, 2009 at 2:09 pm

  #1079410

  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.comLearnSQLWithBru

  Twitter -- BruMedishetty