Interested to Buy Any Domain ? << Click Here >> for more details...
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
In which format does an image save in SQL Server database ?
Do you know clustered and non-clustered index?
What are the different types of collation sensitivity in sql server?
How to use old values to define new values in update statements in ms sql server?
What is a View ? Can we insert, Update and delete a view?
What is the purpose of self join?
What is pivot and unpivot?
What are the pre-defined functions in the sql server?
Give me a SQL Query to find out the second largest company?
what is database replication? : Sql server database administration
What are sql azure firewall rules?
What does top operator do?
What is msdb database? : SQL Server Architecture
What is difference between oltp and olap?
What are the restraints imposed on the table design by a merge replication?
