Articles about sql

2022

• Order by NULL Values in MySQL, Postgresql and SQL Server

2011

• HTML5 SQL DB vs localStorage

2009

• Use varchar(max) instead of text in SQL Server
• Creating a Derby Datasource with ColdFusion Admin API
• Cheat Sheet for SQL Server
• Alter Table Add Column on SQL Server

2008

• DateFormat for SQL Server
• Top 10 Reserved SQL Keywords
• SQL Case Statement
• Dear SQL Server Enterprise Manager Developer
• Mastering CFQUERYPARAM
• Getting ColdFusion SQL Statements from SQL Server Trace
• Try Catch for SQLServer T-SQL
• INFORMATION_SCHEMA Support in MySQL, PostgreSQL

2007

• Use Char instead of Varchar to Store UUID's
• Calculating Distance in Miles from Latitude and Longitude
• Backwards LIKE Statements
• Toggle a Bit with SQL

2006

• Naming Tables
• SELECT NULL Rows with MySQL
• Sphinx - Open Source SQL Full Text Search Engine
• Updated SQL Reserved Words Checker

2005

• MySQL FULLTEXT Indexing and Searching
• SQL to Select a random row from a database table
• Cheat Sheet for PostgreSQL
• Temporary Stored Procedures on SQL Server
• Cheat Sheet Roundup - Over 30 Cheatsheets for developers
• Faster Inserts with PostgreSQL
• Multiple Dynamic Inserts with SQL
• SQL Pagination with LIMIT and OFFSET
• Insert Delayed with MySQL
• Performance of database tag schemas
• Multiple Inserts with MySQL
• SQL: Distinct values from two tables
• Related Posts
• SQL Reserved Key Words Checker Tool

2004

• Finding Duplicates with SQL

2003

• Client Variables unnecessary overhead?
• Top 3 differences between PostgreSQL and MS SQL
• Returning TOP N Records

Pete has written about sql a total of 40 times. In articles about sql, Pete also often writes about: mysql, sqlserver, databases, postgresql, and microsoft.