Nested Sql Select Statements

DTM SQL runner is a free command line tool for SQL statements execution. The runner allows the user to specify ODBC data source name and file with SQL statement to be executed. This handy tool for developers, database administrators and advanced users is suitable for batch and scheduled job...

SQL VB ASP Code Generator is a powerful multi-purpose tool that lets you effortlessly generate SQL, VB and ASP Code. You can even generate an entire VB application or ASP web application, all derived from the tables in your database with just one click. No more recreating the same old SELECT,...

Export Query to SQL utility allows you to export results of a query execution to the set of SQL statements. This data export tool supports all modern versions of Microsoft SQL Server. The program has easy to learn and to use wizard interface. This useful program will enable database...


Platforms: Windows, XP, 2003

Nested Sets DB Tree can be used to manipulate nested sets of database table records that form an hierarchical tree.Features of Nested Sets DB Tree:- It provides means to initialize the record tree, insert record nodes in specific tree positions, retrieve node and parent records, change position...


Platforms: PHP

SOAP-SQL generates a web service WSDL based on user-defined SQL statements with only a few lines of code.It relies on NuSOAP and PEAR MDB2 (DB abstraction layer), so it works with most any database. No PHP extensions required.


Platforms: PHP

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...


Platforms: PHP

SQL Parsing is a simple class that can parse text files with a list of MySQL query statements to be executed.SQL Parsing splits the file lines, skips comment lines and gathers all consecutive lines until the one ends with semi-colon to get the complete SQL statement.Each statement is executed as...


Platforms: PHP

Apache SQL analyser can query Apache logfiles via SQL. asql is a simple console shell which allows you to run SQL queries against an Apache logfile, something that can be very useful - especially at getting information which is not easily available via static logfile analysers. An overview of...


Platforms: *nix

KNOCKS SQL-Sense provides Intellisense style help while writing SQL Statements in Microsoft Query Analyzer, SQL Server 2005 Management Studio, Visual Studio 2005 and Visual Studio .NET 2003. It simply sits behind the scenes and provides unobtrusive help when you press Ctrl-Space or when you type...


Platforms: Windows

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,...


Platforms: *nix

Yet Another dia2sql is a tool that generates SQL statements from Dia XML files. yadia2sql is intended to process diagrams that are compatible with dia2sql.php to some point, and provide features that would allow generation of SQL code for different database systems from single Dia source....


Platforms: *nix

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::Shell is a command interpreter for DBI shells. SYNOPSIS use SQL::Shell; #Initialise and configure my $sqlsh = new SQL::Shell(%settings); $sqlsh->set($setting, $new_value); $value = $sqlsh->get($setting); #Interpret commands $sqlsh->execute_command($command);...


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

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