Famous Openquery Sql 2023. Select * from openquery (linked_server_name, 'select query goes here' ) note that the sql portion is single quoted. Dialog, provide the necessary configurations for the linked server.
It is initiated by specifying openquery as the table name in the from clause. Once done, click to save the linked server configuration. Select * from openquery ( [nameoflinkedserver], 'select * from tablename where field1=''your search value''') t1 inner join mysqlserver.database.dbo.tablename t2 on t1.pk = t2.pk.
