Skip Navigation

Everything tagged with "sql"

This A4 reference lists the various functions available in Microsoft SQL Server, and demonstrates the creation of stored procedures, triggers and functions.

Read the rest of this post »

A quick reference guide for MySQL, including functions (both in MySQL and PHP), data types, and sample queries. Available in PDF and PNG formats.

Read the rest of this post »

SQL Server, PHP and Truncating Text


22 December 2004   |   Comments   |   server, text, mssql, php, sql

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.

Read the rest of this post »