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
1 01 101 01010
What are the advantages of using cte?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
Write a SQL queries on Self Join and Inner Join.
How to use copy and concatenate commands in SQL?
Explain difference between control flow and data flow?
What is the difference between writing data to mirrored drives versus raid5 drives
What is Command line parameters in PLSQL.?
What is the difference between for xml raw and for xml auto?
What is indexing and its types?
What is SubQuery in SQL Server 2008
Which are new data types introduced in sql server 2008?
what is normalization? Explain different levels of normalization? : Sql server database administration
How do I make a resultset scrollable?
What are the filtered indexes?