From: esquel@sommarskog.se   
      
   lk (gofyself@wrong.address.com) writes:   
   > I'm using SQL Server 2005 express and the adventureworks sample database   
   > to try and refresh my memory with SQL Server (It's been about 5 years   
   > since I last used it a lot).   Can anyone help with a basic   
   > question...?   
   >   
   > I've written two queries now - one works - one doesn't and I'm not sure   
   > why.   
   >   
   > The syntax in both is identical (select * from HumanResources.Shift) but   
   > one gives me an "invalid syntax near ." but the other works fine.   The   
   > only difference in how I've written them is the one that worked I wrote   
   > by right clkicking on the adventureworks icon on the object explorer.   
   > The other one I just did "File, New, Query with Current Connection".   
   >   
   > Must be something fundamental I'm doing wrong.   
      
   Copy and paste both queries in a reply to this post.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)