SELECT
字段1=case when 字段1<0 then 0 else 字段1 end,
字段2=case when 字段2<0 then 0 else 字段2 end,
字段3=case when 字段3<0 then 0 else 字段3 end
FROM tableName
字段1=case when 字段1<0 then 0 else 字段1 end,
字段2=case when 字段2<0 then 0 else 字段2 end,
字段3=case when 字段3<0 then 0 else 字段3 end
FROM tableName
returns int
begin
declare @t int
if @intV<0
set @t=0
else
set @t=@intV
return @t
end select dbo.fn_Zero(字段1),dbo.fn_Zero(字段2),dbo.fn_Zero(字段3) from table2