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
sqlserver增量更新另一个表的缺失数据
最新推荐文章于 2023-12-04 15:23:07 发布
这个脚本展示了如何使用SQLServer遍历所有用户表,并找出那些没有主键和自增列的字段,然后根据主键条件,将一个表的缺失数据插入到另一个表中,用于增量更新。
摘要由CSDN通过智能技术生成