OPENDATASOURCE & OPENROWSET

Question

Post reply

OPENDATASOURCE & OPENROWSET

SQL*

SSCertifiable

Points: 6638
More actions
May 1, 2009 at 3:08 am

#131058

Hi,
what is the difference b/n OPENDATASOURCE and OPENROWSET When can i use it in realtime.
🙂

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

The best reference for answering your question is the BOL topics for each of them:

OPENROWSET

http://msdn.microsoft.com/en-us/library/ms190312.aspx

OPENDATASOURCE

http://msdn.microsoft.com/en-us/library/ms179856.aspx

From personal experience OPENROWSET can do what OPENDATASOURCE can, but it can also read text files using format files, and different code pages and perform BULK operations where OPENDATASOURCE is not as flexible in the aspect.