SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag output Rss

Search for any content tagged output

   Items 1 to 5 of 5   

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.  Read more...
By Mat Richardson 2017/05/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,074 reads

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.  Read more...
By Additional Articles 2016/11/30 | Source: Database Journal | Category: stored procedure
Rating:  Rate this |   Briefcase | 9,690 reads

Getting more done with OUTPUT

Use OUTPUT to perform an INSERT and a DELETE at the same time.  Read more...
By Kenneth Fisher 2016/11/17 | Source: SQLServerCentral.com | Category: output
Rating: |  Discuss |   Briefcase | 2,775 reads

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.  Read more...
By Steve McRoberts 2010/01/20 | Source: SQLServerCentral.com | Category: identity property
Rating: |  Discuss |   Briefcase | 4,127 reads

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.  Read more...
By Additional Articles 2008/06/09 | Source: SearchSQLServer | Category: output
Rating: (not yet rated)  Rate this |   Briefcase | 4,124 reads
   Items 1 to 5 of 5