Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @chk tinyint
- SET @chk = 0
- Begin Transaction [Trans_Name] -- Trans_Name 交易名稱可自訂或者是不寫
- -- 可編寫多個 SQL 指令
- INSERT Test(Name1) values('Riva')
- SELECT SCOPE_IDENTITY()
- IF @@Error <> 0 BEGIN SET @chk = 1 END
- IF @chk <> 0 BEGIN -- 若是新增資料發生錯誤
- Rollback Transaction [Trans_Name] -- 復原所有操作所造成的變更
- END
- ELSE BEGIN
- Commit Transaction [Trans_Name] -- 提交所有操作所造成的變更
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement