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

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

Question Posted / guest

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?..

The data will rollback

Is This Answer Correct ?

6 Yes

0 No

More SQL Server Interview Questions

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

What is the basic functions for master, msdb, tempdb databases?

How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

How many types of keys are there?

how many no of arguments can be passed in procedures and functions

What is a unique key constraint?

How to access the inserted record of an event?

What is a transact-sql statement batch in ms sql server?

Tell me what is a linked server?

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

How to create view in stored procedure sql server?

For more SQL Server Interview Questions Click Here