27,582
社区成员




DECLARE @test1 TABLE(a1 INT,a2 INT,a3 INT,a4 INT)
DECLARE @test2 TABLE(a3 INT,a4 INT)
INSERT INTO @test2(a3,a4)
SELECT 11,22 UNION ALL
SELECT 22,33 UNION ALL
SELECT 33,44
SELECT ABS(CHECKSUM(NEWID()))/1000000 AS a1,IDENTITY(INT) AS a2,a3,a4 INTO # FROM @test2
INSERT INTO @test1(a1,a2,a3,a4) SELECT a1,a2,a3,a4 FROM #
SELECT * FROM @test1
DROP TABLE tempdb..#
alter table A
alter column [2] identity (0 , 1)
insert into A
select 'A' , [3] , [4] , [5]
from 数据集
insert into A
select 'A',[3],[4],[5] from 数据集
insert into A
select [1],[3],[4],[5] from 数据集