Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sequential Ordering Expand / Collapse
Author
Message
Posted Monday, January 30, 2006 5:35 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:18 PM
Points: 1,276, Visits: 1,132
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/mcoles/sequentialordering.asp
Post #254585
Posted Tuesday, February 14, 2006 1:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 15, 2014 12:22 PM
Points: 155, Visits: 350
So SS2005 gets a bit closer to functionality (and, in this particular case, syntax) Oracle has been using for some time...



Post #258112
Posted Tuesday, February 14, 2006 9:43 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:18 PM
Points: 1,276, Visits: 1,132
The functionality (and, in this particular case, syntax) are part of the ANSI SQL99 standard.
Post #258294
Posted Wednesday, February 15, 2006 12:18 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 30, 2014 10:08 PM
Points: 1,038, Visits: 444

I like standards - in terms of if you are going to implement some functionality and there is some standard syntax for it, you should use it - but if it is proprietary functionality then you have to go out on your own with syntax anyway..

Good to see these new functions - they and the Top N ability will make many filtering tasks infinitely more straight forward!  Nice article and explanation too 




Post #258495
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse