MSSQL Select Not Null

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:

SELECT [columnNameHere] FROM [databaseNameHere].[dbo].[databaseTableNameHere] WHERE [columnNameHere] IS NOT NULL
Code language: CSS (css)
Tags:
Subscribe
Notify of
guest
1 Comment
Newest
Oldest Most Voted
Inline Feedbacks
View all comments
Raj
Raj
8 years ago

Really Nice.. Thanks for the post