본문 바로가기
MS Azure, Google Cloud Platform/Mise Azure

MSSQL table back up query

by swconsulting swconsulting 2017. 11. 9.

SELECT [컬럼 1] , [컬럼 2] INTO [신규 생성할 테이블명] FROM [기존 테이블명]
 

ex)


SELECT * INTO stationInfos_20170510 from stationInfos;

SELECT * FROM stationInfos;


SELECT * INTO addrInfos_20170510 from addrInfos;

SELECT * from addrInfos;

댓글0