Database query tool


Содержание

Query and View Designer Tools (Visual Database Tools)

When you design a query, view, in-line function, or single-statement stored procedure, the designer you use consists of four panes: the Diagram pane, the Criteria pane, the SQL pane, and the Results pane.

The Diagram pane displays the tables and other table-valued objects that you are querying. Each rectangle represents a table or table-valued object and shows the available data columns. Joins are indicated by lines between the rectangles. For more information, see Diagram Pane (Visual Database Tools).

The Criteria pane contains a spreadsheet-like grid in which you specify options, such as which data columns to display, what rows to select, how to group rows, and so on. For more information, see Criteria Pane (Visual Database Tools).

The SQL pane displays the SQL statement for the query or view. You can edit the SQL statement created by the Designer or you can enter your own SQL statement. It is particularly useful for entering SQL statements that cannot be created using the Diagram and Criteria panes, such as union queries. For more information, see SQL Pane (Visual Database Tools).

The Results pane shows a grid with data retrieved by the query or view. In the Query and View Designer, the pane shows the results of the most recently executed SELECT query. You can modify the database by editing values in the cells of the grid, and you can add or delete rows. For more information, see Results Pane (Visual Database Tools).

You can create a query or view by working in any of the panes: you can specify a column to display by choosing it in the Diagram pane, entering it into the Criteria pane, or making it part of the SQL statement in the SQL pane.

Displaying and Hiding Panes

To hide a pane or display a pane that is not visible, right-click the design surface, point to Pane, and then click the name of the pane. If the Query and View Designer is opened in Query Designer mode, the Results pane is not available.

Database query tool

Web Based Database Query Tool is a simple free Web based MySql database query tool.

Features:
— Web based mysql database query tool in php.
— Easy to use tool that can be integrated in to any web page.
— Dynamically change to any database or host.
— Execute select, update, delete,abase or eries at ease.
— Simple To Use.

This is a GUI Database query tool. It allows a user to request specific information with just a few clicks. It has drill-down and print capabilities and requires no end-user knowledge of the underlying sql or database structure.

This project is a 3-tier Database Query Tool to written in java. The GUI client presents the user with an interface to enter text SQL Queries and view the results. The query server relays requests to the database and formats the response.

a)Easy to use mysql database query tool.
b)UI to add, save and manage frequently user queries.
c)Support for date based queries.
Queries can be added with ‘XXDATE’ variable.
On sleceting the date from a.

A database query tool that allows non-IT experts to build SQL queries by simply selecting which records they want matched.

Database Query Tool — MS Query Analyzer look-alike. Original version from Query Express — www.albahari.com/queryexpress.html

JSqsh is a Java implementation of sqsh, a console based database query tool featuring much of the functionality provided by a good shell, such as variables, redirection, pipes, history, command line editing, and dynamic configuration

A database query tool inspired by TOAD implemented as an Java application. Should work with all databases that supports JDBC.

An open source cross platform Database Query Tool written in Java.

dQuery is a general database query tool like the Microsoft Query. It provide a general query function and some extra ability such like export to Excel (not save as excel files), export to HTML, XML . Another feature is that it use the ADO.

A database query tool inspired by TOAD implemented as an Java application. Should work with all databases with JDBC support.


An easy to use database query tool.

a)Easy to use mysql database query tool.
b)UI to add, save and manage frequently user queries.
c)Support for date based queries.
Queries can be added with ‘XXDATE’ variable.
On sleceting the date from a.

Cross-platform MySQL query tool that allows users to query a MySQL database in a simple but efficient GUI.Includes fetures such as multiple queries and execution only of markedcode snippet.Written in Perl/Tk

HIOX DBQ allows you to add, save, manage user queries and query mysql database.

Web Based Database Query Tool features:
— Easy to use mysql database query tool
— UI to add, save and manage frequently user queries.
-.

‘HCP Metadata Query Tool’ is a GUI-based application that allows to run queries against HCP’s Metadata Query Engine. It is restricted to operation-based queries, which reflect the creation and deletion of objects within HCP. It.

Network Query Tool (NQT) is a one-stop solution for getting info about a domain or IP address. After supplying a hostname or IP, NQT will do the following: reverse lookup, DNS query (dig), whois (domain or IP owner), check port, ping, and traceroute.

PHP Dynamic Word/Excel Generator is an ultra easy-to-use php code for creating dynamic MS Word OR Excel files from a MySQL database query. Suitable for beginners to use.

(Pre-Alpha) Cross-Platform ERD to Database Design Tool built in Java. Currently Supports PostgreSQL. Not Feature-Complete.

SQL Query Tool for MySQL, Oracle, Postgres, MS-SQL, ODBC Drivers and all supported Perl DBI drivers. It was made using Glade and GTK-PERL. Look for GTK-PERL libs before installing this program. Any help would be appreciated.

All files and free downloads are copyright of their respective owners. We do not provide any hacked, cracked, illegal, pirated version of scripts, codes, components downloads. All files are downloaded from the publishers website, our file servers or download mirrors. Always Virus check files downloaded from the web specially zip, rar, exe, trial, full versions etc. Download links from rapidshare, depositfiles, megaupload etc not published.

Advanced Query Tool is a fast and powerful multi-database query tool

AQT talks to all your databases, fast

AQT uses a native ODBC interface which runs reliably and efficiently against databases of all sizes.

AQT is mature and feature rich

AQT ships with an extensive query environment and a wide range of DBA and developer tools.

AQT is easy to use

AQT provides a simple, clean and responsive interface which helps you get your job done fast and efficiently.

One app for all your databases

No other product has AQT’s degree of multi-database support. Configured individually for over 25 different database types, AQT is a specialized product for every database. One tool, one price, for all your databases. In addition, AQT has excellent cross-database features. Load data from Oracle into DB2 z/OS! Compare tables between Sybase and MySQL!

Simple and easy to use


AQT has a simple clean and intuitive interface. Novices find AQT easy to learn; experts enjoy the unprecedented visibility of their databases. Sites with multiple databases appreciate having a single interface for all their databases.

Feature Rich

AQT is packed full of features. AQT will make your life easier no matter whether you are developing reports, managing your database farm, writing stored procedures, loading test data or migrating data between systems. Why have multiple tools, when one can do it all?

Mature, stable and real-world tested

In use since 1999 and with tens of thousands of licenses sold in over 70 countries, AQT is a solidly proven product. Our customers vary from individuals with a handful of tables to large enterprises with hundreds of thousands of tables. AQT works.

I’ve used AQT since I first found it at version 6 and could not live without it. It’s the best universal query tool in the industry. Customer support is beyond the scale. Some think both the product and support are a 10 well they are wrong — it’s easily a 15.

Илон Маск рекомендует:  Что такое код callmsgfilter

As a developer, I have used AQT since 2004, and can say, hands down one of the best tools I have ever used. I use it just about every day, as do a number of developers here. Phil has solved some pretty difficult problems, above and beyond support you will find anywhere. Just for fun, I have history files going back 10 yrs. since I started using AQT and have run 140,720 queries (as of today!)! Yes, some came from batch, but most were entered manually. Used primarily with Oracle, some RDB, and once-in-a-blue-moon — Teradata, Informix and DB2.

Cardett Associates Ltd
PO Box 153, Takaka
New Zealand

Copyright 2002-2020 Cardett Associates Ltd. All rights reserved. AQT is a registered trademark of Cardett Associates Ltd.

Multi-Database Tool and SQL Editor

Altova DatabaseSpy is the unique multi-database query and design tool that even generates elegant charts directly from query results.

SQL Editor and Query Tool

The versatile DatabaseSpy SQL Editor is divided into a SQL statement window and one or more tabbed or stacked Result windows, with a convenient Execute button in the SQL Editor toolbar to let you immediately execute your SQL statements and view the output.

The SQL statement window applies color coding to each SQL statement with unique identification for SQL statements, parameters, operators, and comments to help you quickly and easily review and analyze an individual SQL query or a complex series of SQL commands.

The DatabaseSpy SQL editor features customizable SQL auto-completion to accelerate SQL query development. Execute queries and see immediate results in one or more windows that may be tabbed or stacked.

  • Firebird 2.5, 3
  • IBM DB2 for iSeries ® v6.1, 7.1, 7.2, 7.3
  • IBM DB2 ® 8, 9.1, 9.5, 9.7, 10.1, 10.5
  • Informix ® 11.70, 12.10
  • MariaDB 10, 10.3

  • Microsoft Access™ 2003, 2007, 2010, 2013, 2020
  • Microsoft ® Azure SQL
  • Microsoft ® SQL Server ® 2005, 2008, 2012, 2014, 2020, 2020, 2020
  • MySQL ® 5, 5.1, 5.5, 5.6, 5.7, 8
  • Oracle ® 9i, 10g, 11g, 12c, 18, 19
  • PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4, 9.6, 10, 11
  • Progress OpenEdge 11.6
  • SQLite 3.x
  • Sybase ® ASE 15, 16
  • Teradata 16

SQL formatting configurations are provided for each supported database and appropriate formatting is automatically applied when you switch databases.

DatabaseSpy supports asynchronous query execution, allowing multiple SQL queries to be processed in different windows at the same time, either queries to different servers or even multiple queries against the same server.

Support for SQL Templates

DatabaseSpy includes support for SQL queries that contain parameters, also known as SQL Templates. Parameters can make a query much more flexible, for instance allowing users to easily test complex join statements with multiple values.

The DatabaseSpy SQL Editor and result windows at the top left below show a query to report all orders of a specific product by a specific customer.

This query could be much more flexible by replacing the product name ‘sprockets’ and the customer number 525 with parameters, as shown in the second query window above where the parameters :pname and :custnum are substituted for the product and customer.

When the query with parameters is run directly using the Execute button at the top left of the SQL Editor window, DatabaseSpy 2020 opens a dialog allowing the user to enter values for execution, and the result shown at the lower right is generated.

SQL Templates for DatabaseSpy can be saved in a special projects folder and executed dynamically. Often a user needs to create queries that generate test results to explore unfamiliar data. After a test query is executed, the user can select values from the result table and supply them as parameters to a SQL template stored in the project templates folder.

A new SQL Editor window opens with an automatically-generated query based on the template with selected values assigned to the parameters, the generated query is executed, and the result table is shown.

Graphical Database Design


The DatabaseSpy graphical Design Editor lets you view and edit the structures of all your databases through one graphical user interface. You can examine tables and relationships in an existing database, edit tables to better suit your needs, or even can add entire tables and specify all their column attributes and relationships to other tables from scratch.

The DatabaseSpy database design tool graphical view lets you concentrate on the underlying structure of your data and any required modifications rather than the SQL commands required to implement them. As you work, the DatabaseSpy graphical database designer automatically constructs the SQL statements you will need, but you choose when to execute the database structure change script once all your edits are complete.

The graphical image of each table includes compartments you can expand to view in greater detail or collapse so you can concentrate on table relationships, which are clearly indicated with connecting lines.

The DatabaseSpy graphical database designer supports multiple databases and automatically adjusts contents of pull-down lists of data types and other specialized features.

Generate Complete DDL Scripts for Database Schemas

DatabaseSpy includes a new command to create complete DDL scripts for a database schema. When a database administrator needs to recreate a complete database structure, scripts are required not just to create tables, but also all views, constraints, indexes, functions, procedures, etc. that may be defined in the database.

Right-clicking any database schema in the Online Browser helper window offers the DDL Script command.

The script is then immediately opened for review in a new SQL Editor window.

DDL Scripts are essential for backing up complete database structures, or to move a structure to a different server when the actual table contents are not required, such as moving from a development environment into production.

Data Visualization and Charting

A colorful, eye-catching chart is much more vivid and communicates meaning more effectively than a table of numeric data. DatabaseSpy provides a wide variety of charting features for visualization of SQL query results. Create the most accurate and vivid graphical representation of your data in line charts, bar charts, pie charts, area charts, and many more with advanced formatting options.

  • Chart & graph creation from SQL query results
  • Real-time updates when data changes
  • Granular customization of chart appearance
  • Support for background images
  • Chart overlays to combine chart types
  • Exporting charts in multiple image formats
  • Saving, copying, & printing charts
  • Multiple charts simultaneously from complex queries


Now you can create attractive and informative charts data visualization of information in your database without exporting data to a dedicated charting application. Charts created using DatabaseSpy are customizable to suit business intelligence reports in HTML, Microsoft Word, RTF, or PDF documents, or you can save charts created in DatabaseSpy in your choice of .png, .bmp, .gif, or .jpg image formats at the custom resolution you specify.

The following chart types are supported:

  • Pie charts (2D & 3D)
  • Bar charts (2D & 3D)
  • Stacked bar charts (2D & 3D)
  • Area charts
  • Stacked area charts (with transparency)
  • Category and value line graphs
  • Candlestick charts
  • Gauge charts

Numerous customization options are available for each chart type, including chart titles, foreground and background colors, definition of axis ranges and labels, control of fonts, text colors, fonts and sizes, and more. Intuitive dialogs let you specify every element of a chart, even the tilt angle for 3D pie charts.

Advanced Database Reporting with Charts

For a more complete database reporting solution, Altova StyleVision is an award-winning tool for designing compelling reports and forms based on XML, SQL database, and XBRL inputs. With a few simple steps, you can access data in SQL databases and create visually compelling reports with charts in HTML, PDF, RTF, and Word (Open XML), along with Authentic enterprise forms, all in a single design. Then automatically regenerate the report with updated data any time it’s needed.

Database Content Editor

Information stored in relational databases is rarely static. Existing records are updated or removed, and new information is added to keep the database up to date and accurate, maintaining business value. DatabaseSpy offers convenient database editor tools for database table content. DatabaseSpy lets you edit the content of database tables in an interactive preview window.

As you work, the database editor interacts with the database in a limited manner. When all your changes are complete, you can review your edits and commit them all at once via the Commit button on the toolbar.

In addition to editing data stored in the database, you can learn more about information presented in any DatabaseSpy results table. You can select a range of cells and copy them to paste into another application, print the results table, or automatically calculate and display information about selected results. You can also sort the results by any column to display the table data in a more useful form.

Working with Binary Data

DatabaseSpy helps you easily process binary data in a column defined as a binary data type. You can load binary data into the table from an external file, or save binary data from the database to an external file. Binary data fields supported include BLOB, raw, binary, varbinary, image, and others, depending on the database type.


XML in Databases

Altova DatabaseSpy includes special features to explore, manage, and work with XML in databases. XML is established as the preferred method for exchanging structured data between enterprises, but storing XML data in a relational database adds a layer of complexity. DatabaseSpy includes robust tools to help you analyze and manipulate databases that contain XML information.

Илон Маск рекомендует:  Что такое код wddx_serialize_vars

DatabaseSpy Features for XML:

  • View XML table contents in SQL query results
  • Expand indiv >

When you expand a database table using the DatabaseSpy Online Browser, columns containing XML data are identified in the Browser Tree. You can also explore XML Schemas registered in the database in the browser hierarchy. To examine any XML Schema in detail, you can send it to XMLSpy,, the industry-leading development environment for all XML-related technologies, where it is automatically opened in XMLSpy Schema View for intuitive graphical display.

The DatabaseSpy Data Inspector Window is a helpful option to display long XML entries contained in individual cells. The Data Inspector Window displays XML content with color coding and word wrap, and you can resize the window for a better view. You can also copy XML data from the results window or Data Inspector window to edit offline in XMLSpy. The updated external file is easily replaced in the database.

XMLSpy & SQL Database Integration:

  • Database quick-connect wizard
  • Database Query window with SQL editor
  • Import SQL database data to XMLSpy
  • Create XML Schemas based on SQL database structures
  • Export XML to SQL databases
  • Create a database schema from an XML Schema
  • Support for XML-enabled databases

Data Import and Export

