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 is the function of sql server agent windows service?
If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?
What is MSDE?
Can you please differentiate between a primary key and a unique key?
Define tool Manage Statistics in SQL Server 2000 query ?
SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.
What is a group function explain with an example?
How do you trace the traffic hitting a sql server?
how do u do Performance tunning ?
1 Answers Infodat Technologies, Satyam,
What are the types of table?
Mention the 3 ways to get a count of the number of records in a table.
What command do we use to rename a database?
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)