Dynamic SQL

Temporary objects

The SQL of Scrabble and Rapping

In which Phil decides to use a table consisting of all the common words in English to explore ways of cheating at Scrabble and writing doggerel using SQL Server. He then issues a SQL challenge.

Using T-SQL to Transform XML Data to a Relational Format

More and more data is being stored or transmitted in an XML format. New author Nasir Mirza brings us an article that examines how to transform a number of XML structures into different relational formats for storage in SQL Server.

Implementing Most Recently Used Lookups

This script will adapt ordering of look-up lists by foreign key usage.

Riddle Me This

Store Procedure Output in a Table

This script show a demonstration of how to interst tore Procedure Output in a Table.

Back to front

Temp Tables

Find weak login passwords in your server

Use this script to search for SQL Server logins who use weak password