Information générale
Forum:
Microsoft SQL Server
Versions des environnements
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement