1.

begin transaction

select * from piggy_bank update piggy_bank set coin = 'P' where ID < 30 rollback

rollback,取消指令

2.

begin transaction

select * from piggy_bank update piggy_bank set coin = 'N' where ID < 30 select * from piggy_bank commit

commit,确认指令

 

3.sqlserver 更改密码

sp_password   [   [   @old   =   ]   'old_password '   ,   ]

        {   [   @new   =]   'new_password '   }         [   ,   [   @loginame   =   ]   'login '   ]

sp_password 'abcd','abcd',as