About Me

My photo
a Dynamic and Energetic guy.....

Thursday, May 14, 2009

Write a TRIGGER when data INSERT into table

USE SalesOne;
GO
IF OBJECT_ID ('SalesOne.reminder4', 'TR') IS NOT NULL
DROP TRIGGER SalesOne.reminder4;
GO
CREATE TRIGGER reminder4
ON SalesOne.dbo.Assets
AFTER INSERT,UPDATE
AS
--RAISERROR ('Notify Customer Relations', 16, 10);
UPDATE Assets SET LastUpdated = {fn now()}
GO

No comments:

My Masters