sql statements

White Papers

Tuning SQL Statements on Microsoft SQL Server 2000

June 1, 2005 12:00am PDT

This paper covers the basic techniques used to tune SELECT statements on Microsoft's SQL Server 2000 relational database management system. The paper discusses the techniques available using...

Provided by: Quest Software

White Papers

Proposing SQL Statement Coverage Metrics

May 18, 2008 12:00am PDT

An increasing number of cyber attacks are occurring at the application layer when attackers use malicious input. These input validation vulnerabilities can be exploited by (among others) SQL...

Provided by: Association for Computing Machinery

White Papers

On Automated Prepared Statement Generation to Remove SQL Injection Vulnerabilities

September 27, 2008 12:00am PDT

Since 2002, over 10% of total cyber vulnerabilities were SQL injection vulnerabilities (SQLIVs). This paper presents an algorithm of prepared statement replacement for removing SQLIVs by replacing...

Provided by: Reed Elsevier

Book Chapters

Query for data with the SELECT statement in MySQL

February 7, 2006 12:00am PST

This sample chapter, taken from MySQL 5.0 Certification Study Guide, discusses how to use the SELECT statement in MySQL to retrieve information from database tables. Learn how to use the SELECT...

Provided by: Sams Publishing

Blog Posts

Execute SQL statements in Integration Services

October 15, 2007 6:36am PDT

Executing SQL statements are one of the easiest and most common tasks that occur in SQL Server 2005 Integration Services (SSIS). This tutorial walks you through the process of adding SQL...

1

Software

General SQL Parser .NET version 2.1.9 (Windows)

December 27, 2011 12:00am PST

General SQL Parser is developed to help people who want to check syntax of SQL statements, pretty print out SQL statements, and parse SQL statements into parse tree in their program. It can also...

Provided by: Gudu Software

Downloads

General SQL Parser .NET version 2.1.9 (Windows)

December 27, 2011 12:00am PST

General SQL Parser is developed to help people who want to check syntax of SQL statements, pretty print out SQL statements, and parse SQL statements into parse tree in their program. It can also...

Provided by: Gudu Software

Blog Posts

Generate dynamic SQL statements in SQL Server

March 10, 2008 1:59pm PDT

When you need to solve a tricky database problem, the ability to generate SQL statements is a powerful tool -- although you must be careful when using it. Tim Chapman explores how you can use this...

7 Latest comment by Tony Hopkinson

Articles

Get detailed error handling information in SQL Server 2005

June 19, 2006 7:00am PDT

In SQL Server 2005, you no longer need to check the @@ERROR variable after every statement executed, as was the case in SQL Server 2000. Discover the luxury of using SQL Server 2005's TRY…CATCH...

Software

SQL Elite 0723 Demo Free Version (Windows)

July 23, 2010 12:00am PDT

SQL Elite was designed to allow fast generation of SQL Statements and Stored Procedures and completely eliminate typographical and syntax errors. Entire statements and procedures can be generated...

Provided by: Software-Dynamics

Downloads

SQL Elite 0723 Demo Free Version (Windows)

July 23, 2010 12:00am PDT

SQL Elite was designed to allow fast generation of SQL Statements and Stored Procedures and completely eliminate typographical and syntax errors. Entire statements and procedures can be generated...

Provided by: Software-Dynamics

Articles

Protect databases from SQL injection attacks

July 21, 2005 7:00am PDT

In a SQL injection, attackers attempt to damage your database by a "injecting" a SQL statement into another statement. Learn simple methods for preventing injections from penetrating your system.

Software

SwisSQL - DB2 to SQL Server Edition 1.2 (Windows)

November 23, 2010 12:00am PST

SwisSQL-DB2 to SQL Server Migration Tool helps you migrate IBM DB2 SQL Procedures, Functions and Triggers to SQL Server Transact-SQL. Microsoft SQL Server is now considered more of an enterprise...

Provided by: Zoho

Downloads

SwisSQL - DB2 to SQL Server Edition 1.2 (Windows)

November 23, 2010 12:00am PST

SwisSQL-DB2 to SQL Server Migration Tool helps you migrate IBM DB2 SQL Procedures, Functions and Triggers to SQL Server Transact-SQL. Microsoft SQL Server is now considered more of an enterprise...

Provided by: Zoho

Blog Posts

How do I... Use PHP with PostgreSQL?

August 3, 2007 12:03pm PDT

PHP's PostgreSQL extension provides a comprehensive API for developers to interact with a PostgreSQL RDBMS. In addition to basic SQL operations, the API also supports prepared statements,...

2 Latest comment by troylb

Software

SqlFree 3.5 (Windows)

September 10, 2002 12:00am PDT

sqlFree gives you the opportunity to build your SQL-statements visually as known from MS-Access. Parsing statements and visualizing them also is supported. Additionally the statements can be sent...

Provided by: IndependenceSoft!

Downloads

SqlFree 3.5 (Windows)

September 10, 2002 12:00am PDT

sqlFree gives you the opportunity to build your SQL-statements visually as known from MS-Access. Parsing statements and visualizing them also is supported. Additionally the statements can be sent...

Provided by: IndependenceSoft!

Software

Advanced Database Query Automaton 1.4 (Windows)

May 14, 2011 12:00am PDT

Advanced Database Query Automaton is a scriptable relational database client utility that allows execution of SQL (Structured Query Language) statements on Microsoft SQL Server and MySQL...

Provided by: Advanced Reliable Software

Downloads

Advanced Database Query Automaton 1.4 (Windows)

May 14, 2011 12:00am PDT

Advanced Database Query Automaton is a scriptable relational database client utility that allows execution of SQL (Structured Query Language) statements on Microsoft SQL Server and MySQL...

Provided by: Advanced Reliable Software

Software

AdeptSQL Workshop 1.01 (Windows)

March 9, 2002 12:00am PST

Adept SQL Workshop supports all phases of database schema development from writing (or generating from an existing database) a set of SQL sources to the debugging and to the subsequent database...

Provided by: Adept SQL Tools