This topic has not yet been rated - Rate this topic

OPENROWSET (DMX)

SQL Server 2012

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.

Syntax


          

OPENROWSET(provider_name,provider_string,query_syntax)

Arguments

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.

Remarks

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.

Examples

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'
)

Reference

Data Mining Extensions (DMX) Data Manipulation Statements

Data Mining Extensions (DMX) Statement Reference

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD