RE: Query Builder Tool

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: mark baekdal (markbaekdal_at_discussions.microsoft.com)
Date: 01/17/05


Date: Sun, 16 Jan 2005 22:59:06 -0800

Hello DavidM.

You can use Enterprise Manager for an interface very similar to Access.
Click the tables node to get a listing of all the tables in the right pane.
Select a table and right click. Select open table from the pop up menu.
Select Query. You should now see an interface like Access that you can use to
design queries.

regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
 

"DavidM" wrote:

> Hello -- does anyone know of any good tools to create queries for SQL
> Server? I'm currently using Query Analzyer, but would like something a bit
> more QUI oriented similar to what Access has -- where I can insert tables
> and drag columns, etc.
>
> Any help would be appreciated.
>
>
>
>



Relevant Pages

  • RE: Query Builder Tool
    ... You can use Enterprise Manager for an interface very similar to Access. ... Database change management for SQL Server ... I'm currently using Query Analzyer, but would like something a bit ...
    (microsoft.public.sqlserver.programming)
  • RE: Query Builder Tool
    ... You can use Enterprise Manager for an interface very similar to Access. ... Database change management for SQL Server ... I'm currently using Query Analzyer, but would like something a bit ...
    (microsoft.public.sqlserver.tools)
  • Re: [STAThread]
    ... Java failed on the Windows client. ... SQL Server and many more expsose ... The unmanaged hosting interface ... 'Apartment' threaded COM objects have STA thread affinity, ...
    (microsoft.public.dotnet.languages.csharp)
  • invalid value specified for STOPAT parameter
    ... I too had problems when trying to perform a Point in Time restore ... Enterprise Manager, I receive a error message "Invalid value specified ... "YDM" by SQL Server where as the value supplied by the SQL Server ... Select "British English", then hit OK. ...
    (microsoft.public.sqlserver.server)
  • RE: Upgrading to SQL 2005 ENT
    ... I left the reporting services off. ... It gives a good step by step how to on upgrading to SQL Server 2005. ... some SQL Server features will not be available for installation. ... It has the same version from the Enterprise Manager. ...
    (microsoft.public.sqlserver.server)