Sql Select Distinct

SQL::Translator::Producer::GraphViz is a GraphViz producer for SQL::Translator. SYNOPSIS use SQL::Translator; my $trans = new SQL::Translator( from => MySQL, # or your db of choice to => GraphViz, producer_args => { out_file => schema.png, add_color => 1, show_constraints => 1,...

Oracle::SQL is a Perl extension for building SQL statements. SYNOPSIS use Oracle::SQL; No automatically exported routines. You have to specifically to import the methods into your package. use Oracle::SQL qw(:sql); use Oracle::SQL /:sql/; use Oracle::SQL :sql; This is a package...

Dimedis::Sql is a SQL/DBI Interface for banking applications. SYNOPSIS use Dimedis::Sql; my $sqlh = new Dimedis::Sql ( ... ); $sqlh->install ( ... ); my $seq_id = $sqlh->insert ( ... ); my $modified = $sqlh->update ( ... ); my $blob_sref = $sqlh->blob_read ( ... ); $sqlh->use_db (...


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

Rose::DB::Object::QueryBuilder is a Perl module that can build SQL queries on behalf of Rose::DB::Object::Manager. SYNOPSIS use Rose::DB::Object::QueryBuilder qw(build_select); # Build simple query $sql = build_select ( dbh => $dbh, select => COUNT(*), tables => [ articles ], columns...


Platforms: *nix

SQL::Generator is a Perl module to generate SQL-statements with oo-perl. SYNOPSIS use SQL::Generator; With this module you can easily (and very flexible) generate/construct sql-statements. As a rookie, you are used to write a lot of sprintf`s every time i needed a statement (i.e.for DBI)....


Platforms: *nix

DL/SQL is declarative, turing-complete programming language based on top of SQL database. The main idea is to store both program and data in one SQL table and make all the computations in it. The current version of interpreter written in PHP contains quasi-lazy evaluation and simple caching....


Platforms: *nix

Inline::Select contains dynamic selection of ILSM for a package. SYNOPSIS use Inline::Select::Register ( PACKAGE => Calc, Inline => [ Perl => sub {require t/Calc.pm} ] ) ; use Inline::Select::Register ( PACKAGE => Calc, Inline => [ CPP => t/Calc.cpp ] ) ; use Inline::Select::Register...


Platforms: *nix

mrtg-select allows the flexible display of MRTG graphs, chosen by keyword and time span. I use MRTG to graph all kinds of stuff, and looking at those graphs on the same page helps me detect correlations. ("Say, Professor -- that spike in CPU temperature came right when the Rapture Index hit a...


Platforms: *nix

sql++ is an easily configurable, feature-rich, portable command-line SQL tool. It can be used with many different databases and in place of other commandline tools such as MySQLs mysql-client, Microsoft SQL, PostgreSQLs psql, and Oracles sqlplus. sql++ project has features such as multiple...


Platforms: *nix

SQL Uniform is a database client with a graphical user interface (GUI). The project is a helper application to relational databases of various types regarding query, maintenance, data comparison, export (convert), and import. It supports any kind of database and database servers to which there...


Platforms: *nix

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


Platforms: *nix

dbForge SQL Complete Express is a free add-in for SQL Server Management Studio and Visual Studio. It offers powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense. Besides the extension of the List Members, Complete Word and Parameter Info...


Platforms: Windows

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


Platforms: Windows

Decrypts SQL stored procedures, functions, triggers, and views on SQL Server. If you have encrypted an object definition in your database(s) by specifying WITH ENCRYPTION option, and by some reason you cannot restore it's original T-SQL script, the SQL Decryptor will easily do it for you...


Platforms: Windows

Devart is a software development company with more than 11 years of experience on the software market and over 20 thousands devoted users. We are glad to present you a new decryption tool dbForge SQL Decryptor which is reliable and easy to use. dbForge SQL Decryptor is a database...


Platforms: Windows

Microsoft(R) SQL Server is a complex system with many different types of managed objects and requires daily changes to servers settings, security roles, databases, etc. All administrative activities require tracking of changes especially in environments managed by multiple DBAs and server...


Platforms: Windows, Windows 7, Windows Server

An ideal solution for administration and development which lets you create, edit databases, run SQL queries and connect to remote SQL Server in an easier way. It features an intuitive GUI and offers powerful visual tools such as Query Editor with syntax highlight capability, SQL Preview, SQL...


Platforms: Mac

Publish Table to Word for SQL Server is a very effective application, with a wizard interface, that will help users create copies of table's data as Microsoft Word documents. Publish table to Word supports all modern versions of Microsoft SQL Server. Limited support for 6.0 and 6.5 versions is...


Platforms: Windows

This tool converts SQL Profiler 2005 trace file (.trc) to Excel file (.xls). Trace Converter for SQL 2005 is designed to perform the conversions via command-line. Convert SQL Profiler trace file (.trc) to Excel 2003-2007 file format (.xls) easily with the help of Trace Converter for SQL 2005!


Platforms: Windows, Windows Vista, 7, 7x64