[dba-SQLServer] QBE tool in query analyzer

Stephen Bond stephen at bondsoftware.co.nz
Thu Oct 7 23:57:54 CDT 2004


I've got one sitting here - looks like it's from Terry Kreft / Dev Ashish, about 500KB

Stephen Bond
Otatara, New Zealand

> -----Original Message-----
> From: Klos, Susan [mailto:Susan.Klos at fldoe.org]
> Sent: Friday, 8 October 2004 12:50 a.m.
> To: 'dba-sqlserver at databaseadvisors.com'
> Subject: RE: [dba-SQLServer] QBE tool in query analyzer
> 
> 
> 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
> 
> _______________________________________________
> 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