Sql Query Examples

Execute the same SQL query across multiple ODBC databases. You can execute any type of query on any database with an ODBC driver (Microsoft SQL Server, Oracle, mySQL, etc...). It is not unusual that a DBA needs to run the same query across multiple instances. The query can be anything from a...

SQL Chart is a reliable SSMS addin desgined to enable users to render a chart from SQL data. Simply create a query that returns data in two columns. First column for X axis and second for Y. The SQL query code must be selected before requesting chart render.

dbForge SQL Complete is a useful add-in for SQL Server Management Studio 2000, 2005 and 2008 that offers powerful autocompletion and formatting of T-SQL code. Besides extending List Members, Complete Word and Parameter Info features, SQL Complete adds SQL Formatter to enrich the developer...


Platforms: Windows

Arabic MySQL Query can be used to build MySQL SQL query conditions to search for Arabic text considering Arabic lexical rules. It uses the MySQL REGEXP and LIKE functions to retrieve better results from queries for Arabic text.


Platforms: PHP

SQL Parse Convert to Tree Array takes a given SQL query and parse it to extract the structure or queries and sub-queries. The resulting structure is returned as an array.SELECT, INSERT, UPDATE and DELETE queries are currently supported.


Platforms: PHP

xSelect is a command-line utility that allows you to search textfiles. However, compared to tools like "grep" or "find", xSelect allows you to use a SQL-query statement for analyzing textfiles incl. filtering, sorting, ordering and grouping Usage: xSelect [fields-to-display[ FROM...


Platforms: Windows

A power SQL Query Tool for any databases. Provides console and GUI application; Supports Oracle, MS-SQL, PostgreSQL, MySQL, Access, Excel and so on, everyone can manage all of them in one program, all types of SQL queries can be scripted.


Platforms: Windows

miMas is an intuitive GUI tool for SQL query development and data browsing. It provides a common set of features across all databases and can be installed on any Operating System which has a Java Runtime available. The tool uses JDBC drivers for connecting to a database. For most popular...


Platforms: Windows, Mac, Linux

SQLpp, A n-Tier generator in C++: generates complex SQL queries, C# wrappers for multiple database


Platforms: Windows, Mac, Linux

SQL Parse and Compile can take an SQL query and parse it to extract the different parts of the query like the type of command, fields, tables, conditions, etc. . It can also compose take different values and compose a SQL query from them .Key Features of SQL Parse and Compile:- Parser: . insert ....


Platforms: PHP

SwisSQL-SQLOne Console - DBA/Developer tool to convert SQL queries from one SQL dialect to another AdventNet SwisSQL offers SQLOne Console, an easy to use Graphical user interface tool to convert SQL queries from one dialect to another. DB Administrators and developers working with...


Platforms: Windows, *nix

Withdata MsSqlToExcel - Export MS SQL Server to Excel easy and quickly. Withdata MsSqlToExcel is a tool to export MS SQL Server data to Excel file. Main features: 1. Export from table, from sql query. 2. Batch export tables at one time. 3. Save configuration...


Platforms: Windows

AnalogX SQLCMD is a simple way to run SQL queries from a batch file, or have a command line based SQL query tool. It allows you to specify a database, username and password (if necessary), and a SQL query you wish to perform. The results are either output to the screen, or alternatively output...


Platforms: Windows

SwisSQL Console :- DBA/Developer tool to convert SQL queries from one SQL dialect to another . SwisSQL offers Console, an easy to use Graphical user interface tool to convert SQL queries from one dialect to another. DB Administrators and developers working with multiple databases can just type a...


Platforms: Windows, Linux

FBquerydesigner is a client written in Java. It permit entering a query viewing a table displaying the query results.It supports saving queries and results to disk.It also contains a designer drag&drop functionality join function and select fields to sho


Platforms: Windows, Mac, Linux

Eyesis Data Grid Control can execute a given SQL query and generate HTML and javascript code to display the data in an HTML table.The table listing can be sorted by clicking on the column header titles.AJAX can also be used to display the data grid tables.


Platforms: Java

PDO XML Grid can executes a given SQL query using PDO and generates a XML document from the query results. An XSL stylesheet can be used to transform the generated XML document into an HTML table.


Platforms: Java

PDO Pagination takes an SQL query and execute it once to retrieve the total number of rows that it would return.HTML code with links to all result pages are being generated, with the page number and number of results being displayed per page, listed.


Platforms: PHP

PHP MySQL Grid is a given SQL query can be executed against a specified MySQL database and the results can be retrieved in an HTML table.The rows of the table may be displayed with configurable alternate styles.


Platforms: PHP

PHP AJAX pagination takes as parameters an SQL query, the number of results to show per page and the current page number.HTML and javascript code is generated in order to display links for browsing the query result pages.When the user clicks on the links an AJAX request is sent to a script that...


Platforms: PHP