Sql Select Distinct

SQL Engine can execute SELECT, INSERT, UPDATE and DELETE queries. It takes care of emulating auto-increment fields if these are not supported, using sequences.SQL Engine can also create a new database table or alter its fields if the table already exists. A separate class can be used to log the...

DBIx::SQL::Abstract is a Perl module that provides a convenient abstraction layer to a database. SYNOPSIS use DBIx::SQL::Abstract; my $dbh = DBIx::SQL::Abstract->new( %dbcfg ); Building SQL Abstractions. my($query, @bind) = $dbh->select($table, @fields, %where, @order); my($query,...

SQL::Preproc is a Perl module to embed SQL in your Perl (ala SQL preprocessors). SYNOPSIS use SQL::Preproc subclass => Chart, emit => 1, keepsql => 1, syntax => [ Teradata ], pponly => 1, relax => 1, alias => 1, debug => 1; use DBI; use DBI qw(:sql_types); use...


Platforms: *nix

SQL::Statement::Embed can embed a SQL engine in a DBD or module. SQL::Statement is designed to be easy to embed in other modules and to be especially easy to embed in DBI drivers. It provides a SQL Engine and the other module needs to then provide a data source and a storage mechanism. For...


Platforms: *nix

SQL::Amazon::Request::Help is an Interface to retrieve Help content. SYNOPSIS $dbh = DBI->connect(dbi:Amazon:, $amznid, undef, { amzn_mode => books, amzn_locale => us, amzn_max_pages => 3 }) or die "Cannot connect: " . $DBI::errstr; # # search for some Perl DBI books # $sth =...


Platforms: *nix

SQL::Amazon::UserGuide is a Perl module with user Guide for DBD/SQL::Amazon. SYNOPSIS # # create the parser, passing in the current Amazon metadata # my $parser = SQL::Amazon::Parser->new(%attrs); # # parse a SQL statement, returning a SQL::Amazon::Statement # my $stmt =...


Platforms: *nix

EMS SQL Query for SQL Server is an easy to use software that enables you to quickly build SQL queries to Microsoft SQL databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables and...


Platforms: Windows

EMS SQL Query 2011 for MySQL is the tool that allows you to manage SQL queries to your MySQL databases quickly and simply. Visual building as well as direct editing of query text is available. EMS SQL Query for MySQL is a tool that lets you quickly and simply build SQL queries to MySQL...


Platforms: Windows, 2K, XP, 2003, Windows Vista, 7, 7x64

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

EMS SQL Query for Oracle is a powerful utility that helps you create SQL queries for Oracle databases in a few minutes. Visual Oracle query building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to Oracle databases, select tables...


Platforms: Windows, 2K, XP, 2003, Windows Vista, 2008, 7, 7x64

Copy Schema for SQL Server Pro is a handy application that allows you to create a backup copy for database objects definitions. You can include all tables or select only a part of them and add views, procedures and relationships. This handy utility allows database developers, users and...


Platforms: Windows, XP, 2003, Windows Vista, 2008, 7, 7x64

The SQL Azure Migration Wizard was developed to help you migrate your local SQL Server 2005 / 2008 databases into SQL Azure. The wizard walks you through the selection of your SQL objects, creates SQL scripts suitable for SQL Azure, and allows you to edit / deploy to SQL Azure. The SQL Azure...


Platforms: Windows, Windows Vista, 7

Free SQL Formater is a simple, accessible and easy-to-use Open Source SQL formatter. Now you can use this tool every time you want to format or unformat your SQL files. All you have to do is select the SQL file you need and the program will do the rest.


Platforms: Windows, Windows Vista, 7

EMS SQL Query for PostgreSQL is an useful software that enables you to quickly build SQL queries to PostgreSQL databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables and fields for a...


Platforms: Windows

DBSync for MS SQL & PostgreSQL is a database synchronizer which performs MS SQL to PostgreSQL and PostgreSQL to MS SQL database conversion and synchronization simply by configuring several options in wizard-like application. This tool gives you chance not only convert your data with...


Platforms: Windows, 2K, XP, 2003, Windows Vista, 7

Please take a closer look at the efficiency of SQL mdf recovery application by evaluating SQL MDF Recovery Free on your computer, it should not take a lot of time. Thanks to the friendly interface of database recovery program you may start the analysis of corrupted databases as soon as you...


Platforms: Windows

PHP REST SQL is a class used to open a HTTP REST interface to a MySQL database using PHP and a HTTP server.Using standard HTTP requests, the data in a database can be created, retrieved, modified and deleted.PHP REST SQL was built and tested using Apache 2.0.45, PHP 4.3.4, and MySQL 3.23,...


Platforms: PHP

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

SELECT, INSERT, UPDATE and DELETE queries can be executed from lists of parameters defining tables, fields, field values and condition clauses with MySQL Database Layer With Dynamic SQL Generators.


Platforms: PHP

This PHP script SQL class alfars is designed to implement a very simple MySQL database access wrapper. A connection was established to a given MySQL server with this script, and then select the database to access, execute queries, return the results and safely close the connection.


Platforms: PHP