Interested to Buy Any Domain ? << Click Here >> for more details...
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 role playing dimension with two examples? : sql server analysis services, ssas
What is the difference between grant and with grant while giving permissions to the user?
How to provide login information for a new odbc dsn?
How to scale out a federation by Sql statement?
What the different topologies in which replication can be configured?
Do you have any idea about the tcl commands?
What are the differences between stored procedure and the dynamic sql?
What are binary string data types in ms sql server?
Explain Geography datatype in SQL Server
What is the difference between DATETIME2 and DATETIME?
Why do we use stored procedures in sql server?
What are the instances when triggers are appropriate?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What is the purpose of the tempdb database?
What gets stored inside msdb database?
