Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««123

EXCEPT - 1 Expand / Collapse
Posted Friday, July 5, 2013 2:18 AM

SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, November 22, 2015 11:42 PM
Points: 907, Visits: 1,387
Easy one. This is according to the SQL standard. Unfortunately, SQL Server does not support except all and intersect all, which both is a part of the SQL Standard. There are times where I really missed them, especially except all.

Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

Concatenating Row Values in Transact-SQL
Post #1470623
Posted Monday, September 30, 2013 3:04 AM


Group: General Forum Members
Last Login: Friday, November 18, 2016 5:59 AM
Points: 174, Visits: 271
Also nice piece of information regarding INTERSECT and EXCEPT: NULL values are regarded as the same. A behaviour as if SET ANSI_NULLS were OFF.

If you set out to do something, something else must be done first.
Post #1499898
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse