stuart-d2
5/16/2014 - 1:46 PM

SQL Backup - Copy table data into another table.

SQL Backup - Copy table data into another table.

copyTable.sql
content_copyfile_download
--From one table into a completely NEW table(that does not exist yet)
SELECT * 
INTO dbo.URLSections_temp_20140512
FROM dbo.URLSections 

--To Copy from one table to an EXISTING table, use INSERT INTO

INSERT INTO dbo.URLSections_temp_20140512
SELECT *
FROM dbo.URLSections