DatabaseSpy lets you select any table or view from any connected database for export. If you select multiple tables or views for export, each is written to a separate file. You can also export XML, XML Structure, CSV, or HTML directly to Altova XMLSpy. When you’re working in the SQL Editor you even have a dedicated Export button to let you instantly open an export dialog box pre-loaded with your current SQL Editor statements.


DatabaseSpy lets you import data into your databases from conventional CSV files or from files containing XML data. Using either format, you can create new tables or update existing tables in your database.

Database Import/Export Features:

  • Import data from XML or CSV formats
  • Import data directly or generate a SQL import script
  • Export data in XML, CSV, HTML, or Excel formats
  • Export from any database table or view
  • Export from a SQL query
  • Copy from query results window to paste into a new app
  • Preview data before import or export

ETL (Extract-Transform-Load) tools provide a mechanism for extracting data from external sources, transforming it to a normalized data format, and then loading it into an end target or repository. With support for prevalent enterprise data formats (XML, JSON, databases, flat files, EDI, etc.), Altova MapForce is an extremely effective, lightweight, and scalable tool for ETL. MapForce offers a straightforward, visual user interface and support for data processing functions and filters.

Convert and Import Data

If you need to convert data from a dissimilar format before importing it to your database, Altova MapForce is the visual mapping tool with the power to map any combination of XML, database, text, or EDI files. MapForce can connect to all major databases and convert source data on the fly for direct insertion.

Database query tool

RazorSQL is a SQL Database Query Tool, SQL editor, Database browser, and administration Tool with support for over 40 databases and built in connection capabilities for Access, Cassandra, DB2, Derby, DynamoDB, Firebird, HSQLDB, H2, Informix, Microsoft SQL Server, MariaDB, MongoDB, MySQL, Oracle, Pervasive, PostgreSQL, Redshift, Salesforce, . Free download of RazorSQL 8.3.4, size 59.31 Mb.

ADeQuaTe — Alan’s Database Query Tool 1.0 adqt.sourceforge.net

This is a GUI Database Query Tool. It allows a user to request specific information with just a few clicks. It has drill-down and print capabilities and requires no end-user knowledge of the underlying sql or Database structure. . Freeware download of ADeQuaTe — Alan’s Database Query Tool 1.0, size 169.64 Kb.

Java Database Query Tool 0.1.1 Jqueryserver

This project is a 3-tier Database Query Tool to written in java. The GUI client presents the user with an interface to enter text SQL Queries and view the results. The Query server relays requests to the Database and formats the response.

Java Database Query Tool 0.1.1 License — GNU General Public License (GPL) . Freeware download of Java Database Query Tool 0.1.1, size 30.41 Kb.


Aqua Data Studio for Oracle 9.0.12 AquaFold, Inc.

Aqua Data Studio is a management Tool for the Oracle relational Database with administration capabilities and a Database Query Tool. The visual administration features provide users the ability to browse and modify Database structures, including schema objects and Database storage, as well as maintain Database security. An integrated Query Tool . Free download of Aqua Data Studio for Oracle 9.0.12, size 167.99 Mb.

Bufon >bufonidae.sourceforge.net

A Database Query Tool inspired by TOAD implemented as an Java application. Should work with all databases that supports JDBC. . Freeware download of Bufonidae 0.1.4, size 258.49 Kb.

FrogDB 0.1 frogdb.sourceforge.net

A Database Query Tool inspired by TOAD implemented as an Java application. Should work with all databases with JDBC support. . Freeware download of FrogDB 0.1, size 207.57 Kb.

JSqsh 1.4 jsqsh.wiki.sourceforge.net

JSqsh is a Java implementation of sqsh, a console based Database Query Tool featuring much of the functionality provided by a good shell, such as variables, redirection, pipes, history, command line editing, and dynamic configuration . Freeware download of JSqsh 1.4, size 2.17 Mb.

QueryIT 1.170 queryit.sourceforge.net

ODBC — Database Query Tool SQL,DB2,mySQL. Feel free to test, use or Improve this program. . Freeware download of QueryIT 1.170, size 3.32 Mb.

