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|
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 (19): 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 (20): sql_query_generator 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 (116): 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|
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|
SQL::Abstract::Limit is a portable LIMIT emulation. SYNOPSIS use SQL::Abstract::Limit; my $sql = SQL::Abstract::Limit->new( limit_dialect => LimitOffset );; # or autodetect from a DBI $dbh: my $sql = SQL::Abstract::Limit->new( limit_dialect => $dbh ); # or from a Class::DBI class: my...
|License: Freeware||Size: 14.34 KB||Download (81): SQL::Abstract::Limit Download|
Apalogretrieve program retrieves data from an Apache logfile with a syntax, that is derived (a subset of) the SQL language. The idea to make such an implementation came up at 17th of July 2007. I just started it then. The basic idea of using an SQL-like dialect for logfile-analysis I had many...
|License: Freeware||Size: 12.29 KB||Download (71): Apalogretrieve Download|
This tool converts SQL table or query results (multiple resultset) to MS Excel file (.xls file). With the help of Convert SQL to Excel you'll be able to easily turn SQL queries as well as tables into XLS files.
This tool also allows you to convert/export multiple tables (multiple query results)...
Platforms: Windows, Windows Vista, 7, 7x64
|License: Freeware||Download (34): Convert SQL to Excel Download|
EMS SQL Manager for Oracle is a high performance tool for Oracle Database Server administration and development. SQL Manager for Oracle works with any Oracle versions from 8.1.7 to 10g and supports all Oracle objects and all Oracle data types including the new BINARY_FLOAT and BINARY_DOUBLE...
|License: Freeware||Size: 13.82 MB||Download (318): EMS SQL Manager 2007 Lite for Oracle Download|