Sanjay Dixit
How many parameters can be passed to a MS-SQL stored procedure?
By Sanjay Dixit in .NET on Jul 10 2013
  • sushil kumar
    Jun, 2015 26

    2100 check aspmaterials.blogspot.com

    • 0
  • Bharath Reddy
    Apr, 2014 16

    2,100

    • 0
  • Dheeraj Pandey
    Mar, 2014 26

    2100

    • 0
  • Dheeraj Pandey
    Mar, 2014 26

    2100

    • 0
  • Dheeraj Pandey
    Mar, 2014 26

    2100

    • 0
  • Dheeraj Pandey
    Mar, 2014 26

    2100

    • 0
  • Dheeraj Pandey
    Mar, 2014 26

    2,100

    • 0
  • Dheeraj Pandey
    Mar, 2014 26

    2,100

    • 0
  • Dheeraj Pandey
    Mar, 2014 26

    2,100

    • 0
  • ronak kadia
    Nov, 2013 6

    2100

    • 0
  • ronak kadia
    Nov, 2013 6

    2100

    • 0
  • Aman Jain
    Oct, 2013 23

    Total number of parameters (Input + Output) in a stored procedure is 2100. However, there is no information of how many are for input or output.

    • 0
  • Aman Jain
    Oct, 2013 23

    Total number of parameters in a stored procedure (Input+Output) is 2100. However, there is not any further explanation to how many of this 2100 are for input or output.

    • 0
  • Vivek Gupta
    Oct, 2013 12
  • Mukesh Kumar Tiwari
    Sep, 2013 6

    Parameters per stored procedure (32bit and 64bit) 2,100 Pls refer the link below for more interesting information http://msdn.microsoft.com/en-us/library/ms143432.aspx

    • 0
  • Sagar Pardeshi
    Sep, 2013 6

    You can pass upto 2100 parameters to sql server stored procedure -See http://msdn.microsoft.com/en-us/library/ms143432.aspx

    • 0
  • Prasenjit  Dey
    Aug, 2013 28

    2,100

    • 0
  • Mukesh Kumar
    Aug, 2013 26

    Up to 1024http://dotnet-developers-cafe.blogspot.in/p/sql-interview-part-1.html

    • 0
  • Kareem Syed
    Aug, 2013 25

    We can pass max 2100 parameters.Rgds Kareem Syed www.optimizesql.com/blog

    • 0
  • Kailash Chandra Behera
    Aug, 2013 16

    2,100

    • 0
  • Prasenjit  Dey
    Aug, 2013 5

    2,100

    • 0
  • Anil Kumar
    Jul, 2013 23

    Only 2.

    • 0
  • Anil Kumar
    Jul, 2013 23

    Only 2.

    • 0
  • Abhishek Goswami
    Jul, 2013 22

    Parameters passed in stored procedure (32bit and 64bit) - 2,100

    • 0
  • Sharad Rathore
    Jul, 2013 14

    2,100

    • 0
  • nethaji naidu
    Jul, 2013 10

    2,100

    • 0
  • ashish bathla
    Jul, 2013 10

    2100

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS