Categories


Tips on Writing Portable SQL Code

Raiting 0.00

Description

This article gives the details about tips on writing portable SQL code with PHP and how the ADODB database abstration library offers some solutions for this. The author deals in the sections like SELECT statement, Selects:Fetch Modes, Selects: Counting Records, Selects: Locking, Selects: Outer Joins, inserts, binding, ADODB and DDL and Tuning for easy understanding of this tutorial. The author finally concludes that the best way to ensure that you have portable SQL is to have your data tables designed using sound principles and understand how joins and indexes work and how they are used to tune performance with some sample codes and reference sites.

Information
Title: Tips on Writing Portable SQL Code
Author: admin0011
Price / Cost: Free
Last Updated: 2004-09-16
URL: Click to Visit
Web site Language: English
Total Votes: 11
Current Rating: 0.00
Total Hits #: 84
Listings ID #: 19164