sql server2000存储过程脚本清空NULL

create proc [dbo].[p_update_null]@tabname varchar(50)asdeclare @tabid intdeclare @i intdeclare @j intdeclare @columname varchar(50)declare @string varchar(300)declare @sql nvarchar(200)set @sql = 'select @tabid = id from dbo.sysobjects where type=''U'' and name = ''' + @tabname +''''print(@sql)exec sp_executesql @sql,N'@tabid int out',@tabid outselect name,identity(int,1,1) as id into temp_updatenull from syscolumns where id = @tabidselect @i = 1,@j=max(id) from temp_updatenullwhile @i<=@j begin select @columname = name from temp_updatenull where id = @i set @string = 'update ['+ @tabname+'] set ['+@columname+'] = '''' where ['+@columname+'] is null' print (@string) exec(@string) set @i = @i+1 enddrop table temp_updatenullGO