Deprecated T-SQL Features

摘要

A query without an ORDER BY clause returns a table in which order of rows isn't guaranteed, whereas a query with an ORDER BY clause doesn't return a table but rather what ANSI SQL calls a cursor, which guarantees the order of rows. Because a view is supposed to represent a table, and a query with an ORDER BY clause doesn't return a table, ANSI SQL doesn't let you define a view based on a query with an ORDER BY clause.