Views

I am new to SQLServer 2005 but not to relational databases. I am puzzled by
the behavior of views. I can use the view in Visual Studio or open it in
SQLServer Management studio and the virtual table displays correctly except
for sorting (ORDER BY in the SQL statements). Joins and filters all work
correctly when I open the view but not sorting. Sorting will only work if I
open the view with "Modify" and execute it.

I appreciate any help you can give me.

Bill


.

Relevant Pages

  • Re: Book Recommendation
    ... The Balena book "Programming VB.NET ver. ... Vaughn's book (Hitchhiker's Guide to SQLServer and Visual Studio 2005, ... SQLServer from inside Visual Studio, code snippets, etc. ...
    (microsoft.public.dotnet.general)
  • Re: Packaging a SQL2005 application
    ... not SQLServer Express or SQLServerCE? ... publish them as ClickOnce applications to a network drive. ... I'm currently using Visual Studio 2008, SQL 2005, and most of the apps were created with .Net2.0. ...
    (microsoft.public.dotnet.languages.vb)
  • best practises for creating new users for db supporting web app?
    ... I started playing with SQLServer 2K with Visual Studio 2k3 and I ... Do you have any suggestions for websites for quick and dirty best practises ... for dbs supporting website? ...
    (microsoft.public.sqlserver.programming)
  • Re: SQLExpress 2005 backup/restore ??
    ... I deinstalled both SQLServer and the Management tool, ... Nevertheless when I try to install SQLEXPR.EXE I soon get a message saying, ... Visual Studio or SQLServer. ... Where do I get that "build cleanup wizard"? ...
    (microsoft.public.sqlserver.msde)