Add Unique Key to Select..Into statement? 1

[MDA]

Hi all,

Is there any way to add a unique key field to a Select...Into statement? I know I can use the newId() syntax but this creates a huge string.

Select newId() IdKey , * INTO ixvJCSOURCE from ixvJCTrans

I just want an incrementing unique number. I am trying to avoid a Stored procedure or using the Insert Into command.

Any ideas?
Thanks,
MDA

 

[JohnDTampaBay]

Select IDENTITY(int,1,1) IdKey , *
INTO ixvJCSOURCE
from ixvJCTrans



--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.