Is there any difference between these two functions?
Thanks in advance.The key difference is which level of the source it
specifies. OPENROWSET specifies an object or a query. The
OPENROWSET function can be used anywhere a <table or view>
is used in a Transact-SQL statement.
OPENDATASOURCE specifies a data source (e.g. a server
name) -- OPENDATASOURCE can be used in the same TSQL
syntax locations where a <linked server name> is used.
Linchi
quote:
>--Original Message--
>Hi, Guru:
>Is there any difference between these two functions?
>Thanks in advance.
>
>.
>
