Good article.

I've become very fond or ROW_NUMBER() lately, it's an efficient way of doing what I need to do for a large report.

I use something like this

-- Replace INSERT_TABLE_HERE with the table name you want information about.

-- This query will give you the Column names, the respective datatype and

-- position in...