Nested Sql Select Statements
logindpostgres is a script that reads SQL select statements from PostgreSQL logs and generates all the indices to optimize the database for each request. logindpostgres has been tested on 1.2 GB of logs.. Get Postgres 8.1 Intelligent Index generator at SourceForge.net. Fast, secure and free...
|License: Freeware||Size: 8.19 KB||Download (72): logindpostgres Download|
SQL::Interpolate is a Perl module to interpolate Perl variables into SQL statements. SYNOPSIS use SQL::Interpolate qw(:all); # Some sample data to interpolate: my $s = blue; my @v = (5, 6); # Variable references are transformed into bind parameters. # The most basic usage involves...
|License: Freeware||Size: 57.34 KB||Download (72): SQL::Interpolate Download|
Find Foreign Keys. Effortless Data Models. SQL Made Simple.
Attention Developers, Crystal Report Professionals and Data Analysts: The mystery hiding inside your database has just been solved. idxScout investigates keys, indexes and design problems with automatic data modeling. Point it to...
|License: Shareware||Cost: $149.00 USD||Size: 836.21 KB||Download (104): idxScout Download|
SQL SELECT, INSERT, UPDATE and DELETE queries can be generated with the specified table name, arrays of fields and corresponding values and the additional clauses.
|License: Freeware||Size: 10 KB||Download (18): SQL String Generator Download|
SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT statements, that are saved as local .sql files and contain all the data required to create a duplicate table, or to be used for backup purposes. You can choose to create an individual .sql file for each...
|License: Freeware||Size: 408 KB||Download (145): SQL Dumper Download|
LiveDataScript is a handy utility for Microsoft SQL Server 2005 and 2008 that allows you to script data from a database into SQL insert statements.
The application features and easy to use interface, that will make your work even easier. for WindowsXP, Vista, 7
Platforms: Windows, Windows Vista, 7
|License: Freeware||Download (27): LiveDataScript Download|
SQL SELECT queries can be executed and the fields of each result set row can be retrieved into class variables.Object based MySQL can also insert or update records of a table getting the values from class variables with the same name as the fields.
|License: Freeware||Size: 10 KB||Download (18): Object based MySQL Download|
Oh!DB Table Data Gateway can perform the following operations:- Execute SQL SELECT queries from list of fields of a table- Retrieve the highest or the lowest value from an integer primary key table field- Get or delete one record of a table with a given primary key value- Delete all records of a...
|License: Freeware||Size: 10 KB||Download (18): Oh!DB Table Data Gateway Download|
sql4array can execute SQL SELECT queries on bi-dimensional array, for which the first dimension is the row number and the second dimension the field names.The WHERE clause can be used to specify conditions with operators such as =, >,The results are returned as arrays and can be sorted with the...
|License: Freeware||Size: 10 KB||Download (18): sql4array Download|
SQL SELECT queries can be executed to retrieve values of individual rows with a specified primary key value into an array.DELETE queries can be executed to remove rows with a given primary key value.
|License: Freeware||Size: 10 KB||Download (18): MySQL object approach Download|
Easy Connect to MySQL is a very simple class that can be used to connect to a MySQL database and execute a SQL SELECT query.It consists of a single function that does everything at once: connects to a given MySQL database, executes a given SELECT query and returns the query results in a...
|License: Freeware||Size: 10 KB||Download (18): Easy Connect to MySQL Download|
sql_query_generator will generate a large range of SQL SELECT queries from a submitted form.It provides facilites for simple queries on one field on a table, joins, selection of fields to be returned, aliasing of fields (eg. SUM(Price) AS Total), ORDER BY, even multiple queries from one...
|License: Freeware||Size: 10 KB||Download (18): sql_query_generator Download|
View Access,Foxpro,dBase,Excel.Oracle and any ODBC enable Database on UIQ mobile phone like Sony Ericsson P800 or P900.View database tables: all at a time or record at a time.Apply SQL Select queries on database to purify records by adding filter. View database tables: all at a time or record at...
|License: Shareware||Cost: $14.95 USD||Size: 444 KB||Download (80): Mobile Database Viewer(Access,xls,Oracle)for UIQ Download|
The DataKiosk project is a JuK-like database interface tool for generic SQL databases. What does that mean? Essentially, DataKiosk provides a series of wizards (anyone familiar with Qt Designer's database wizards will find them familiar) that allow you to build a custom Juk-like interface for any...
|License: Freeware||Size: 2.1 MB||Download (18): DataKiosk Download|
MDB Viewer Plus is a freeware viewer plus editor for Microsoft Access MDB and Accdb database files. It does not require an install to run provided that Microsoft Data Access Components (MDAC) is installed on your PC (In most versions of Windows this is the case).
MDB Viewer Plus has been...
|License: Freeware||Size: 3.34 MB||Download (102): MDB Viewer Plus Download|
SQL::Schema is a Perl module to convert a data dictionary into SQL statements. SYNOPSIS use DBI; my $dbh = DBI->connect(...); use SQL::Schema; my $schema = SQL::Schema->new($dbh); my $sql = $schema->string; print $sql; print "$schema"; WARNING This is alpha software. It...
|License: Freeware||Size: 33.79 KB||Download (78): SQL::Schema Download|
Advanced SQL To XML Query is a relational database client utility that allows execution of SQL (Structured Query Language) statements on Microsoft SQL Server databases. Resultsets returned by select statements are automatically converted to XML files and persisted to a directory of your choice....
|License: Shareware||Cost: $9.95 USD||Download (30): Advanced SQL To XML Query Download|
Due to the complexity of the SQL grammar, many people have attempted but failed to generate a successful parser. Here, at Gudu Software, we have developed a parser that can successfully reduce the difficulties associated with decoding SQL grammar. Vendors are constantly releasing new versions of...
|License: Shareware||Cost: $149.95 USD||Size: 3 MB||Download (29): General SQL Parser .NET Download|
Simple MySQL dump can be used to dump a MySQL database as a list of SQL statements. It can retrieve the database tables metadata and execute and SQL SELECT query to retrieve all the data of the tables to be dumped.Simple MySQL dump returns a string with the table creation and record insertion...
|License: Freeware||Size: 10 KB||Download (18): Simple MySQL dump Download|
This is a plugin that transform Kate into a simple, light, versatile and useful SQL client. It take the advantages of the Qt Sql module to allow you to open connections with all supported SQL drivers (MySQL, PostgreSQL, SQLite, ODBC, etc...) and easily launch queries on database. Some of the main...
|License: Freeware||Size: 20.48 KB||Download (16): Kate SQL Plugin Download|