批量更新插入

insert into dbo.tab(RR_ID, RR_SELECT_ID)
SELECT RR_ID, RR_SELECT_ID,
FROM dbo.tabETEMP
where not exists (select distinct RR_ID from dbo.tab
     where dbo.tab.RR_ID=dbo.tabETEMP .RR_ID)

update dbo.tab set Detail_IsCalled=FEETEMP.IsSpotChecked
from (select ID, IsSpotChecked from tabETEMP ) as FEETEMP
 where dbo.tab.ID=FEETEMP.ID