John W. Colby
jwcolby at colbyconsulting.com
Tue Oct 5 10:42:45 CDT 2004
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