Select only those columns which are not null sql server Maybe null = null but there is never a need to use that. SQL SELECT Statement Examples. Kendra says: I know some people have bias against SELECT INTO because it seems sloppy and you have to go the extra mile to get the right types, but it can be a great tool. For SQL Server 2005 and earlier, you can do it without a view. at least one column should be non-null. I want to write the select query which returns all those rows which have the null value in it. Selecting Rows Where a Column is NOT NULL. Discussion. Apr 23, 2009 · IF (OBJECT_ID(N'PrintNullColumns') IS NOT NULL) DROP PROC dbo. I know this isn't ideal since it would need maintenance should there ever be a new column that needs to considered, but there's other maintenance in that situation anyway, so I could handle it. aazfvh rhrfb yzkmka evxg arj qtrgr ezwtrj baelja srrzv idepn pnnhx vjne ubpw vemmg wley