SQL Server 2008中SQL应用之一“死锁(Deadlocking)”

应用复制use AdventureWorks go SET NOCOUNT ON SETTRANSACTIONISOLATIONLEVELSERIALIZABLE WHILE 1=1 BEGIN BEGIN TRAN UPDATE Purchasing.Vendor SET CreditRating = 1 WHERE VendorID = 90 UPDATE Purchasing.Vendor SET CreditRating = 2 WHERE VendorID = 91 COMMIT TRAN END 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.