Header Ads

MS-SQL : 다른 DB 에서 SELECT 한걸 INSERT


insert into COPY_TABLE_NAME
select FIELD1,FIELD2,FIELD3,FIELD4,FIELD5 
  from [127.0.0.1].[DBNAME].[dbo].[ORIGINAL_TABLE_NAME] 

No comments

Copyright 2016, minki. All rights reserved. Powered by Blogger.