Four Quick Tips For Using A Microsoft SQL Server Database As A Common Datastore

Using Linked Servers (Database Engine)

Using OPENQUERY (Transact-SQL)

OPENQUERY(linked_server, 'query')

Parameterized OPENQUERY

“OPENQUERY does not accept variables for its arguments.”

Procedures vs Functions with OPENQUERY

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store