View Problems

• siluctc

  Mr or Mrs. 500

  Points: 539

  More actions

  June 26, 2008 at 6:13 am

  #188516

  I want to change a sql server 2000 database to sql server 2005 database. There are some views in that database where order by clause is used for example : select top 100 percent from emp order by empname...

  As you are aware that in sql server 2005 we cannot use the order by clause in a view. So how to upgrade the database..

  Regards,

  Ashis

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  June 26, 2008 at 6:49 am

  #834588

  You can still do the same thing, a query with a TOP clause can be used as a view in SQL 2005.

  Even in SQL 2000, this was not a good approach. You should try to avoid using a TOP 100 Percent and an ORDER BY in a view.