sql server 把表的所有的null改为0,不要限制某列

DECLARE @tableName NVARCHAR(256) = 'Linear'  -- 替换为你的表名  
DECLARE @sql NVARCHAR(MAX) = ''  SELECT @sql += 'UPDATE ' + @tableName + ' SET ' + COLUMN_NAME + ' = 0 WHERE ' + COLUMN_NAME + ' IS NULL;'  
FROM INFORMATION_SCHEMA.COLUMNS  
WHERE TABLE_NAME = @tableName AND TABLE_SCHEMA='dbo' AND DATA_TYPE IN ('int','nchar', 'float', 'decimal', 'money', 'smallmoney') AND IS_NULLABLE='YES'  EXEC sp_executesql @sql

DECLARE @tableName NVARCHAR(256) = ‘Linear’ – 替换为你的表名
DECLARE @sql NVARCHAR(MAX) = ‘’

SELECT @sql += ‘UPDATE ’ + @tableName + ’ SET ’ + COLUMN_NAME + ’ = 0 WHERE ’ + COLUMN_NAME + ’ IS NULL;’
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = @tableName AND TABLE_SCHEMA=‘dbo’ AND DATA_TYPE IN (‘int’,‘nchar’, ‘float’, ‘decimal’, ‘money’, ‘smallmoney’) AND IS_NULLABLE=‘YES’

EXEC sp_executesql @sql