Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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,092 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,163 reads
   Items 1 to 2 of 2