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 the different topologies in which replication can be configured?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
Which rendering formats are affected by the pagesize properties?
What is the significance of null value and why should we avoid permitting null values?
What is difference between materialized view and view?
How does clustered and non clustered index work?
Characterize join and name diverse sorts of joins?
List types of tables in SQL Azure?
Explain how would you store your query in an SSRS report or a Database server?
Explain about SQLOS?
What is field in algebra?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What is hot add cpu in sql server 2008?
what is a transaction and what are acid properties? : Sql server database administration
How is foreign key related to primary key?
