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 are advantages of ssrs or why we should use ssrs?
What is the full meaning of dml?
Where are sql server user names and passwords stored in sql server?
What is the use of =,==,=== operators?
What is difference between inner join and join?
What are difference between Cluster index and Non-Cluster index?
What is meant by dirty read?
Explain nested trigger in sql?
What are pages and extents? : SQL Server Architecture
What is failover clustering overview?
Explain left outer join and right outer join?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is the current limitation of the size of SQL Azure DB?
Can you pass expressions to stored procedure parameters?
Do you know what are acid properties of transaction?
