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
Can you name a few encryption mechanisms in sql server?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What are the properties of the transaction?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
Explain the properties of subqueries in sql server?
What is an sql server agent?
How to stop a loop early with break statements in ms sql server?
How you can move data or databases between servers and databases in sql server?
What is sparse columns of sql server 2008?
What is always encrypted?
Explain the functionalities that views support?
What is the ‘fillfactor’?
What objects does the fn_my_permissions function reports on? : sql server security
What is raiseerror? What is raiseerror?
How important do you consider cursors or while loops for a transactional database?
