是出错还是存在“县”或者“区” 才执行下面的代码 If Exists(Select * from inserted where charindex('县',area_name)=0 and charindex('区',area_name)=0) Begin update a a.city=substring(a.area_name,charindex('省',a.area_name)+1,charindex('市',a.area_name)-(charindex('省',a.area_name))), from city_locate a, inserted b where a.id = b.id Endelse begin update a a.lon=103 from city_locate a, inserted b where a.id = b.id end
If Exists(Select * from inserted where charindex('县',area_name)=0 and charindex('区',area_name)=0) Begin update a a.city=substring(a.area_name,charindex('省',a.area_name)+1,charindex('市',a.area_name)-(charindex('省',a.area_name))), from city_locate a, inserted b where a.id = b.id Endelse begin update a a.lon=103 from city_locate a, inserted b where a.id = b.id end
才执行下面的代码
If Exists(Select * from inserted where charindex('县',area_name)=0 and charindex('区',area_name)=0) Begin
update a a.city=substring(a.area_name,charindex('省',a.area_name)+1,charindex('市',a.area_name)-(charindex('省',a.area_name))), from city_locate a, inserted b
where a.id = b.id
Endelse
begin
update a a.lon=103 from city_locate a, inserted b where a.id = b.id
end
update a a.city=substring(a.area_name,charindex('省',a.area_name)+1,charindex('市',a.area_name)-(charindex('省',a.area_name))), from city_locate a, inserted b
where a.id = b.id
Endelse
begin
update a a.lon=103 from city_locate a, inserted b where a.id = b.id
end