Showing posts with label Nulls. Show all posts
Showing posts with label Nulls. Show all posts
Wednesday, April 24, 2019

How to count NULLS without using IS NULL in a WHERE clause

›
This came up the other day, someone wanted to know the percentage of NULL values in a column Then I said "I bet you I can run that ...
Thursday, December 13, 2007

The Strange Case OF Nulls And Case

›
Okay it is not Dr. Jekyll and Mr. Hyde but I had to come up with a title. This was a question someone asked yesterday in the sql programming...
2 comments:
Tuesday, November 06, 2007

Return Null If A Value Is A Certain Value

›
You need to return NULL only if the value of your data is a certain value. How do you do this? There are three different ways. NULLIF DECLAR...
Friday, October 19, 2007

Sort Values Ascending But NULLS Last

›
This is a frequent request in newsgroups and fora. People want to sort the column in ascending order but don't want the NULLS at the beg...
Friday, June 22, 2007

Summer SQL Teaser #4 Nulls and Counts

›
First create this table CREATE TABLE Teaser (ID int) INSERT Teaser VALUES (1) INSERT Teaser VALUES (2) INSERT Teaser VALUES (1) INSERT ...
Friday, February 09, 2007

Use A Combination OF NULLIF and COALESCE TO Display A Custom Value

›
Let's you inherit a table with a column that can contain blanks, empty strings or NULL values. I am saying inherit because surely you wo...
Monday, January 30, 2006

NULL Trouble In SQL Server Land

›
I am seeing a lot of searches for SQL + Nulls from this site so I decided to blog about it Before I start I would like to point out that all...
3 comments: