2012-11-16

TSQL - Quickly copy a linked server table


select
       *
into
       DATABASE.dbo.TABLE1
from
       openquery(
              LINKED_SERVER_NAME
              , '
                     select
                           *
                     from
                           TABLE2
                     where
                           PeriodID=201211
              '
       )
;


No comments:

Post a Comment