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