OPENDATASOURCE connect to SQL Server

Here's a trusted connection example.

SELECT *
FROM 	OPENDATASOURCE(
'SQLOLEDB',
'Data Source=SQLDEV;Integrated Security=SSPI'
).[pubs].dbo.[authors]

Comments are closed.

Post Navigation