how many no of arguments can be passed in procedures and functions

how many no of arguments can be passed in procedures and
functions

Question Posted / kalki

how many no of arguments can be passed in procedures and functions..

Answer / ranjan&

According to MSDN--> A Function and Procedure can have a
maximum of 2,100 parameters.

Is This Answer Correct ?

13 Yes

2 No

More SQL Server Interview Questions

What is the xml datatype?

What is the use of MOVE keyword in restore command

Explain nested trigger in sql?

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

How to disconnect from a sql server using mssql_close()?

How to list all triggers in the database with sys.triggers in ms sql server?

what is trigger

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

What is the guest user account in sql server? What login is it mapped to it? : sql server security

What is the use of custom fields in report?

What are the character string functions supported by sql server 2005?

How to execute stored procedure and set temp table in sql server?

For more SQL Server Interview Questions Click Here