This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / 紧急求助，数据库问题，谢谢！
-henhen(亨亨，明天会更好 *_*);
2009-1-21
{1192}
(#4996875@0)
-
up
-henhen(亨亨，明天会更好 *_*);
2009-1-21
(#4996917@0)
-
改正4.假如3不行，改用OPENQUERY -- 对其中ORACLE的QUERY可能有错，请修改
Declare @temp Table(Code Char(3),EffectiveDate Datetime,Rate Decimal(12,9))
Insert Into @temp(Code,EffectiveDate,Rate)
Select Code,EffectiveDate,Rate
From OpenQuery(ORALINKEDSrv,'Select Code,EffectiveDate,Rate From XXX.SYSOWNER.VTABLE where trunc(EffectiveDate)=[DATE]')
SELECT * FROM @temp
Go
-henhen(亨亨，明天会更好 *_*);
2009-1-21
{378}
(#4996943@0)
-
How about SQL Server Replication? I used the service to replicate data from Oracle to SQL Server a couple of years ago and it worked very well.
-renjl0810(相信网络,相信Google);
2009-1-21
(#4996983@0)
-
Duno your purpose. But just give you the result from my platform. (2 SQL server in the network)
-whereismyid(到处找ID);
2009-1-21
{688}
(#4997014@0)
-
1. Date filter condition. In Oracle, it should be EffectiveDate >=TRUNC(Sysdate -1) or likewise. 2. Not sure what’s your goal, query (or join query) data in Oracle database from sql server, or transfer data from Oracle?
-deep_blue(BLUE);
2009-1-21
(#4997085@0)