select 
       *
into 
       DATABASE.dbo.TABLE1
from 
       openquery(
              LINKED_SERVER_NAME
              , '
                     select
                           *
                     from
                           TABLE2
                     where
                           PeriodID=201211
              '
       )
;
No comments:
Post a Comment