what are the limitations of parameters in a storedprocedure

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


Please Help Members By Posting Answers For Below Questions

How to make conditional sum in ssrs?

132


What are the mathematical functions supported by sql server 2005?

552


How many columns can exist together per table?

709


What is CTE in SQL

542


What are the grouping functions?

532






What are scalar functions in sql?

613


How to generate create procedure script on an existing stored procedure?

514


How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

539


What is the difference between stored procedure and user defined functions?

629


How do you rename a table in sql server?

494


How is a full-text index updated?

542


Explain what is public role in sql server?

584


What is use of except clause? How it differs from not in clause?

602


What is a mutating table error and how can you get around it?

538


We need to perform what steps in the following order to work with a cursor?

715