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
FROM [databaseNameHere].[dbo].[databaseTableNameHere]
WHERE [columnNameHere] IS NOT NULL
Share This Article
Trackbacks
There are no trackbacks on this entry.
Comments
There are no comments on this entry.