good morning
how to use transaction in sql server exple i have to update multiple tables in my database but if an error occured i want to annulate(rollback) the operations
thank you
ms sql server and transaction
Moderator: General Moderators
i'm not sure you can do that. However, I do know you can make a backup copy of the database and then restore it if something happens. You might want to look into that.
http://www.mysql.com/doc/en/BACKUP_TABLE.html
http://www.mysql.com/doc/en/RESTORE_TABLE.html
that may be your best and only bet.
http://www.mysql.com/doc/en/BACKUP_TABLE.html
http://www.mysql.com/doc/en/RESTORE_TABLE.html
that may be your best and only bet.
ms sql server and transaction
thank you 