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

Answer Posted / ranjan&

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

Is This Answer Correct ?    13 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to retrieve error messages using mssql_get_last_message()?

539


Why we use functions in sql server?

524


What are the differences between union, intersect, and minus operators?

584


Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

134


When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

507






What do you mean by normalisation?

508


How do you drop an index?

507


Indexes are updated automatically is the full-text index also updated automatically?

629


What are four major operators that can be used to combine conditions on a where clause?

601


Mention what are the core components of ssrs?

210


Difference between Sql server reporting services and Crystal reports?

124


List out the different types of locks available in sql server?

564


How to connect sql server management studio express to sql server 2005 express?

586


What is a cache in ssrs?

110


What is a periodical index?

510