Answer Posted / elumalai.k
begin transaction
save transcation t
delete from tablename where id=2
select * from tablename
------------------------------------------------------
the value id=2 will be deleted in the tablename
-------------------------------------------------------
rollback transcation t
select * from tablename
---------------------------------------------------------
if u give rollback the deleted values will be seen again
Is This Answer Correct ? | 22 Yes | 3 No |
Post New Answer View All Answers
explain different types of cursors? : Sql server database administration
Why SQL Agent is used?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
How to grant a permission in ms sql server using "grant execute" statements?
What are “lock” hints?
What is shared lock?
How to Update from select query in sql server?
What are the system database in sql server 2005?
How many columns can exist together per table?
What are different types of constraints?
Tell me about builtinadministrator?
What do you understand by sql server agent?
What is application role in sql server database security? : sql server security
What are Row versions of DataRow?
what is create database syntax? : Sql server database administration