Click here to monitor SSC
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 4 of 4   

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,163 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: | Category: output
Rating: |  Discuss |   Briefcase | 2,722 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: | Category: identity property
Rating: |  Discuss |   Briefcase | 4,124 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 | 3,951 reads
   Items 1 to 4 of 4