A Hex on Your Database

BETWEEN

Know your UNION(s), NULL(s), COUNT(s) ?

How do I ... reject alpha characters in a SQL Server character column?

Enforcing your data's integrity is probably the single most important issue you face when designing a database. Validating user input is one way of keeping bad data from making its way into your analyses and reports.

Identity Columns

When Nigel Rivett takes us on a tour of the apparently innocuous subject of Identity Columns in TSQL, even the seasoned programmer is due for one or two surprises.

SQL 2005 Restore Script Generator

This script will generate a restore statement with supporting MOVE operations to a new directory structure.

Find for SQL Objects, Entities or Text

Procedure to find any object such as table/stored procedure by its name, or find for ant text inside stored procedures, functions.

usp_addcolumns

This is a stored procedure to add a columns to multiple tables, if column doesn't exist

CASTing

Finding Available Keys When Merging Two Tables

Find available keys when merging two tables with duplicate keys.