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