[dba-SQLServer] QBE tool in query analyzer

Getting used to writing sql code is part of the learning curve when moving from access to sql server.  It takes a bit of work, but it is well worth it.  After a time, trying to build a query in an access-like GUI is so aggravating that you will want to stick to QA.  For one thing, it allows you far more flexibility (subselects, case statements, derived tables, etc. etc. etc. etc. etc.).  Again, it is well worth the effort.


> 
> Message: 1
> Date: Tue, 05 Oct 2004 09:33:56 -0400
> From: "John W. Colby" <jwcolby at colbyconsulting.com>
> Subject: [dba-SQLServer] QBE in Query analyzer
> To: dba-sqlserver at databaseadvisors.com
> Message-ID: <001701c4aadf$face27a0$e8dafea9 at ColbyM6805>
> Content-Type: text/plain; charset=us-ascii
> 
> Is there a QBE tool in query analyzer?  I am having to go 
> create a view to
> use the qbe grid there, then cut and paste the sql into the 
> query analyzer.
> 
> 
> John W. Colby
> www.ColbyConsulting.com 
> 
> 
> >