Just to clarify things, this is what I am doing at the moment;

SELECT IDENTITY(int, 1,1) AS ID_Num, Name
INTO #NewTable
FROM master.dbo.sysdatabases

SELECT * from #NewTable


Am I able to do the above in a single select statement?





__________________________________________
Anthony Hand
DBA | Systems Integration
Aon Risk Services Australia Ltd
Ph: +61 2 9253 7516
Fax: +61 2 92537952
Mob: +61 415 877 988




anthony.[Email Address Removed]
on.com.au To: "LazyDBA.com Discussion" <[Email Address Removed]
cc:
28/07/2003 bcc:
08:42 AM Subject: creating an incrimented column on the fly






Is there a way to create a column, in a select statement, which has an
identity.

At the moment, I am selecting from a table into a temp table and then
inserting and identity row.

Is it possible to do this in the select statement on the fly?

Thanks guys,




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page