Stephen Tirone

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.

4.58 (108)

2010-01-18

13,375 reads

Blogs

Daily Coping 2 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Presenting on Ethics in Modern Data at Houston HASSUG/SQL BI Group July 2020 Meeting

By

Looking forward to presenting with my wife Christine Assaf our talk on Ethics in...

MVP for Another Year 2020-2021

By

Early this afternoon I received an email from Microsoft presenting me with the 2020-2021...

Read the latest Blogs

Forums

Daily Coping 2 Jul 2020

By Steve Jones - SSC Editor

Today’s tip is share a happy memory with someone who means a lot to...

Query taking more than 4 hrs. - Any recommendations/suggestions?

By Feivel

One of our stored procs has been running for more than 4 hrs. and...

Unusual use of the WHERE clause

By michael.leach2015

I am working an exercise problem where the solution provided has a WHERE clause...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers