Set @charenter=char(13)+char(10) Set @sql='' Set @TableName='tablename'Select @sql=@sql+' Update '+@TableName+' Set '+D.name+'=NULL Where '+D.name+'=0.00'+@charenter From Sysobjects M Left Join SysColumns D On M.id=d.id Left Join Systypes C On D.xtype=C.xtype Where C.name In ('numeric',..)---加入数据类型 And M.name=@TableName Exec(@sql)
Set @sql=''
Set @TableName='tablename'Select
@sql=@sql+' Update '+@TableName+' Set '+D.name+'=NULL Where '+D.name+'=0.00'+@charenter
From Sysobjects M
Left Join SysColumns D On M.id=d.id
Left Join Systypes C On D.xtype=C.xtype
Where C.name In ('numeric',..)---加入数据类型
And M.name=@TableName
Exec(@sql)