建立过程 insert RegionData (Region)
select b.Region from RegionData a left salesData b on b.Region=b.Region
where a.Region is null
在建立JOB(执行此过程)
select b.Region from RegionData a left salesData b on b.Region=b.Region
where a.Region is null
在建立JOB(执行此过程)
select distinct b.Region from
sales a where not exists (
select 1 from RegionData
where Region=a.Region
)or: insert RegionData (Region)
select distinct a.Region from sales a left RegionData b on b.Region=b.Region
where b.Region is null
select b.Region from RegionData a left inerted b on b.Region=b.Region
where a.Region is null
建立过程 insert RegionData (Region)
select b.Region from salesData b left join RegionData a on a.Region=b.Region
where a.Region is null
在建立JOB(执行此过程)
如果时时插入,可以建触发器 insert RegionData (Region)
select b.Region from innerted b left join RegionData a on a.Region=b.Region
where a.Region is null