Difference between FOR and UPDATE
Database
3
Posts
3
Posters
0
Views
1
Watching
-
hi friends, Is there is any major core difference between FOR and UPDATE trigger, or just the name change due to versions SQL 7 & SQL 2000.Plese reply.
-
hi friends, Is there is any major core difference between FOR and UPDATE trigger, or just the name change due to versions SQL 7 & SQL 2000.Plese reply.
You CREATE TRIGGER [TRIGGER NAME] ON [dbo].[AddressMenuItems] FOR INSERT, UPDATE, DELETE [choose one of those]. AS ... That's the syntax, and it is prompted by the SQL Server when you create a new trigger. There is no such thing as "Trigger FOR" without either INSERT / UPDATE or DELETE. I hope that helps. Best Bigfootguy