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

Guest Columnist: Steve McRoberts

SQLServerCentral.com profile

   Items 1 to 2 of 2   

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,129 reads

Using XML to pass and return values to procs

Tips on parsing and sculpting XML from within a SQL 2005 stored procedure  Read more...
By Steve McRoberts 2009/10/19 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 10,236 reads
   Items 1 to 2 of 2