Articles about sql


HTML5 SQL DB vs localStorage

databases web I've now built some mobile ...

Use varchar(max) instead of text in SQL Server

databases As you may know on SQL Server ...

Creating a Derby Datasource with ColdFusion Admin API

coldfusion databases I am working on some example ...

Cheat Sheet for SQL Server

databases I have been writing a lot of ...

DateFormat for SQL Server

databases Have you ever tried to find a ...

Top 10 Reserved SQL Keywords

databases You may know that I created a ...

SQL Case Statement

databases Here's a simple example of a ...

Dear SQL Server Enterprise Manager Developer

databases Please add a button to make a ...

Mastering CFQUERYPARAM

coldfusion If you haven't been using the ...

Getting ColdFusion SQL Statements from SQL Server Trace

coldfusion databases Running a SQL Trace in the ...

Try Catch for SQLServer T-SQL

databases Error handling in SQL Server ...

INFORMATION_SCHEMA Support in MySQL, PostgreSQL

databases I've known about the ...

Use Char instead of Varchar to Store UUID's

databases I know a lot of developers ...

Calculating Distance in Miles from Latitude and Longitude

databases The amount of data out there ...

Backwards LIKE Statements

databases Sometimes you need to think ...

Toggle a Bit with SQL

databases web I am working on a management ...

Naming Tables

misc I am working on a project ...

Sphinx - Open Source SQL Full Text Search Engine

databases I came across Sphinx today ...

Updated SQL Reserved Words Checker

databases I just updated my SQL ...

MySQL FULLTEXT Indexing and Searching

databases MySQL has supported FULLTEXT ...

SQL to Select a random row from a database table

databases There are lots of ways to ...

Cheat Sheet for PostgreSQL

databases When I created my list of ...

Temporary Stored Procedures on SQL Server

databases I posted about doing fast ...

Cheat Sheet Roundup - Over 30 Cheatsheets for developers

apple coldfusion databases java linux web Lets face it, unless you have ...

Faster Inserts with PostgreSQL

databases As I mentioned yesterday, I'm ...

Multiple Dynamic Inserts with SQL

databases If you have ever had to do ...

LIMIT and OFFSET SQL Pagination

databases Both MySQL and PostgreSQL ...

Insert Delayed with MySQL

databases I just discovered that MySQL ...

Performance of database tag schemas

databases Philipp Keller has done some ...

Multiple Inserts with MySQL

databases Andy Jarrett posted this ...

SQL: Distinct values from two tables

databases Today must be database day ...

Related Posts

coldfusion databases As you may have noticed I ...

SQL Reserved Key Words Checker Tool

databases I just whipped together a ...

Finding Duplicates with SQL

databases Here's a handy query for ...

Client Variables unnecessary overhead?

coldfusion databases I was curious to know how ...

Top 3 differences between PostgreSQL and MS SQL

databases I recently switched a ...

Returning TOP N Records

databases Returning only the first N ...

Pete has written about sql a total of 37 times.

Foundeo Inc.