If there is failure during updation of certain rows, what
will be the state?

Answers were Sorted based on User's Feedback



If there is failure during updation of certain rows, what will be the state?..

Answer / guest

No changes will occur. So the data will be in previous
state only.

Is This Answer Correct ?    18 Yes 0 No

If there is failure during updation of certain rows, what will be the state?..

Answer / lu

The data will rollback

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is the use of MOVE keyword in restore command

3 Answers   IBM,


What is a cube? : sql server analysis services, ssas

0 Answers  


How to use group functions in the select clause in ms sql server?

0 Answers  


How the authentication mode can be changed?

0 Answers  


what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 Answers  






Explain the commands in sql server?

0 Answers  


Can another user execute your local temporary stored procedures?

0 Answers  


How do you open a cluster administrator?

0 Answers  


What is the security model used in sql server 2005?

0 Answers  


What is perspective, have you ever created perspective? : sql server analysis services, ssas

0 Answers  


Can you roll back the ddl statement in a trigger?

0 Answers  


What is the parse query button used for?

0 Answers  


Categories