[dba-SQLServer] QBE tool in query analyzer

Porter, Mark MPorter at acsalaska.com
Tue Oct 5 16:51:38 CDT 2004


That's lotsa airfare from Alaska - but I'd take you up on it!

> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf 
> Of John W.
> Colby
> Sent: Tuesday, October 05, 2004 11:19 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: RE: [dba-SQLServer] QBE tool in query analyzer
> 
> 
> OK well, will you come to my house for a couple of days.  ;-)
> 
> John W. Colby
> www.ColbyConsulting.com 
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf 
> Of Porter,
> Mark
> Sent: Tuesday, October 05, 2004 2:59 PM
> To: dba-sqlserver at databaseadvisors.com
> Subject: RE: [dba-SQLServer] QBE tool in query analyzer
> 
> 
> 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
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 



More information about the dba-SQLServer mailing list