ScottPletcher (12/31/2012)
Please try this:
SELECT *
INTO dbo.newtable
FROM dbo.oldtable_with_identity
UNION ALL
SELECT TOP (1) *
FROM dbo.oldtable_with_identity
WHERE 1 = 0
The identity property should be left off the column in the new table :-).
Nicely done, Scott. You can also get away without using the TOP (1). The cpu time used and the number of reads are identical.
--Jeff Moden
Change is inevitable... Change for the better is not.