How to get a list of columns using the "sp_help" stored procedure in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?
What is the difference between a Application Server and a Database
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
Why normalization is used?
How many types of TRIGGERS are there in MS SQL Server?
8 Answers CarrizalSoft Technologies, TCS, United Healthcare,
Explain filtered indexes?
Can we passed multiple recordset(set of records) using a Stored Procedure
What is default port number for sql server 2000?
Define tool Manage Statistics in SQL Server 2000 query ?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
what operator performs pattern matching?
Explain atomicity?
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)