HI All
does Sql server has command equalent to Rollback to in Oracle. That means when you do some update operation and i want to revertback the original record. If so what is that command.
With Regards,
AHARI
Yes it does:
BEGIN TRAN
UPDATE....<your update statement>
ROLLBACK/COMMIT TRAN
By the way, you should try the T-SQL forum for this sort of question: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=85&SiteID=1
-Jamie
No comments:
Post a Comment