I mainly use MySQL these days, so get screwed over for a few minutes when I have to do something in MSSQL that is slightly different when it comes to it’s custom syntax.

If you want to show all entries in a specific column and where it is not Null then you can do the following:

[code lang=”sql”]
SELECT [columnNameHere]
FROM [databaseNameHere].[dbo].[databaseTableNameHere]
WHERE [columnNameHere] IS NOT NULL
[/code]


1 Comment

Raj · February 19, 2013 at 12:22

Really Nice.. Thanks for the post

Leave a Reply

Your email address will not be published. Required fields are marked *