开发者

How in SQL Server Management Studio 2008 to rollback easily?

开发者 https://www.devze.com 2023-04-07 19:32 出处:网络
I\'m used to setting Oracle\'s tools to not auto-commit, run statements, then click a \'rollback\' button if I\'m not happy with the result. I\'m hoping I\'m overlooking something in开发者_开发知识库

I'm used to setting Oracle's tools to not auto-commit, run statements, then click a 'rollback' button if I'm not happy with the result. I'm hoping I'm overlooking something in开发者_开发知识库 Microsoft's tool...


As far as I remember, you can do it by SET IMPLICIT_TRANSACTIONS ON (also with SET ANSI_DEFAULTS ON for connection.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号