SUBSTRING

int & char

10+ tips for working smarter with SQL

The sharper your SQL skills become, the more robust and error-free your solutions will be. Here are a dozen practical tips to get you started

Limit Groups by Number Using Transact-SQL or MS Access

You can easily limit or group a recordset, but doing both to the same recordset takes a bit of hand coding. Find out how both SQL Server and MS Access can handle the task.

Inequality!

Generating Insert Statements

This article from new author Oleg Netchaev describes the cursor-less script used to generate insert statements. This allows you to efficiently and easily add data generation statements to your project deployments.

view, index and schemabinding!

CRUD generator

Script to generate create, read, update, and delete scripts for a table.

decimal

The Automated DBA: Batch Database File Grower - SQL2000 ReportOnly Ver

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.