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
What is data file in computer?
Which tools are available to manage SQL Azure databases and servers?
What is scrollable cursor?
What are the advantages of having an index on the sql server?
What is the difference between implicit and explicit transaction?
explain how to create a new schema in a database? : Sql server database administration
What is key attribute?
What is the use of @@spid?
How does normalization work?
How to loop through result set objects using odbc_fetch_row()?
What is the command dbcc checkdb used for?
what is the system function to get the current user's user id? : Sql server database administration
Write a sql query to display the current date?
How do database indexes work?
how to overcome kernel isssues
