SELECT * INTO <target> FROM <sourcetable>

##</code><code>##

TRUNCATE <target>