IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Valid in older versions of T-SQL
Post #38,557
by ChrisR
5/14/02 12:09:26 AM
Reply
New Valid in older versions of T-SQL
I've had to clean up some old stored procedures where the comparison used to be valid but got updated in the ANSI standards. Personally, I think the comparators should be illegal for Null values - or it least the dang compiler ought to warn you.
Post #38,562
by Meerkat
5/14/02 12:36:03 AM
Reply
New I should probably have twigged earlier
Becuase this whole 'NULL really is NULL' thing was helpful when we were using MIN() and MAX() to find which row actually had real data in it. But yeah, would have been nice to be warned. Then again, guess it'd be nice to have more experience. But hey, after his little episode, I guess I do :-)

As it happens we were getting an information msg from Oracle when the MIN() function discovered NULLS - and DataStage decided to flag that as a Fatal Error and crash the program. Sheesh. Anyway... just part of the Joy Of Programming, I guess :)

On and on and on and on,
and on and on and on goes John.
     Something I should have known... - (Meerkat) - (5) - May 13, 2002, 10:00:30 PM EDT
         Valid in older versions of T-SQL - (ChrisR) - (1) - May 14, 2002, 12:09:26 AM EDT
             I should probably have twigged earlier - (Meerkat) - May 14, 2002, 12:36:03 AM EDT
         I'm not sure that really makes sense. - (static) - (2) - May 15, 2002, 07:31:50 AM EDT
             Yup, that (your 'unless') is it - so it *does*make sense. -NT - (CRConrad) - May 15, 2002, 10:33:02 AM EDT
             That's how I've always used it - (Steven A S) - May 15, 2002, 04:10:48 PM EDT

He's at the sack of hair level...and sinking rapidly.
60 ms