快速生成扩展表默认数据的脚本

发布时间:2020-01-20  栏目:数据  评论:0 Comments

declare @total int;declare @count int;set @count=0;SELECT @total=COUNT(1) FROM TB_JJ;create table #T( rid int PRIMARY KEY, sys_guid NVARCHAR(40));
INSERT INTO #T SELECT ROW_NUMBER() over (order by sys_guid) as rid,sys_guid FROM TB_JJ;
WHILE @count<@totalBEGIN set @count=@count+10000; INSERT INTO TB_JJ_Info(sys_guid) SELECT sys_guid FROM #T where rid<=@count;  DELETE FROM #T where rid<=@count;ENDDROP TABLE #T;

留下评论

网站地图xml地图