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

Blogs

Speaking at PASS Summit 2019

By

I am delighted to announce that I have been selected to speak at the...

High Security Prices–Always Encrypted 2019 needs Datacenter Edition

By

I was recently doing some work on Always Encrypted in SQL Server 2019 and...

Containers: Creating a Container

By

In yesterday’s blog post we pulled SQL Server images in preparation for today’s blog...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

ORDER BY - Need to understand what's going on

By sgmunson

Okay, folks... this one has me puzzled.   I have a query that sorts by...

Convert UNION to a JOIN

By tim_harkin

I have a UNION select that I would like to convert to a JOIN...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers