IDENTITY through SELECT

[snyderj]

What's a good way to create a sequential autonumber through a SQL Server view?

Specifically, can I do this through a SELECT ... INTO ... (perhaps using CAST?) or do I have to first CREATE TABLE with IDENTITY(1,1)?

(BTW, NEWID() creates a GUID that's too long for the customer.)

Thanks for any help you can offer.

 

[snyderj]

Figured it out:

SELECT IDENTITY (int, 1, 1) AS [element name], [other elements]
INTO [destination table]
FROM [source table]

Only works for SELECT ... INTO.

Thanks.