none
EXEC OPENDATASOURCE INSERT TABLE RRS feed

  • Question

  • SELECT *
    INTO [dbo].[mytable]

        EXEC OPENDATASOURCE('SQLOLEDB',
                 'Data Source=178.55.11.22;User ID=sa;Password=pass123'
                 ).mydb.dbo.get_mysp

    How can I insert mytable from above
    Friday, May 24, 2013 12:13 PM

Answers

  • can you try this

    SELECT

    *


    INTO [dbo].[mytable]


    from

    OPENDATASOURCE('SQLOLEDB',


                 

    'Data Source=178.55.11.22;User ID=sa;Password=pass123'


                 

    ).mydb.dbo.get_mysp

    Friday, May 24, 2013 12:27 PM

All replies