columns that are left as blank/null/space or zero (given a list of tables).
Assuming I can pull out table and column definitions from the central system tables, how should I check the above condition?
columns that are left as blank/null/space or zero (given a list of tables).
Assuming I can pull out table and column definitions from the central system tables, how should I check the above condition?
1条答案
按热度按时间bvn4nwqk1#
There is no special procedure inside of SQL Server to make this determination. You need to query each table. Here's a brute force solution:
One quirk in the above solution is that any column from a table that is empty will be returned. If you wanted to exclude tables that are empty, you need only adjust the query to the following: