While working on some data issue I needed to create a backup table on the fly using SELECT INTO statement. I knew that it was possible but never did it my self. So it's as simple as defining a column as identity with the data type in the select statement. Below is statement shows how it's done.
SELECT IDENTITY(INT,1,1) AS RowID,
*
INTO dbo.MyTable_Backup
FROM dbo.MyTable
Hope this helps,
Bulent
Monday, July 2, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment