select * , id1 = identity(int,1,1) into t1 from t2
select identity(int,1,1) as id ,* into T1 from T2
create table t2(id int,a int,b int) go insert into t2 select 1,2,3 union all select 11,22,33 union all select 111,222,333select idd=identity(int,1,1),t2.* into t1 from t2 select * from t1
go
insert into t2 select 1,2,3
union all
select 11,22,33
union all
select 111,222,333select idd=identity(int,1,1),t2.* into t1 from t2
select * from t1