tsql OPENQUERY from local code example

Example: sql open queyr

SELECT * FROM OPENQUERY (<Linked Server>, 'SELECT name FROM joe.titles WHERE name = ''NewTitle''');