EXEC sp_addlinkedserver 'OraCMSRFID', 'CMSRFID', 'MSDAORA', 'CMSRFID'
name service name servicename
EXEC sp_addlinkedsrvlogin 'OraCMSRFID', false, 'sa', 'oraUID', 'OraPwd'
select * from openquery(OraCMSRFID, 'select * from tabemp')
name service name servicename
EXEC sp_addlinkedsrvlogin 'OraCMSRFID', false, 'sa', 'oraUID', 'OraPwd'
select * from openquery(OraCMSRFID, 'select * from tabemp')
No comments:
Post a Comment