[SQL2008 CTP5] View designer allows specification of sort order - by Hugo Kornelis

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


5
0
Sign in
to vote
ID 317249 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 12/13/2007 3:10:16 AM
Access Restriction Public

Description

When using the view designer in SQL Server Management Studio, one can specify to order the results in ascending or descending order of the columns included. This is wrong from a theoretic POV (as in the relational model, view , like tables, are unordered by definition). It is also incorrect from a practical POV, since there is no supported syntax in SQL Server to create a view with a defined sorting order.
Sign in to post a comment.
Posted by Microsoft on 7/3/2011 at 10:23 PM
Hi Hugo,

Thanks much for your feedback and recommendation.

However, given the work that would be involved in implementing this work, and triaging against our current set of deliverables, we do not think, we would be able to get to this in the near future.

Thanks again,

Nikhil
SQL Server Team
Posted by Microsoft on 12/20/2007 at 8:54 AM
Hello Hugo Kornelis,

Thank you for reporting the problem. The sorting order for VIEWS as you say does not guarantee sorted order. We will try to address this problem in the coming release of SQL Server.

Regards
Karthik