Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How do we rollback the table data in SQL Server

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


Please Help Members By Posting Answers For Below Questions

1 01 101 01010

2004


What are the advantages of using cte?

951


Why I am getting "the microsoft .net framework 2.0 in not installed" message?

914


Write a SQL queries on Self Join and Inner Join.

985


How to use copy and concatenate commands in SQL?

1064


Explain difference between control flow and data flow?

904


What is the difference between writing data to mirrored drives versus raid5 drives

872


What is Command line parameters in PLSQL.?

1058


What is the difference between for xml raw and for xml auto?

974


What is indexing and its types?

962


What is SubQuery in SQL Server 2008

963


Which are new data types introduced in sql server 2008?

988


what is normalization? Explain different levels of normalization? : Sql server database administration

1210


How do I make a resultset scrollable?

909


What are the filtered indexes?

976