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 do I view a stored procedure in sql server query?

606


What is filter index?

610


Why we use functions in sql server?

599


What is shrink log file?

587


What is the use of floor function in sql server?

655






What is the maximum length of an alert name?

697


how would you store your query in an SSRS report or a Database server?

134


How to stop a loop early with break statements in ms sql server?

658


What is self contained multi valued query?

634


How do I find the sql server database version?

611


What are alternate keys?

656


What programming language would you use to create embedded functions in ssrs?

144


Explain differentiate between a having clause and a where clause?

591


What is the main purpose of having conversation group?

577


What is user-defined functions? What are the types of user-defined functions that can be created?

655