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 |
What are the benefits of normalization?
Explain the functionalities that views support?
What is the difference between push and pull subscription? : sql server replication
one table has four field id,name,design,salary. i have to find maximum salary .
What is the difference between left and right outer join?
How to update muliple row in single query?
How can you set the threshold at which sql server will generate keysets asynchronously?
What is a trigger what are the advantages of trigger?
If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?
What is postgresql server?
What stored by the model? : sql server database administration
How to choose all records from the table?
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)