--
Phillip B.
----- Original Message -----
From: Adam Haskell
This is the basic idea:
CREATE TRIGGER [UpdateForTime] ON dbo.Products
FOR UPDATE
AS
BEGIN
IF Not ((UPDATE(UpdateTime))
BEGIN
UPDATE dbo.products
SET UpdateTime=getdate()
WHERE Product_id IN (select product_id from inserted)
END
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
