SQL - 查询以在数据库的所有表中查找特定列但没有空值

Question

我不是 SQL 专家。我需要搜索存在于数据库所有表中但没有为该特定记录存储空值的列。

下面是获取所有具有我的列名的表的查询:

SELECT TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE column_name LIKE 'classPK'

Answer 1

试试这个...

declare @q nvarchar(1000);
declare cur_Select cursor for 
select  'select * from ['+tab.name+'] where ['+col.name+'] is not null'
from    sys.tables tab
join    sys.columns col
    on  tab.object_id = col.object_id
where col.name like 'name'

open cur_Select
fetch next from cur_Select into @q

while @@FETCH_STATUS = 0
begin
    exec sp_executesql @q   

    fetch next from cur_Select into @q

end

close cur_Select
deallocate cur_Select