View Single Post
  #3 (permalink)  
Old December 7th, 2004, 03:48 PM
bfurman bfurman is offline
Registered User
 
Join Date: Nov 2004
Location: , , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

update table Products from trigger for update on OrderDetails table:
 minus stock Products where Orderdetail.ProductID = inserted.ProductID

and plus from trigger for delete.


Reply With Quote