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?
No Answer is Posted For this Question
Be the First to Post Answer
Differentiate between a having clause and a where clause.
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is clr ddl trigger?
What is the difference between DTS and SSIS?
How to access the deleted record of an event?
What is sql server query analyzer?
What is compression - row-level and page-level compression?
What security features are available for stored procedure?
What are cursors? Name four types of cursors and when each one would be applied?
What is a full text index?
Explain the basic concepts of SQL server architecture?
2 Answers College School Exams Tests,
What is replication with database mirroring? : sql server database administration
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)