Klos, Susan
Susan.Klos at fldoe.org
Thu Oct 7 06:50:09 CDT 2004
Someone on Accessd, years ago, developed a small Access database that wrote sql code. It was a great little tool, and I thought it would be useful for folks who didn't use the qbe in Access. I have since lost it due to changing machines several times. Does anyone else remember this tool? It might be helpful, I don't know. I haven't even looked at it for years. Susan Klos Senior Database Analyst Evaluation and Reporting Florida Department of Education 850-245-0708 sc 205-0708 -----Original Message----- From: Charlotte Foust [mailto:cfoust at infostatsystems.com] Sent: Wednesday, October 06, 2004 8:22 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] QBE tool in query analyzer Could they be referring to the Create View Wizard?? Charlotte Foust -----Original Message----- From: Arthur Fuller [mailto:artful at rogers.com] Sent: Wednesday, October 06, 2004 5:01 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] QBE tool in query analyzer 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 _______________________________________________ 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