本文介绍了如何回滚我的更新查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
UPDATE <table name> SET machine_incharge='Expense Approver1', active_machine='yes'
不幸的是在没有条件的情况下执行了将近800行,请帮助我回滚查询. 在此先感谢 问候 vamsi krishna j
unfortunately executed with out where condition it is effected nearly 800 rows please help me to roll back the query. Thanks in Advance Regards vamsi krishna j
推荐答案Rollbach不适用于DML语句. 它必须具有开始交易"或开始交易" 试试这个: Rollbach does not work with DML statement. It must have a "begin tran" or "begin transaction" Try this: begin tran test Update salesproposal set statuscode = 4 where so_id = 47888 UPDATE <table name=""> SET machine_incharge='Expense Approver1', active_machine='yes' end tran; </table>
现在您可以 要么
now you can either
rollback tran test或
or
Commit tran test
如果未在事务中完成,则无法回滚. 为了对任何查询使用回滚,必须从 BeginTransaction [ ^ ]方法. 上面的链接提供了给定事务的提交和回滚示例. If it was not done in a Transaction, then you cannot roll it back. In order to use a rollback on any query, you have to start with BeginTransaction[^] method. The link above has an example of both a Commit and Rollback for a given transaction.
更多推荐
如何回滚我的更新查询
发布评论