what are the limitations of parameters in a storedprocedure
- 1 Answers
- 3050 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Explain what is it unwise to create wide clustered index keys?
What are out-of-range errors with date and time literals?
What is the difference between nvl and nvl2?
What do you understand by intent locks?
Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?
What are the lambda triggers?
What happens if null values are involved in string operations?
how do u do Performance tunning ?
1 Answers Infodat Technologies, Satyam,
What are the difficulties faced in cube development? : sql server analysis services, ssas
What do you mean by normalisation?
What are the aggregate and scalar functions?
What is the difference between primary key and unique constraints?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
