點降sql server冇commit 制?

mingming123

execute 錯sql 係唔係冇得roll back?

kok10958

yjfoeg

sql server冇預你咁玩法
正如樓上所講, 可以自己寫transaction , 做Commit or Rollback

KinChungE

你用邊套sql server先
mssql? mysql/mariadb?  oracle db?
不過無論任何一套, 想有得rollback都要事前begin transaction

mingming123

你用邊套sql server先
mssql? mysql/mariadb?  oracle db?
不過無論任何一套, 想有得rollback都要事 ...
KinChungE 發表於 2016-5-7 21:50

    microsoft sql server,
    我用oracle sql developer , 你行完D sql, 想禁一次commit, 先代表save左入db, 但你sql server 就冇

mingming123

回覆 5# toylet


    唔記得落where clause

henrietta

點解錯先? 寫錯嘢? 咁成個 IT 部 咩....
toylet 發表於 2016-5-8 00:31

試過返工第一日就叫我用sql改價錢
一個唔小心無落where......
全部貨品連IPHONE都只係售$1688

hongkong_netcop

See example:

1. USE AdventureWorks;
   
2. GO
   
3. BEGIN TRANSACTION;
   
4. 
   
5. BEGIN TRY
   
6.     -- Generate a constraint violation error.
   
7.     DELETE FROM Production.Product
   
8.     WHERE ProductID = 980;
   
9. END TRY
   
10. BEGIN CATCH
    
11.     SELECT
    
12.         ERROR_NUMBER() AS ErrorNumber
    
13.         ,ERROR_SEVERITY() AS ErrorSeverity
    
14.         ,ERROR_STATE() AS ErrorState
    
15.         ,ERROR_PROCEDURE() AS ErrorProcedure
    
16.         ,ERROR_LINE() AS ErrorLine
    
17.         ,ERROR_MESSAGE() AS ErrorMessage;
    
18. 
    
19.     IF @@TRANCOUNT > 0
    
20.         ROLLBACK TRANSACTION;
    
21. END CATCH;
    
22. 
    
23. IF @@TRANCOUNT > 0
    
24.     COMMIT TRANSACTION;
    
25. GO

複製代碼

Source: http://stackoverflow.com/questio ... r-management-studio

dvd-rw

試過返工第一日就叫我用sql改價錢
一個唔小心無落where......
全部貨品連IPHONE都只係售$1688 ...
henrietta 發表於 8-5-2016 10:45

    咁正 你唔應該轉工啦.....