My Microsoft SQL Server VIEW create statement has a TOP 100 PERCENT in the SELECT clause. Why would you use SELECT TOP 100 PERCENT in a SQL Server 2000 query?

A VIEW in Microsoft SQL Server will not allow you to have an ORDER BY statement. However, if you put a TOP 100 PERCENT in the SELECT statement, SQL Server will allow the ORDER BY.

Details can be found here:

I came across this while editing some VIEWS for a co-worker. He created the views using SQL Server’s visual tools. The tools automatically add this piece of code to the top of the CREATE statement for the views.

One thought on “SELECT TOP 100 PERCENT?

Comments are closed.