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

how to count datewise data in sqlserver

What is the difference between ddl,dml and dcl commands?

what is package and it uses and how can u call a package

How do I perform an unattended install of sql server 2000?

How to create a ddl trigger using "create trigger" statements?

Can primary key be null?

There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9

What is the maximum length of an alert name?

What is the difference between clustered index and primary key?

What is the Difference Between Primary and Foreign Key?

What are various aggregate functions that are available?

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

For more SQL Server Interview Questions Click Here