what are the limitations of parameters in a storedprocedure
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 |
Is it ok to shrink transaction log?
What is advantage data architect?
Define clusters?
How to read data in a table with "select" statements?
When do you create cluster and noncluster index?
When columns are added to existing tables, what do they initially contain?
How to configure odbc dsn with different port numbers?
How do triggers work?
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.
What is data block and how to define data block size?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
Explain the rules for designing files and file groups in sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)