|  | | Tips on Writing Portable SQL Code | | | Description: Tips on Writing Portable SQL Code | | 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:: Tips on Writing Portable SQL Code | | Title: | Tips on Writing Portable SQL Code | | Author: | John Lim | | Price / Cost: | Free | | Last Updated: | Thu Sep 16 2004 | | Home Page: | Click to Visit | | Web site Language: | English | | Current Rating: | 0.00 | | Total Hits #: | 50 | | Listings ID #: | 19164 | | Reviews for Tips on Writing Portable SQL Code | |  |
|