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
If we delete pack Spec what will be the status of pack Body ?
What is unique key constraint?
How can I add Reporting Services reports to my application?
How many types of stored procedures are there in sql server?
Explain table valued parameters in sql server? Why tvp used?
What is the simplest way to create a new database in ms sql server?
What is the difference between index seek vs. Index scan?
Determine when an index is appropriate?
How to update values in a table with update statements in ms sql server?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What is an execution plan?
how you can list all the tables in a database?
What is single-user mode?
What is the Difference Between Primary and Foreign Key?
What triggers long term care?
