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 do you understand by sql server agent?
What is the command used to get the version of sql server?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
How to use the inserted and deleted pseudo tables?
Explain in brief how sql server enhances scalability of the database system?
How to make remote connection in database?
Why and when do stored procedure recompile?
how to retrive only second row from table in sql server 2000?
What is trigger and different types of Triggers?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
Does sql server use t sql?
Explain what are various ways to enhance the ssrs report?
Oracle (3253)
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)