ISNULL() replaces NULL with the value you provide. For example: DECLARE @var int SET @var = NULL select ISNULL(@var, 100) as [Var] This returns 100. Simple and easy, right? ISNULL is often used to take care of NULLs in mathematical sets. For example: SELECT AVG(ISNULL(Charge, 0)) FROM BankAccount This will change all NULLs to 0, so we can use […]
It’s Banned Book Week! The American Library Association observes Banned Book Week the last week of September to celebrate intellectual freedom. Thanks to author Neil Gaiman (@neilhimself) for retweeting, or I wouldn’t have heard of it. I’ve decided to spread the joy with a little celebration of my own. We’re having a book review party […]
Man, I tell you brothers n sistahs, it has been one HARD week of coding. The more kindhearted of you might not have noticed, but it’s been a lot of “soft” blogging around here recently…a restult of my brainfry-ed-ness. Well yeah, the T-SQL for the Absentminded DBA post was pretty awesome, you’re right. Anyway. My fellow […]