Does there have any undo or rollback function in SQL server?

When we update or delete data... it's very serious and seem to no choice to rollback. How does everyone to control this part of situation?

thanks for the opinion.As you have posted a question in the articles section it is being moved to SQL Server Forum.|||

Quote:

Originally Posted by debasisdas

As you have posted a question in the articles section it is being moved to SQL Server Forum.

sorry.. and thank you.|||

Quote:

Originally Posted by Gison

When we update or delete data... it's very serious and seem to no choice to rollback. How does everyone to control this part of situation?

thanks for the opinion.

im my case i have a backup routine which runs every night, can you not restore from a backup?|||

Quote:

Originally Posted by Gison

When we update or delete data... it's very serious and seem to no choice to rollback. How does everyone to control this part of situation?

thanks for the opinion.

yes. you can use transaction to handle this situation.
some commands are there

BEGIN TRANSACTION
<sql code>
COMMIT / ROLLBACK TRANSACTION

for more use the msdn help.|||You can always rollback the transaction before commiting it.