what are the limitations of parameters in a storedprocedure
- 1 Answers
- 3350 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is SQL Azure Fabric?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
List the different normalization forms?
What are cursors in ms sql server?
What is function of master database?
How extra digits are handled with numeric data type literals?
What is sub query and its properties?
What can be used instead of trigger?
What are the options which must be set to allow the usage of optimistic models?
How to write a query with a right outer join in ms sql server?
What is store procedure? How do they work? When do you use?
How many instances per computer are there in sql server 2000?
What triggers long term care?
What are various ways to enhance the ssrs report?
Explain SSRS Architecture?
