[dba-SQLServer] QBE in Query analyzer

well.. if you are using QA, open the object browser (F8) and you will
have access to your Tables/columns.. it's a matter of dragging and
dropping names.  However to actually create joins etc, you'll need to
type.

IMNSHO, EM sometimes creates confusing joins that don't necessarily
exploit the speed of Sql Server.


On Tue, 05 Oct 2004 11:42:45 -0400, John W. Colby
<jwcolby at colbyconsulting.com> wrote:
> Well, yes and no.  I can do that by new / view and not save the view.  The
> biggest problem is that things time out in EM whereas they don't in QA.
> 
> 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 Charlotte
> Foust
> Sent: Tuesday, October 05, 2004 11:26 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: RE: [dba-SQLServer] QBE in Query analyzer
> 
> If you right click on a table in EM and select Open-->Query, you can build
> and test a query on the fly without saving it as a view.  Does that help?
> 
> Charlotte Foust
> 
> -----Original Message-----
> From: John W. Colby [mailto:jwcolby at colbyconsulting.com]
> Sent: Tuesday, October 05, 2004 6:34 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: [dba-SQLServer] QBE in Query analyzer
> 
> 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
> 
> _______________________________________________
> 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>