Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / elumalai.k
begin transaction
save transcation t
delete from tablename where id=2
select * from tablename
------------------------------------------------------
the value id=2 will be deleted in the tablename
-------------------------------------------------------
rollback transcation t
select * from tablename
---------------------------------------------------------
if u give rollback the deleted values will be seen again
| Is This Answer Correct ? | 22 Yes | 3 No |
Post New Answer View All Answers
What are the advantages of log shipping?
What is sql server used for?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
How many primary keys are possible in a table?
How to rebuild master databse?
Explain what are sparse columns?
What is built-in function?
What is molap and its advantage? : sql server analysis services, ssas
What do you understand by physical_only option in dbcc checkdb?
How to create an index on an existing table in ms sql server?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
How do you drop an index?
How does stuff differ from the replace function?
What is an expression in ms sql server?
How to create a login account in ms sql server to access the database engine using "create login" statements?
