Ocassionally, I see a question in the MSDN Forums where someone wants to know how to retrieve a list of column information for a table using only T-SQL.
Although there are several ways in which to approach this, I like the following method.
TABLE_NAME = 'Product'
Do you have a different way of doing this that you'd like to share? If so, feel free to leave a comment, sharing your way and why you like it.