what are the limitations of parameters in a storedprocedure



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

what is the sql equivaent of the dataset relation object ?

0 Answers  


Explain the categories of stored procedure?

0 Answers  


Explain concepts of analysis services?

0 Answers  


How many full-text indexes can a table have?

0 Answers  


What is repeatable read?

0 Answers  






Explain about system database?

0 Answers  


How do you create an execution plan?

0 Answers  


Define clusters?

0 Answers  


What is t-sql script to take database offline – take database online.

0 Answers  


Define full outer join?

0 Answers  


What is difference between Triggers and store procedure?

2 Answers  


What is a collation?

0 Answers  


Categories