Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do I Trigger on particular rows based on date periods.
Yep, I appreciate that info about the particular columns being updated and I have seen it in the manual, but I still need to evaluate the value of the date field in the row that the trigger is reporting a change on. I presume part of the code would look like this...I'm having trouble with the...- Scagman
- Post #3
- Forum: Microsoft SQL Server: Programming
-
How do I Trigger on particular rows based on date periods.
Sql 7.0 on w2000 I want to be notified when a value is changed in a column but only for particular rows.... eg. the pertinent data is Field Name Type Value ---------- ----- ------- Date1 Smalldatetime dd/mm/yy field1 smallint 0 or -1...- Scagman
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
