两表联合更新

update news
set news.special_id='|'+ltrim(rtrim(str(s.id)))+'|'
from news,special as s
where news.specialname=s.specialname and news.special_id is null