According to MSDN, SQL Server limits the number of parameters per stored pr

what are the limitations of parameters in a storedprocedure

Question Posted / karthik

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

Please Help Members By Posting Answers For Below Questions

How do I clean up sql server transaction log?

1125

How to test subquery results with the exists operator?

1167

Describe in brief authentication modes in sql server.

1089

What is executereader?

1004

When we should use @@error?

1037

What is a user-defined function in the sql server and what is its advantage?

1141

how you can move data or databases between servers and databases in sql server? : Sql server administration

1030

What is sql injection? How to protect against sql injection attack?

1041

What are click through reports?

149

How to delete multiple rows with one delete statement in ms sql server?

1075

What is the difference between Clustered and Non-Clustered Index?

1102

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1137

What is the difference between dataadapter and datareader?

1058

What is the recommended total size of your memory optimized tables?

1005

How can you insert values in multiple rows using one Insert statement?

1152