sqlserver增量更新另一个表的缺失数据

declare @tname varchar(100),@tid int
declare cur_table cursor for
select [name],[object_id] from sys.objects where [type]='u'
open cur_table
fetch next from cur_table into @tname,@tid
while @@fetch_status=0
begin
    declare @sql varchar(500),@pri_key varchar(50)
    declare @str varchar(8000),@condition varchar(500)
    set @str=''
    set @condition=''
    
    select @str=[name]+','+@str from sys.columns where [object_id]=@tid
    and [name] not in(select [name] from syscolumns where xtype=189)
    and [name] not in(select [name] from sys.columns where is_identity=1)
    order by column_id desc
    set @str=substring(@str,1,len(@str)-1)    
    
    select top 1 @condition=' and '+column_name+' not in