Re: Any new analytic SQL Features in SQL2005?
From: Jack D. Ripper (steve.nospam._at_rac4sql.net)
Date: 07/20/04
- Next message: Dan D.: "help with a query"
- Previous message: zeyneddine: "SQL Query Question/Solution needed"
- In reply to: Leander: "Any new analytic SQL Features in SQL2005?"
- Next in thread: Steve Kass: "Re: Any new analytic SQL Features in SQL2005?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Jul 2004 15:51:31 -0400
"Leander" <leander@net.hr> wrote in message
news:cdigv2$7q5$1@brown.net4u.hr...
> Common Table Expressions introduced in SQL2005 is realy great thing.
> Now I wonder are there plan to add any new analytic SQL features which
> Oracle has since 9i version like:
> FIRST/LAST
> GROUP BY GROUPING SETS
> Composite Columns on ROLLUP/CUBE clause
> GROUPING, GROUPING_ID and GROUP_ID
> MATERIALIZED VIEW?
> Multiset Operations for Nested Tables
Here's some basic analytics you can expect in Yukon:
http://www.winnetmag.com/SQLServer/Articles/ArticleID/42302/pg/1/1.html
http://www.winnetmag.com/SQLServer/Articles/ArticleID/42646/pg/1/1.html
Don't expect much more.I assume many of the constructs
in Oracle will be pushed to the CLR or sql kludges developed.
After all what can you expect in 5 years:)
- Next message: Dan D.: "help with a query"
- Previous message: zeyneddine: "SQL Query Question/Solution needed"
- In reply to: Leander: "Any new analytic SQL Features in SQL2005?"
- Next in thread: Steve Kass: "Re: Any new analytic SQL Features in SQL2005?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
