在analyze window中撤销已执行的sql query

 

when I updated the property with the same window,

I am schokced cuz this affected my daily work and webserver, others can realize this stupied operation in short time.

so please use the following sql query format to test when you are not sure what will happen...

 

 

SET IMPLICIT_TRANSACTIONS on

 

begin tran

sql query goes here   [update AspNetPerf.dbo.PARAM set paramvalue ='19991' where uniquer=33]

Rollback

 

select * from param

 

 

steps:

a.  SET IMPLICIT_TRANSACTIONS on

b.  execute sql query

b.  if you do want to make changes, execute rollback.