OUTPUT Clause Basics (For Inserts and Deletes)

When INSERTING or DELETING rows from a table, the OUTPUT clause can be used to return a dataset containing the changes made. Mat Richardson explains how.

How to Get the Output of a Stored Procedure into a Table

Putting the output of a stored procedure into a table provides you multiple options for parsing and using the output with other TSQL commands. Read on to learn more.

Getting more done with OUTPUT

Use OUTPUT to perform an INSERT and a DELETE at the same time.

Output Parameter

Retrieving Identities on set-based inserts

Learn a foolproof way to get identity values for multi-row inserts with the OUTPUT clause in SQL Server 2005 without using a cursor.

T-SQL - What is the output of the statement

Using the OUTPUT clause for practical applications

Learn how using the OUTPUT clause in SQL Server 2005 queries simplifies T-SQL code and returns results of rows changed by an INSERT, UPDATE or DELETE SQL command.

Are clustered index columns actually usable in non-clustered indexes?

I have read that non-clustered indexes are built using the clustered index keys. Does that mean that explicitly including columns present in a clustered index in the definition of a non-clustered index is redundant? Suppose I have a clustered index on TransactionDate, and want to query by (WorkOrder, TransactionDate) Should I declare the non-clustered index […]

RE: Using Char(13) to insert a return in a note field.

This is a shot in the dark.. but have you tried this : CHAR(13) + 'Comment 1' + ': ' + rtrim(so.comments_1) + CHAR(13) + 'Comment 2' + ': ' + rtrim(so.comments_2) + CHAR(13) + 'Comment 3' + ': ' + rtrim(so.comments_3) + CHAR(13) + 'Comment 4' +': ' + rtrim(so.comments_4) AS Record_Notes if that […]

RE: Unknown sa password

Unfortunately it was with SQL authentication. I'm tempted to try reinstalling SQL but I'm not sure of the ramifications.