22,302
社区成员




if isnull((select count(1) from [223].hg.dbo.cus_fielddata where id = @id and scopeid = 3),0) = 0
begin
insert into [223].hg.dbo.cus_fielddata(scope,scopeid,id,field9)
values('HrmCustomFieldByInfoType','3',@id,@fyid)
end
else
begin
update [223].hg.dbo.cus_fielddata
set field9 = @fyid
where ID = @id
and SCOPEid = 3
end
update [223].hg.dbo.cus_fielddata
set field9 = @fyid
where ID = @id
and SCOPEid = 3