I am looking for a way to scan through all tables in a database (or) selected tables in a database and find out the missing values (either null or empty) in columns of those tables? Can someone please tell me if this is possible? If so, how will the query look like
Yep, You can do it with dynamic sql and INFORMATION_SCHEMA .
for example see the following post :
that's not a high-value target though. there may be a lot of columns that make sense to have NULL/empty values (diagnosis codes, address2, secondaryphone or fax number, etc.). You'll be spending better time figuring out what fields cause problems by being null or empty, and then creating queries to find the blank spots in those columns.
21 People are following this question.