Report4j 1.0 Report4j

An easy to use Database Query Tool.

Report4j 1.0 License — GNU General Public License (GPL) . Freeware download of Report4j 1.0, size 0 b.

Invantive Query Tool 2013R2FR Invantive Software B.V.

Free Real-time Operational Intelligence
Invantive’s free Query Tool provides you with real-time Operational Intelligence (OI) across your entire enterprise. The free Query Tool provides access to your real-time data warehouse and databases running on MySQL, Oracle, SQL Server, Teradata, IBM DB2/UDB or elsewhere. This enables you to store, . Freeware download of Invantive Query Tool 2013R2FR, size 29.43 Mb.

Multiple Database Query Analyzer 2.1 Vsisoftware.com

Multiple Database Query Analyzer 2.1 supports qurries with diffrent types of databases. It supports Sql, Access, Oracle, MySql. It lets you have diffrent profiles to store data, also has options to hold querrys and export data. Vsisoftware.com . Free download of Multiple Database Query Analyzer 2.1, size 9.82 Mb.

DBF Database Recovery Tool 5.01 Data Recovery Software

Kernel Recovery for DBF — DBF Database recovery Tool supports Database recovery from Microsoft Visual FoxPro (.dbf) databases. DBF recovery Tool recovers data from corrupted DBF Database files corrupted due to unexpected system shutdown, virus attacks or error reading media where Database are stored. The Software uses Live Preview technology, which . Free download of DBF Database Recovery Tool 5.01, size 1.23 Mb.

Windows Installer Query Tool 1.86 DEMO.SU

Windows Installer Query Tool is a handy Office addin designed to enable users to execute MSI queries.


Both SELECT and UPDATE are possible, batch processing, decoding of InstallShield strings, GUID generation and coding/decoding for registry searches.

You can also collect queries in the sheets for future refrence and use in the . Free download of Windows Installer Query Tool 1.86, size 0 b.

Yet Another Query Tool 0.9.1 Michiel T’Jampens

Yet Another Query Tool is a small, easy to use, Java based Tool specially designed to offer you a simple SQL Query Tool that allows to connect to SQL servers and MDB files, basic commands are supported at the moment.

Others are added on need basis. A form of linking queries is possible and showing result in a map or in a chart is build . Freeware download of Yet Another Query Tool 0.9.1, size 0 b.

ODBC Database Query 2.2 S. Chepurin

Database Query application that allows a user to simultaneously connect to multiple heterogeneous databases using ODBC and perform SQL queries.

Give ODBC Database Query a try to see how useful it can be for you!

. Free download of ODBC Database Query 2.2, size 0 b.

Exchange Database Recovery Tool 5.0 Exchange Database Recovery Tool

If you want to recovery Exchange Database from un-mounted Exchange EDB file so you can use PDS best Exchange Database Recovery Tool because this is wonderful EDB Database recovery program which quickly repair corrupt EDB file and recover data from exchange EDB file along with every email properties- To, Cc, Bcc, Subject, Date, and Time. With the . Free download of Exchange Database Recovery Tool 5.0, size 3.55 Mb.

The Query Tool 2005 6.0.1 Tyson Software Ltd.

The Query Tool is a powerful data mining application. It allows you to perform data analysis on any SQL Database. It has been developed predominately for the non technical user. No knowledge of SQL is required, most actions are data driven. NEW features : Query Builder, quickly and simply build powerful queries to interrogate your data; Summary; . Free download of The Query Tool 2005 6.0.1, size 2.74 Mb.

ODBC View 3.3.0 SLIK Software Ltd

ODBCView is a free SQL Query Tool that allows you to view and export data from any OBDC compliant Database. Connect to an ODBC data source and enter a SQL statement to execute. Any resulting data is displayed on a read-only grid or it can be exported to a external CSV or HTML report file. Any valid SQL statement can be executed including UPDATE, . Free download of ODBC View 3.3.0, size 4.17 Mb.

Илон Маск рекомендует:  ShowMessagePos - Процедура Delphi

FlySpeed SQL Query 2.9.7 Active Database Software

