Re: Creating a VIEW

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Plamen Ratchev <Plamen@xxxxxxxxxxxxx>
Date: Thu, 20 Aug 2009 17:03:35 -0400

This is most likely because you added sort. A view is unordered set and the graphic tools unfortunately have inappropriate behavior to add ORDER BY and TOP. To correct this copy the view definition to a query window and then use ALTER VIEW to change it removing both the TOP option and the ORDER BY clauses. If you need ordering then use ORDER BY when querying the view.

--
Plamen Ratchev
http://www.SQLStudio.com
.

Follow-Ups:
- Re: Creating a VIEW
  - From: Dom

References:
- Creating a VIEW
  - From: Dom

Prev by Date: Re: Will SQL Server Be Backward Compatible with ISQL and DB-Lib?
Next by Date: Reset PK
Previous by thread: Creating a VIEW
Next by thread: Re: Creating a VIEW
Index(es):
- Date
- Thread