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
What is logon trigger?
When columns are added to existing tables, what do they initially contain?
How do I open port 1433?
Is INSTEAD OF trigger directly applicable to Table ?
What is usually the first word in a sql query?
What is the purpose of indexing?
How to convert character strings into numeric values?
Can a table have 2 foreign keys?
How to add an address record into adventureworkslt?
what is denormalization? : Sql server database administration
What is SQL Azure?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What do you mean by data manipulation language?
Can we deploy SSRS reports on our personal website?
How to create a local temporary stored procedure?
