Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Stephen Tirone

SQLServerCentral.com profile

   Items 1 to 2 of 2   
 

Using "Multiple Assignment Variables" for a Generic Compare Data Script

Comparing data between tables seems like a simple thing to do, but it can eat up a lot of a SQL Server professional's time. Stephen Tirone shows how multiple assignment variables can be used to make this task a little easier.  Read more...
By Stephen Tirone 2010/01/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,931 reads

Caution with EXCEPT

The EXCEPT operator, introduced in SQL Server 2005, can be handy in some situations where you are comparing data between two tables. New author Stephen Tirone brings us a potential issue to be aware of with this operator.  Read more...
By Stephen Tirone 2010/01/18 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 13,127 reads
   Items 1 to 2 of 2