My question is,
Does SQL Server 2k's Trannsact SQL has the ability of Oracle's
I know that this is not a query process but may be T-SQL has this.
For example; Could i go to the 10th,3th or 50th (etc.) row of my query result?
Thank you very much for your answers
Re: RowNum question
No - there really isn't a direct equivalent.
Common hacks around this range from using an appropriate cursor to selecting
things into a working table that has an autonumber field.
When you think about it, the rownum business is a violation of the rules of
relational data. That said, it's actually pretty darn handy in some cases -
maybe they'll add it in Yukon.
Visit www.ProfessionalSQL.com Today. It's new and improved!
"Kutadgu Arslan" <firstname.lastname@example.org> wrote in message
> Hi everyone,
> My question is,
> Does SQL Server 2k's Trannsact SQL has the ability of Oracle's
> I know that this is not a query process but may be T-SQL has this.
> For example; Could i go to the 10th,3th or 50th (etc.) row of my query
> Thank you very much for your answers
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL