use demo
go
create table testid
([ID] [bigint] IDENTITY(1,1) NOT NULL,
col1 varchar(100),
[TMSTAMP] [timestamp] NOT NULL)
insert into testid(col1) values ('a')
insert into testid(col1) values ('b')
insert into testid(col1) values ('c')
create table testid2
([ID] [bigint] IDENTITY(1,1) NOT NULL,
col1 varchar(100),
[TMSTAMP] [timestamp] NOT NULL)
insert into testid2(col1) select col1 from testid
set IDENTITY_INSERT testid2 OFF
select * from testid2
go
create table testid
([ID] [bigint] IDENTITY(1,1) NOT NULL,
col1 varchar(100),
[TMSTAMP] [timestamp] NOT NULL)
insert into testid(col1) values ('a')
insert into testid(col1) values ('b')
insert into testid(col1) values ('c')
create table testid2
([ID] [bigint] IDENTITY(1,1) NOT NULL,
col1 varchar(100),
[TMSTAMP] [timestamp] NOT NULL)
insert into testid2(col1) select col1 from testid
set IDENTITY_INSERT testid2 OFF
select * from testid2
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16131092/viewspace-2134977/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16131092/viewspace-2134977/