OUTPUT clause in INSERT/UPDATE/DELETE statements

re: OUTPUT clause in INSERT/UPDATE/DELETE statements

Joe — Wed, 09 Aug 2006 18:29:58 GMT

Why are all examples provided with an Identity Key - seems to me a pretty cheap way to define a table.

You examples should "reflect" real word scenarious where Identity Keys DO NOT EXist! Too simple to hack!

But nevertheless, thanks for sharing!

re: OUTPUT clause in INSERT/UPDATE/DELETE statements

Jordon — Thu, 07 Sep 2006 22:40:57 GMT

That is great, output cluase, nice feature.

But what about having a insert trigger used with the output clause? You can't have that, why not?

re: OUTPUT clause in INSERT/UPDATE/DELETE statements

top search engine listing — Thu, 28 Sep 2006 16:16:26 GMT

Is there any way to create triggers with SQL Server 2005 just as creating a stored procedure? I've created one trigger as normal query but due to some reason I cant find the created trigger under programmability->database trigger folder.