使用场景

在项目中，涉及到数据库表变更时，可能会需要将一个或多个表中的数据迁移到另一个表中。

这时用sql去执行会很方便！

sql语句

//SQL批量插入

create table #ttableName(id int identity(1,1),customerid int,grade int,popularity int)

declare @n int,@rows int

declare @e int, @g int,@p int

insert #ttableName(customerid,grade,popularity) select Id,Grade,Popularity from Customer where Grade>0 or Popularity>0

select @rows =@@rowcount

set @n=1

while @n<=@rows

begin

	select @e=customerid, @g=grade,@p=popularity from #ttableName where id=@n

insert into GenericAttribute(EntityId,KeyGroup,[Key],[Value]) values(@e,'Customer','LiveLevel',@g)

insert into GenericAttribute(EntityId,KeyGroup,[Key],[Value]) values(@e,'Customer','LivePopularity',@p)

	select @n=@n+1

end

drop table #ttableName