How to use OPENROWSET instead of a Linked Server in SQL Server

Categories: SQL Server
--Use OPENROWSET with SQL Server Authentication
select a.*
from openrowset(
,'select * from [dbname].[dbo].[table]') as a

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.