General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2005
>Hey, Evan,
>
>As Sergey said, that's correct - however, I *believe* that the UPDATE function will return a value of TRUE if the column was merely specified in an UPDATE statement (regardless of whether it was actually changed).
>
>If that's the case, you may be updating the date field more frequently than desired.
>
>If so, you can add an " and (inserted.repdate <> deleted.repdate or inserted.repstaff <> deleted.repstaff)" in the WHERE clause.
Hi Kevin. Important distinction. Will change the code.
Wrapping my head around how different the SQL Server triggers are than VFP, especially the inserted and deleted cursors.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only