[MSSQL] 만약을대비 롤백준비 --

Update, Insert, Delete 시...
롤백준비를 해두는 습관을 둬야..

-- begin tran start
--
-- update DSPTB_EZ_VndrBaseInfo
-- SET VndrID = um.UserID
--  , VndrPswd = um.Password
-- from dbo.DSPTB_EZ_VndrBaseInfo as vbi
-- inner join DSPTB_ZZ_UserMgm as um
--  on vbi.VndrCode = um.VendorCode
-- where vbi.VndrID like 'zz%' and um.UserType = 'Z01E00'
-- --commit tran start
-- --rollback tran start