本文提供了一个使用T-SQL动态更新表中空值的具体案例。通过声明游标遍历表的所有列，并针对每一列生成并执行更新语句，将NULL值替换为0。这种方法适用于需要批量处理表中空值的情况。
USE [预约系统]
GO
declare cur_tb cursor
for
select name from syscolumns where id=OBJECT_ID('opening')
open cur_tb
declare @col_name varchar(50),
@sql varchar(100)
while @@FETCH_STATUS=0
begin
fetch next from cur_tb into @col_name
set @sql='update opening set '+@col_name+'=0'+'where '+@col_name+' is NULL'
exec (@sql)
end
close cur_tb
GO
GO
declare cur_tb cursor
for
select name from syscolumns where id=OBJECT_ID('opening')
open cur_tb
declare @col_name varchar(50),
@sql varchar(100)
while @@FETCH_STATUS=0
begin
fetch next from cur_tb into @col_name
set @sql='update opening set '+@col_name+'=0'+'where '+@col_name+' is NULL'
exec (@sql)
end
close cur_tb
GO
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
