Auto Generating a Data Dictionary – Part 1

Wouldn’t it be great to be able to generate a data dictionary for a SQL 2008 Database? You can, with this handy slab.

 

TSQL Function that Tables a Delimited String

Use today’s slab to turn a delimited string into table variable.

 

Import to SQL Server from Excel

Importing into SQL Server from Excel isn’t as trivial as it sounds, but this slab codes straight outta production code.

 

SQL Server Title Case Function

Unfortunately, SQL Server doesn’t have a built in Title Case function.  Roll your own with this slab.

 

Make SQL Server Connection Strings Changable at Runtime

Strongly typed datasets do not allow you to alter connection strings at runtime by default.  These directions show how to change that behavior.

 

Export SQL Table to Excel

This slab walks through using VB.Net to export a SQL table to Excel.

 

Update one Table from Another in a Transaction

This SQL slab shows how to update one SQL table from another, wrapped up in a nice, juicy transaction.

 

Add a Unique Number Column to an Existing Table

Ever wanted to add an autonumber column to a table? This slab show you how you do it.

 

Delete Duplicate Rows in a Table

Delete all but one duplicate rows in a table: http://www.4guysfromrolla.com/webtech/sqlguru/q051200-2.shtml

 

Add, Drop, Rename Columns

A cheat sheet to working with columns.