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
