CreateTRIGGER [dbo].[Trg_TblVisits] ON [dbo].[TblVisits]AFTER INSERT,UPDATE AS BEGINSET NOCOUNT ON; UPDATEA SET LastModifiedDate = GETDATE() FROMTblVisits A INNER JOIN inserted B ONA.VISITID = B.VISITID
END
No comments:
Post a Comment