More about “if (a == true) b = true” in SQL

Uncategorized — Антон Марчуков @ 29.06.07 18:30

Are there any MS SQL experts? What’s the heck of doing such expressions:

AND isnull(a.CurrentBalance,0)=0

it looks like as the famous if (a == true) b = true else b = false to me

why it’s not possible just use

AND a.CurrentBalance IS NULL


No comments yet.

Leave a comment

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
(c) 2017 Anton Martchukov's Weblog | powered by WordPress with Barecity