Arthur Fuller
artful at rogers.com
Wed Oct 6 19:00:39 CDT 2004
Francisco Tapia wrote: >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 >> >> >> >> > > > > In BOL, there are numerous references to something called Visual Database Tools (look in the Contents under Using the SQL Server Tools. They talk in here about a Visual Query Designer. Where does this thing live? I've never seen it! Arthur