Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VB, C#, and VFP data handling examples
Message
De
12/04/2007 22:28:00
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro et .NET
Divers
Thread ID:
01215120
Message ID:
01215374
Vues:
39
Here it is
http://sqlservercode.blogspot.com/2006/10/hello-output-see-you-later-trigger-or.html


Thanks for the link. Yeah, I agree with the article, and that's the way I present it when I do sessions on T-SQL '05.

OUTPUT is a great shortcut if you want immediate feedback on what was inserted or changed. For years, developers had to do round-trips back to the server to get PK values, calculated fields, etc...now they have a better way.

But yes, it shouldn't be used in place of triggers. Audit trail functionality belongs in triggers.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform