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

What are the differences between having and where clause.

920

What is difference between view and materialized view?

889

What is data compression?

941

List out a number of the wants to setup a SQL Server failover cluster?

1007

What is sql azure database?

205

Explain about SQLOS?

946

what is a self join? : Sql server database administration

962

How to create nested stored procedure?

949

What is temporal table?

825

What do you understand by physical_only option in dbcc checkdb?

933

What will happen if a column containing char type data is changed to the nchar data type?

1042

How to return the date part only from a sql server datetime datatype?

1022

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

901

How to find Duplicate Records In table?

959

What is the use of toad or sqldbx.?

1099