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

Values <> null Expand / Collapse
Author
Message
Posted Monday, March 19, 2012 10:00 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Saturday, November 29, 2014 2:17 AM
Points: 483, Visits: 245
Interesting topic, yet confusing at times when determining times to set the ANSI_NULL to ON or OFF to yield expected results. Thanks.
Post #1269058
Posted Wednesday, March 21, 2012 11:28 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 12:24 PM
Points: 3,098, Visits: 3,231
select * from ##TableNulls where col2 is not null
will give out the expected results at fist sight

Thank you for the question




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1270378
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse