December 11, 2002 at 9:09 pm
Hey everyone!
This question has come up several times in the past few days:
How do I get a column in my result set that contains the sequential row number?
I'd like to gather comments from anyone who's interested and forward a request to Microsoft for ignoring. ... er.... consideration for a future release.
Post your thoughts here on this topic, I'll summarize and post back for comments again.
December 11, 2002 at 10:15 pm
Try this:
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=22956
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
December 12, 2002 at 3:30 am
I'm in! 🙂
Personally, what I want is a CREATE SEQUENCE statement, as in Oracle and especially DB2, and of course, in the upcoming SQL:200n standard.
CREATE SEQUENCE seq
AS INTEGER
START WITH 1
INCREMENT BY 1
SELECT NEXT VALUE FOR seq, colA, colB ...
This is the proposed standard syntax, I guess SQL Server will look different (though I'd love to see it exactly this way, also with the identity syntax change to the proposed standard one).
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply