數據從一個DB寫入另外一個DB 

insert into opendatasource
( 'SQLOLEDB',  'Data Source=172.17.254.5;User ID=登陆名;Password=密码').PF_DB.dbo.seT_orderbuy 
select *from dbo.seT_orderbuy 
where orderstartdate>='2008/11/26' and orderenddate<='2008/12/02' and suppliercode='3429'

 

posted @ 2013-02-06 03:49  sirili  阅读(116)  评论(0)  编辑  收藏  举报