what are the limitations of parameters in a storedprocedure
- 1 Answers
- 3348 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 |
Which is better statement or preparedstatement?
What is Cross Join and in which scenario do we use Cross Join?
What is mapping schema?
What are the differences between triggers and stored procedures?
What are the recovery models for a database?
What are the different types of replication? How are they used?
Explain different backup plans?
What is a cursor, index in sql?
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
How to truncate a table first before running a package?
hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution
Explain some stored procedure creating best practices or guidelines?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
