20 July 2007 | 70 comments | cheat, cheatsheet, development, mssql, mysql, programming, reference, sql, sql-server, sqlserver, toread
This A4 reference lists the various functions available in Microsoft SQL Server, and demonstrates the creation of stored procedures, triggers and functions.
24 May 2005 | 145 comments | cheatsheet, webdev, development, mysql, reference, programming, web, php, database, guide, sql, webdesign, howto
A quick reference guide for MySQL, including functions (both in MySQL and PHP), data types, and sample queries. Available in PDF and PNG formats.
PHP and SQL Server are a powerful combination, however sometimes data stored in a text type column is truncated for no apparent reason after 4096 characters. Here's how to fix the problem.