hemtros
8/5/2015 - 2:34 PM

Abnormal features of sql

Abnormal features of sql

/*creates new table from old table without data */

SELECT *
INTO NewTable
FROM OldTable
WHERE 1 = 2
insert into a_existingtable
select * from anothertablewithsameschema;