[dba-SQLServer] QBE tool in query analyzer

Charlotte Foust cfoust at infostatsystems.com
Wed Oct 6 19:22:18 CDT 2004


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




More information about the dba-SQLServer mailing list