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
本文转自鹅倌51CTO博客，原文链接： http://blog.51cto.com/kaixinbuliao/884992，如需转载请自行联系原作者
