declare @a table
(
id int,
[no] varchar(8),
name varchar(8)
)
declare @c table
(
[no] varchar(8)
)
insert into @a(id,[no],name)values(1,'A','张三')
insert into @a(id,[no],name)values(2,'A','李四')
insert into @a(id,[no],name)values(3,'B','王五')
select * from @a
insert into @c([no])values('A')
insert into @c([no])values('B')
insert into @c([no])values('C')
select * from @c
表A和表C,现在要根据表C给表A新增数据,
如果表C三条记录,那么表A的第一条记录就新增no为B、C的两条;
第二条记录新增no为B、C的两条;
第三条记录新增no为A、C的两条,后面的以此类推...
我想的大概的框架应该是这样的,然后里面的那个判断应该怎么写???因为一个id的会有多条,然后@a里面有变动的话@c里面的怎么去对应的变动 ???
declare @id bigint;
declare @no nvarchar(4);
declare @name nvarchar(40);
insert into @c_info
select id,no,name from @c (nolock)
declare @cursor cursor;
set @cursor = cursor for
select id,no,name from @c;
open @cursor
fetch next from @cursor into @id,@no,@name
while @@FETCH_STATUS=0
begin
//判断之后修改
fetch next from @cursor into @id,@no,@name
end
close @cursor
deallocate @cursor