MSSQL Select Not Null

0 min read 65 words

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
Tags:
Andrew
Andrew

Andrew is a visionary software engineer and DevOps expert with a proven track record of delivering cutting-edge solutions that drive innovation at Ataiva.com. As a leader on numerous high-profile projects, Andrew brings his exceptional technical expertise and collaborative leadership skills to the table, fostering a culture of agility and excellence within the team. With a passion for architecting scalable systems, automating workflows, and empowering teams, Andrew is a sought-after authority in the field of software development and DevOps.

Tags

Recent Posts