insert into Tab1(Id1,Name1,Value1)
select Id2,Name2,Value2
from OPENDATASOURCE('MSDASQL','DRIVER={SQL Server};SERVER=IP或主机名;UID=sa;PWD=密码;').库名.dbo.Tab2
服务器端 insert into Tab1(Id1,Name1,Value1) select Id2,Name2,Value2 from OPENDATASOURCE('MSDASQL','DRIVER={SQL Server};SERVER=IP或主机名;UID=sa;PWD=密码;').库名.dbo.Tab2
本地 insert into Tab1(Id1,Name1,Value1) select Id2,Name2,Value2 from Tab2
posted on
2007-06-20 06:38迷你软件
阅读(853)
评论(0)
编辑收藏举报