Trim Trailing Blanks in SQL Queries

Reformats the text output of queries to trim trailing blanks in wide varchar columns for easy copy-and-paste.

Updating a View

Generate INSERT for table with IDENTITY column

Generate a "INSERT INTO...SELECT FROM" script for a table with an identity column.

TOP Updates

View Column Resolving Issue in Sub-Query

Views are handy constructs for abstracting security and simplfying queries, but they can have unexpected results sometimes. Longtime DBA Peter He takes a look at subquery issues in views.

Don't forget the Title

When using the output for generated code don't forget the title

Truncate Locks

Modify columns' name in batches

Modify columns' name in batches.

GETANSINULL

Bring Array Mapping Capabilities to SQL

Simplify your SQL tasks by giving your queries and stored procedures the ability to iterate over arrays of table names or values.