Welcome to Sign in | Help

Re: Copy data from different SQL Server using TSQL

  •  12-17-2008, 8:33 PM

    Re: Copy data from different SQL Server using TSQL

    plus
    • OPENDATASOURCE
    • OPENROWSET
    • OPENQUERY
    Exemplu BOL:
    SELECT *
    FROM OPENDATASOURCE
    (
    'SQLOLEDB',
    'Data Source=ServerName;User ID=MyUID;Password=MyPass'
    ).Northwind.dbo.Categories

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems