I need to create a trigger on an MS SQL 2000 table that update a date field when an UPDATE query is executed against the table. How do I set the WHERE portion of the SQL in the query?
Here is what I have so far: CREATE TRIGGER tg_Update_Date ON table AFTER UPDATE AS SET Date = GetDate() WHERE Id = ????? What goes where I have the ????? ? Thanks in advance. Russel ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
