insert into db2.dbo.table1 select * from db1.dbo.table1
INSERT INTO db2.dbo.table1 SELECT * FROM DB1.DBO.TABLE1 WHERE USERNAME=123
insert into db2.table1 select * from db1.table1 where username=123
select * into db2.table1 from db1.table1 where username='123'
如果db2.table1 表不存在可以用以上的 select into 否則用 insert into
select * into db2.table1 from db1.table1 where db1.table1.username='123' 或 insert into db2.table1 select * from db1.table1 where db1.table1.username='123'
insert into db2.dbo.table1
select * from db1.dbo.table1
否則用 insert into
或
insert into db2.table1
select * from db1.table1 where db1.table1.username='123'