SQL to find NULL in any column

You've got a table with hundreds of columns. You'd like to find records that have a NULL in any of those columns.
I'll show how to use sys.columns to get the list of all the columns and create a SELECT statement that tests for NULLs in any of those columns.
Get the code here: douglaskline.b...

[@rajatgupta8736]

Amazing... good to see you back

[@jerichaux9219]

The return of The King with the SQL Schwing!

[@vishnupriyaarora]

Hi Doug, what's the best way to reach you?

[@DatabasebyDoug]

How about LinkedIn? www.linkedin.com/in/douglaskline/ send me a connection request, then we can message directly.