Adding Identity Column in
SELECT INTO Statement in SQL SERVER
Is used
only in a SELECT statement with an INTO table clause
to insert an identity column into a new table.
Note: More than one identity
column cannot be in table.
-- Create
table
CREATE
TABLE MyOrders3
(
ProductName
varchar(20)
);
-- Creating
Copy of 'MyOrders3' with additional IDENTITY column
select
IDENTITY(int,
1,1)
AS Id,*
INTO MyOrdersIdentity
from
MyOrders3
insert
into MyOrdersIdentity
values ('Samsung')
select
* from
MyOrdersIdentity
Thanks
J