Copy Table Using TSQL

Copy table with all rows without creating the table first.

Note: Does not copy over constraints.

SELECT * INTO tbTable01_YYYYMMDD FROM tbTable01

SELECT * INTO tbImage_20190724 FROM tbImageTrans

SELECT COUNT(*) FROM dbo.tbImage
SELECT COUNT(*) FROM dbo.tbImage_20190724