id为主键,自增列
SET IDENTITY_INSERT Test On
insert into Test ([id] ,[NameCN] ,[NameEN] )
select (select top 1 Id from Test order by id desc)+1, [NameCN] ,[NameEN]
from Test where id='1'
SET IDENTITY_INSERT Test Off
id为主键,自增列
SET IDENTITY_INSERT Test On
insert into Test ([id] ,[NameCN] ,[NameEN] )
select (select top 1 Id from Test order by id desc)+1, [NameCN] ,[NameEN]
from Test where id='1'
SET IDENTITY_INSERT Test Off