If you are looking for an SQL Query Tool that is powerful, containing all of the features that you need yet is still easy to learn and use, then FlySpeed SQL Query provides exactly what you need. This program, supporting all of the popular Database structures amongst some lesser known ones, makes the task of accessing and exporting your data easy. . Free download of FlySpeed SQL Query 2.9.7, size 14.12 Mb.

ODBCView 4.0 Ascida Ltd

ODBCView is a free SQL Query Tool that allows you to view and export data from any OBDC compliant Database. Connect to an ODBC data source and enter a SQL statement to execute. Any resulting data is displayed on a read-only grid or it can be exported to a external CSV or HTML report file. Any valid SQL statement can be executed including UPDATE, . Freeware download of ODBCView 4.0, size 1.93 Mb.

Database Query Tool

I am sure this may seem like a stupid question to some folks, and it probably is, but I am going to ask it anyway. I kinda of fell into being responsible for our ERP system (Oracle based) and we also have a separate RFid system that stores data in Microsoft SQL Server.

Our ERP system uses Crystal Reports to query the data and obviously spit out reports. I created Macros in Excel to pull and manipulate data from Microsoft SQL Server; some of these macros are 600 lines long.

Now, on to my question. I am not skilled enough in Crystal to created reports that run macros like that. And I don’t want to use Excel to grab data all of the time. I want to be able to create «apps» if you will for users to pull their own reports. Currently I am the only person that access the data and the only person that can do anything with the data. What tool should I use to create these ‘programs’ for users? It’s time this old dog learns some new tricks. We have new people hired and they want to see data! God bless them! :) Thanks in advance for your help!!

SQL Query Tool (Using ODBC)

Publisher’s Description

SQL Query Tool (using ODBC) is a Universal Data Access (UDA) tool.

It lets you query ODBC data sources, author SQL scripts and queries, execute multiple SQL scripts or stored procedures simultaneously, return query results to a grid or free-form text, export results in Excel and HTML formats, retrieve ODBC driver information and more. A separate 64-bit version is also available.

What do you need to know about free software?

Publisher’s Description

SQL Query Tool (using ODBC) is a Universal Data Access (UDA) tool.

It lets you query ODBC data sources, author SQL scripts and queries, execute multiple SQL scripts or stored procedures simultaneously, return query results to a grid or free-form text, export results in Excel and HTML formats, retrieve ODBC driver information and more. A separate 64-bit version is also available.

Database query tool

At the top of the class, define a string to hold the text results:

Modify the QueryMaster function to connect an InfoMessage handler:

Add a function to gather the text.

Modify the ExecuteQuery function.

Todd Smith 21-Aug-08 11:55
If you have proper permissions setup then SQL-SMS shouldn’t pose any problems. And there’s nothing to prevent someone from using it anyways right? KChandos 21-Aug-08 14:21

**** Keep in mind that this utility was designed and intended for an enterprise organization, not a home or hobbyist user. Within the targeted enterprise there are approximately 2,300 users who have been given SQL-SMS because of lazy DBA’s and a lack of IT support.

SQL-SMS is an issue even with proper permissions because you’re giving low level access to the production database to your end users, and the permissions will never be bullet proof.

Your end users will, inevitably, create a query that will bring the server to a grinding halt. If you believe otherwise then I submit to you that you’ve been working in a very sheltered environment!

You should *NEVER* expect or require your end users to know about your database, relationships, etc. Give them something that they can use (search for Reporting here on CodeProject).

As for preventing someone from using it, in an enterprise environment it’s actually quite easy to prevent the use of any unapproved application. There are many tools available to control exactly that, and most large enterprises (with a high level of competency) will set group policies such that the end users can not install any software on their machine except what gets published to them.

Sign In· View Thread
Web version

mikedepetris 21-Mar-07 4:46
Would it be perfect to put this tool on a web page, hiding the connection strings to users? First step would be having one page for each connection, next step to manage associations between users and db visibility.

Nice job anyway.

Sign In· View Thread
Re: Web version

KChandos 21-Mar-07 7:41

