Kaimuri
Guest
|
 Posted: Thu Jan 06, 2005 3:30 pm Post subject: INSTEAD OF TRIGGER-WITHOUT ROLLBACK |
 |
|
I saw a comment in a book that in this INSTEAD OF Trigger, the fact that
there is no rollback is an advantage. How is that?
CREATE TRIGGER InsOrdDet ON [Order Details] INSTEAD OF INSERT AS DECLARE
@qty int SELECT @qty=quantity FROM Inserted IF @qty<=(SELECT UnitsInStock
FROM Products P JOIN Inserted I
ON P.ProductID=I.ProductID)
INSERT INTO [Order Details]
SELECT * FROM Inserted
ELSE
RAISERROR('Not enough products in stock', 16, 1) |
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Private messages
Log in
