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
Posted Monday, March 19, 2012 10:00 AM


Group: General Forum Members
Last Login: Wednesday, July 30, 2014 10:52 PM
Points: 483, Visits: 244
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



Group: General Forum Members
Last Login: Today @ 7:27 AM
Points: 2,951, Visits: 2,970
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
Post #1270378
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse