您的位置:金沙游乐场85155 > 大数据库 > 快速生成扩展表默认数据的脚本

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

发布时间:2019-10-08 12:32编辑:大数据库浏览(75)

    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<@total
    BEGIN
        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;
    END
    DROP TABLE #T;
    

    本文由金沙游乐场85155发布于大数据库,转载请注明出处:快速生成扩展表默认数据的脚本

    关键词:

上一篇:没有了

下一篇:没有了