Re: [GENERAL] null and =

1999-12-05 Thread Slavica Stefic
Mike Mascari wrote: > > I would avoid using the INTERSECT/EXCEPT code since the query rewriter > rewrites these to IN clauses which cannot use indexes. As soon as the tables > grow beyond more than a couple hundred rows, the statment becomes unusable. > Instead, I would use a correlated subquery

[GENERAL] null and =

1999-12-05 Thread Slavica Stefic
Hello, is null = null true or also null ? more precisely I have this kind of situation in a mission critical project and I'm,sadly, not an expert in SQL. But until now I used null values with a specific meaning in my database, and I didn't knew that I would come in this situation: =>create tabl