Friday, June 29, 2012

How to Create Triggers in Sql server


CREATE TRIGGER Management.ForCustomers
ON Management.Customers
AFTER INSERT
AS
BEGIN
    INSERT INTO Management.DatabaseOperations
    VALUES(default, N'Customers', SUSER_SNAME(), 
        N'Processed a deposit', GETDATE())
END
GO

No comments:

Post a Comment