[dba-SQLServer] QBE tool in query analyzer

you paying the air-fare? WOW :D... I'd like to try out Jet Blue, thanks :D


On Tue, 05 Oct 2004 15:18:43 -0400, John W. Colby
<jwcolby at colbyconsulting.com> wrote:
> 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
> 
> 


-- 
-Francisco
<a href="http://pcthis.blogspot.com">Pc This! pc news with out the jargon</a>