USE AO
GOINSERT INTO AO2..ADMIN
SELECT
A.*
FROM
ADMIN A
WHERE
A.admin4=(SELECT TOP 1 admin4 FROM ADMIN WHERE admin1=A.admin1)GO
GOINSERT INTO AO2..ADMIN
SELECT
A.*
FROM
ADMIN A
WHERE
A.admin4=(SELECT TOP 1 admin4 FROM ADMIN WHERE admin1=A.admin1)GO
GOINSERT INTO AO2..ADMIN
SELECT
A.*
FROM
ADMIN A
WHERE
A.admin4=(SELECT TOP 1 admin4 FROM ADMIN WHERE admin1=A.admin1 and admin2=A.admin2 and admin3=A.admin3 )GO
仅当使用了列的列表,并且 IDENTITY_INSERT 为 ON 时,才能在表 'yinlongdata..yl_khtz' 中为标识列指定显式值。
仅当使用了列的列表,并且 IDENTITY_INSERT 为 ON 时,才能在表 'yinlongdata..yl_khtz' 中为标识列指定显式值。
GOINSERT INTO AO2..ADMIN.admin1,AO2..ADMIN.admin2,AO2..ADMIN.admin3,AO2..ADMIN.admin4
SELECT
A.*
FROM
ADMIN A
WHERE
A.admin4=(SELECT TOP 1 admin4 FROM ADMIN WHERE admin1=A.admin1 and admin2=A.admin2 and admin3=A.admin3 )GO
insert table tablename1 (admin1,admin2,admin3,admin4)
select admin1,admin2,admin3,admin4 from tablename2