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
Explain forward - only cursors?
Define inner join? Explain with an example?
What is difference between sql and sql server?
What Is The Difference Between Primary Key & Super Key
Describe in brief system database.
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
What is ddl command?
What are locks in sql?
Explain cdc and sql injection?
What is inner join in sql server joins?
here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d
What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning
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)