Differences and usage of select into and insert into select

Select *Into DesttblFromSrctbl

Insert IntoDesttbl (fld1, fld2)SelecT fld1, 5FromSrctbl

The preceding two statements Insert the srctbl data to desttbl, but the two statements are different.

First sentence (Select IntoFrom) requires the target table (desttbl)Does not existBecause it is automatically created during insertion.

the second sentence ( insert into select from) the target table (desttbl) exists . Because the target table already exists, apart from inserting fields in the source table (srctbl, constants can be inserted