February 18, 2004 at 4:22 pm
Hello,
How can I create a simple select list, and have an additional column defined with the IDENTITY property (1,1) that exists only in the query?
I hope this makes sense.
Thanks for your help!
CSDunn
February 18, 2004 at 4:26 pm
Can you please reword the question?
February 18, 2004 at 7:14 pm
Unfortunately the IDENTITY function - which can generate incrementing numbers - only works with a SELECT INTO, not a normal SELECT. So, to achieve the results you're after you may need to put up with an intermediate (temp) table.
Cheers,
- Mark
February 19, 2004 at 2:23 am
If you are after some sequence this might be helpful
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 19, 2004 at 10:38 am
IDENTITYCOL...That's what I was thinking of, and I was not able to find this in BOL. I was able to find it in the MS Press book 70-229.
Thanks for your help!
CSDunn
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply