Export (0) Print
Expand All

OPENROWSET (DMX)

Replaces the source data query with a query to an external provider. The INSERT, SELECT FROM PREDICTION JOIN, and SELECT FROM NATURAL PREDICTION JOIN statements support OPENROWSET.

OPENROWSET(provider_name,provider_string,query_syntax)

provider_name

An OLE DB provider name.

provider_string

The OLE DB connection string for the specified provider.

query_syntax

A query syntax that returns a rowset.

The data mining provider will establish a connection to the data source object by using provider_name and provider_string, and will execute the query specified in query_syntax to retrieve the rowset from the source data.

The following example can be used within a PREDICTION JOIN statement to retrieve data from the AdventureWorksDW2012 database by using a Transact-SQL SELECT statement.

OPENROWSET
(
'SQLOLEDB.1',
'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security     Info=False;Initial Catalog=AdventureWorksDW2012;Data Source=localhost',
'SELECT TOP 1000 * FROM vTargetMail'
)

Community Additions

ADD
Show:
© 2014 Microsoft