Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VB, C#, and VFP data handling examples
Message
From
12/04/2007 22:28:00
 
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Miscellaneous
Thread ID:
01215120
Message ID:
01215374
Views:
40
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform