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

Post New Answer

More SQL Server Interview Questions

Differentiate between delete and truncate.

0 Answers  


Why we use trigger in sql server with example?

0 Answers  


How you can change a cross join into an inner join?

0 Answers  


Can sql servers link to other servers?

0 Answers  


What are temporal tables in sql server 2016?

0 Answers  






What will happen when a Rollback statement is executed inside a trigger?

1 Answers   Flextronics, Hexaware,


What is Transaction?

2 Answers  


How do you persist objects, permissions in tempdb

1 Answers  


What do you mean by collation recursive stored procedure?

0 Answers  


What are the different ways you can create databases in sql server?

0 Answers  


what are candidate key, alternate key and composite key? : Sql server database administration

0 Answers  


How to enter date and time literals in ms sql server?

0 Answers  


Categories