Tag Archives: SQL

(MySQL) Age in Years for Given Birthdate

Given a birthdate in @dob, here are two simple formulae for age in years : (the second formulae is for age in years to two decimal places, ignoring day of month)

Posted in Uncategorized | Also tagged , , , , | Leave a comment

(SQL) Rename Microsoft SQL Server Database Schema

Generates a set of queries to run which will change the schema for all items within a specified schema and change them to another.

Posted in Uncategorized | Also tagged , , , | Leave a comment

(PHP) Anti-SQL Injection Function

Posted in PHP | Also tagged , , | Leave a comment