Hi, Guru:
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
>--Original Message--
>Hi, Guru:
>Is there any difference between these two functions?
>Thanks in advance.
>
>.
>
2012年2月16日星期四
any difference between OpenRowset and OpenDataSource
标签:
database,
functions,
guru,
microsoft,
mysql,
opendatasource,
openrowset,
oracle,
server,
sql
订阅:
博文评论 (Atom)
没有评论:
发表评论