Board index MS SQL Server

SQL Server SQL Query Builder

SQL Server SQL Query Builder

Post by Who? Me » Wed, 07 Jul 1999 04:00:00



SQL Server SQL Query Builder

Does a 3rd party software program exist that builds SQL Server SQL
statements (Insert, Update, Delete, etc.).   MS Access has a built in
SQL query builder.    In
MS Access just build the query via the query tab.  When the query is
working just
right, you can copy/paste the SQL statement in to othe programs.  I want
to do the
same for SQL Server.   Since MS-Access and SQL Server use different SQL
statement syntax I need one for SQL Server 6.5.

If anyone knows of a 3rd party (after market) program that does this
please let
me know.


 
 
 
Top

SQL Server SQL Query Builder

Post by Alan Brewe » Wed, 07 Jul 1999 04:00:00


I don't know about 3rd-party products for SQL 6.5, but there is a graphical
query designer that comes up in a few places in SQL Server 7.0 Enterprise
Manager. For example:

* Click on a table and select Open Table.
* Click on the views icon and select New View.

Once you have this up you can build queries graphically.

--
Alan Brewer
Technology Lead
SQL Server Documentation Team

 
 
 
Top

1. Query Builder or SQL Builder

    Does anybody know, if there is any kind of Query Builder or SQL Builder
that i can use in my programs, so that the users can build their own queries
?

2. How Do You Import a Comma Delimited ASCII File?

3. Query problem with SQL Server 2000 + Power Builder 8

4. Passing a "recordset" to a stored proc...

5. Access style query builder for SQL Server?

6. unable to allocate new page error....?

7. Query Builder for SQL Server?

8. Brio & Intranet

9. Beta: SQL::Builder -- an OO SQL builder Perl module

10. UK query - Delphi3 - NT4-Memory leak on SQL Query to SQL/server 6.5

11. How to programmetically invoke SQL Query Builder

12. SQL 7 Views performance/ Query Builder

13. Visual SQL query builder


All times are UTC
Board index