[dba-SQLServer] QBE tool in query analyzer

Porter, Mark MPorter at acsalaska.com
Tue Oct 5 13:59:15 CDT 2004


I even write straight SQL in Access about half the time now, since moving to SQL Server a few years ago.

> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of David
> Lewis
> Sent: Tuesday, October 05, 2004 10:00 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: [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 
> > 
> > 
> > > 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 

***********************************************************************************
This transmittal may contain confidential information intended solely for
the addressee. If you are not the intended recipient, you are hereby
notified that you have received this transmittal in error; any review,
dissemination, distribution or copying of this transmittal is strictly
prohibited. If you have received this communication in error, please notify
us immediately by reply or by telephone (collect at 907-564-1000) and ask to
speak with the message sender. In addition, please immediately delete this
message and all attachments. Thank you. ACS





More information about the dba-SQLServer mailing list