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

Last modified: July 24, 2019

Author

Comments

Write a Reply or Comment