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: https://douglaskline.blogspot.com/202...