Answer Posted / umesh roy
Above code spelling are wrong on save Transaction
correct code are below which is executeable
begin transaction
save transaction t
delete from tablename where id=2
select * from tablename
------------------------------------------------------
the value id=2 will be deleted in the tablename
-------------------------------------------------------
rollback transaction t
select * from tablename
Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
Is oracle faster than sql server?
what is a deadlock? : Sql server database administration
Describe the left outer join & right outer join. : sql server database administration
What are the tool windows in sql server management studio? : sql server management studio
What do you mean by 'normalization'?
What are the advantages of mirroring?
Why should you use or avoid select * statements?
How extra digits are handled with numeric data type literals?
What is the difference between index seek vs. Index scan?
How to encrypt data between dialogs?
What is the server name in sql server?
Is there any difference between the primary key and unique key?
Explain various On-Delete options in a DB table. Which is the default option?
What is the return type of executeupdate ()?
Can we use trigger new in before insert?