슈퍼아이피
10-07-05 15:29
1개
1,352회
MSSQL
쿼리로 테이블 백업 - select into
***쿼리문
SELECT Shippers.*, Link.Address, Link.City,
Link.Region, Link.PostalCode
INTO NewShippers
FROM Shippers
JOIN LinkServer.DB.dbo.Shippers AS Link
ON (Shippers.ShipperID = Link.ShipperID)
***쿼리문
SELECT Shippers.*, Link.Address, Link.City,
Link.Region, Link.PostalCode
INTO NewShippers
FROM Shippers
JOIN LinkServer.DB.dbo.Shippers AS Link
ON (Shippers.ShipperID = Link.ShipperID)
추천
0
비추천
0
댓글목록
슈퍼아이피님의 댓글
select *
into ATST_211_bk09060917
from ATST_211