Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can you set off a trigger based on one column changing?
Message
 
 
À
01/06/2010 21:37:44
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01466971
Message ID:
01466993
Vues:
58
>I did it later.
>
>
>First, really should start doing some of it before , especially when you see certain names who have replied (can easily list off a half-dozen)
>
>Second, UPDATE() function is usually not a good solution - it returns a TRUE simply if the column was involved in an UPDATE statement, regardless of whether the column value actually changed.
>
>third....start thinking quality, not quantity <s>

I know what UPDATE() returns and its pitfalls.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform