Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

EXCEPT - 1 Expand / Collapse
Author
Message
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: Tuesday, August 26, 2014 11:49 PM
Points: 833, Visits: 1,365
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
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 25, 2014 10:53 PM
Points: 160, Visits: 235
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