SQL如何查找一个表格中所有含有空值的列?

对于某列查找空值
Select *
From Table
Where Column = Null

如果有十列，想知道哪些列含有空值，要运行十次吗？能否一次完成?
多谢

Select *
From Table
Where Column is Null;

判断null用is，不能用 =

写个脚本，拿到表的所有列，然后查找每列是否含有空值

is Null , =""

select 
count(1) as col_all
,count(col1) as col_1
,count(col2) as col_2
.....
from table

找和col_all 不相等的列行，就是含有空值的列

Select *
From Table
Where Column = '' OR Column IS NULL