Actually, no. It wouldn’t be perfect. Ideally you should provide to your users a dynamic query capability based upon their workflow and lookup requirements.

I usually provide a lookup page that allows the user to select from canned queries that prompt them for the appropriate parameters (in user-speak, not geek-speak), then the query is executed on the server with the results being output to the browser, or optionally, output to the browser with an appropriate mime type (such as for excel).

That way I can control the query itself and optimize data access, and the user gets the information they need in a way that they can understand. They never care about database schema, access methods, joins, etc. and the connection strings are *always* invisible.

Sign In· View Thread
Binary please

K R Mellor 12-Mar-07 7:16
Any chance of binary for us VS 2003 users? KChandos 13-Mar-07 18:26
The binary is now downloadable.
Sign In· View Thread
Simple — Nicely done Rich Hamack 6-Mar-07 12:53
I too have clients which require «select» access to their database, but don’t want a full-blown query tool. This bridges the gap nicely, and can easily control unauthorized data tampering. Providing optional output to Excel is a nice touch.
Sign In· View Thread
Last Visit: 12-Nov-19 1:51 Last Update: 12-Nov-19 1:51 Refresh 1

General News Suggestion Question Bug Answer Joke Praise Rant Admin

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

WinSQL

database query tool WinSQL is a database client that can connect to any database through ODBC. It prov > WinSQL also offers syntax highlighting for SQL scripts and can display query results in in gr > Copyright Snapfiles.com

Trial Limitations: Time & feature limited evaluation version

Product Details

Publisher Synametrics Price $99.00
Version 11.0.214 Last updated Nov 27, 2020
File Size 31.3 Mb Requirements None

User Reviews

  • About
  • Home
  • Contact us
  • About SnapFiles
  • Privacy Policy
  • Terms of Use
  • Selections
  • Editor’s Selections
  • Latest User Reviews
  • Top 50 User Favorites
  • Portable Apps
  • Must-Have Freeware
  • Downloads
  • Freeware Categories
  • Shareware Categories
  • Top 100 Downloads
  • Latest Updates
  • Now Downloading.
  • Other Stuff
  • Feedback & Suggestions
  • Developer Center
  • Login/Signup
  • RSS feeds
  • Facebook

Copyright 1997-2020 WebAttack, Inc. WEBATTACK and SNAPFILES are registered trademarks of WebAttack Inc. All rights reserved. All other trademarks are the sole property of their respective owners.

Query and View Designer Tools (Visual Database Tools)

When you design a query, view, in-line function, or single-statement stored procedure, the designer you use consists of four panes: the Diagram pane, the Criteria pane, the SQL pane, and the Results pane.

The Diagram pane displays the tables and other table-valued objects that you are querying. Each rectangle represents a table or table-valued object and shows the available data columns. Joins are indicated by lines between the rectangles. For more information, see Diagram Pane (Visual Database Tools).

The Criteria pane contains a spreadsheet-like grid in which you specify options, such as which data columns to display, what rows to select, how to group rows, and so on. For more information, see Criteria Pane (Visual Database Tools).

The SQL pane displays the SQL statement for the query or view. You can edit the SQL statement created by the Designer or you can enter your own SQL statement. It is particularly useful for entering SQL statements that cannot be created using the Diagram and Criteria panes, such as union queries. For more information, see SQL Pane (Visual Database Tools).

The Results pane shows a grid with data retrieved by the query or view. In the Query and View Designer, the pane shows the results of the most recently executed SELECT query. You can modify the database by editing values in the cells of the grid, and you can add or delete rows. For more information, see Results Pane (Visual Database Tools).

You can create a query or view by working in any of the panes: you can specify a column to display by choosing it in the Diagram pane, entering it into the Criteria pane, or making it part of the SQL statement in the SQL pane.

Displaying and Hiding Panes

To hide a pane or display a pane that is not visible, right-click the design surface, point to Pane, and then click the name of the pane. If the Query and View Designer is opened in Query Designer mode, the Results pane is not available.

Понравилась статья? Поделиться с друзьями:
Кодинг, CSS и SQL