1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what are the limitations of parameters in a storedprocedure

Question Posted / raghavendar


what are the limitations of parameters in a storedprocedure..

Answer / karthik

According to MSDN, SQL Server limits the number of parameters per stored procedure to 2,100

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

how to find nth highest salary

103 Answers   Cognizant, IBM, NexGen, Oracle,

Explain the usage of floor function in sql server.

0 Answers  

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

What security features are available for stored procedure?

0 Answers  

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 Answers  




How can you hide the sql server instances?

0 Answers  

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

0 Answers  

Explain different types of self contained sub query?

0 Answers  

What is Report Server,Report Manager and Report Builder in SSRS 2005?

1 Answers  

Explain system functions or built-in functions? What are different types of system functions?

0 Answers  

mention different types of relationships in the dbms?

0 Answers  

explain declarative management framework (dmf) in sql server 2008?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories