Select Case Sql

EMS Data Comparer for SQL Server is a powerful and easy-to-use utility for data comparison and synchronization. You can view all the differences in compared tables and execute an automatically generated script to eliminate these differences. Flexible customization of the comparison and...

DBConvert for Excel & MS SQL is a reliable bi-directional database migration tool which allows you to convert data from: - MS Excel to MS SQL - MS Excel to MS SQL Dump - MS Excel to MS Excel - MS SQL to MS Excel - MS SQL to MS SQL - MS SQL to MS SQL Dump You can convert your...

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

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


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

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

dbForge Query Builder for SQL Server is a tool for quick creation of SQL queries and extended data management. It allows you to effortlessly create any complex queries to SQL Server databases. The main component of Query Builder is a visual diagram where you can "draw" your query. Adding tables,...


Platforms: Windows

Advanced SQL To PDF Table Converter is a relational database client utility that allows execution of SQL (Structured Query Language) statements on Microsoft SQL Server, MySQL and Oracle databases. Resultsets returned by select queries are automatically persisted as PDF files to a directory of...


Platforms: Windows

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


Platforms: All

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


Platforms: Windows

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

Publish Query to Word for SQL Server Standard will help you setup a connection to a database and export a query to a Word document. The application features two methods to connect with the datrabase: with predefined data source or using direct connection to server or database file. In the first...


Platforms: Windows, XP, 2003, Windows Vista, 2008, 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

Clone Table for SQL Server Professional is an application that enables you to create copy of selected table (schema and data) to same database. This operation is required in the next case: you need to verify some idea against live (not generated) data. However, you can't modify an existing...


Platforms: Windows, XP, 2003, Windows Vista, 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

Publish Table to HTML for MS SQL Server is an application that enables users to create copies of selected data in tables and save it in HTML format. This database export tool supports all modern versions of Microsoft SQL Server First, you have to setup your connection to database. There are two...


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