December 2011
5 posts
Google’s 3 Top Executives Have 8 Private Jets http://ping.fm/i42I2
CodeSOD: The Andy Pattern http://ping.fm/mrR0D
Sorting It All Out…
The past few months have been a time of craziness and chaos professionally, with a fair amount of frustration but also tremendous learning. There are so many light bulbs going off in this rapid-fire brain of mine that I am fighting the urge to chase each one of them, which is why I am trying to step back and put some perspective on all of these things—ideas, inspirations and a generally ...
T-SQL Table Column Lookup Query
Here is a quick snippet of T-SQL that I use to find the column names in a given table in SQL Server: SELECT ORDINAL_POSITION ,COLUMN_NAME ,DATA_TYPE ,CHARACTER_MAXIMUM_LENGTH ,IS_NULLABLE ,COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ‘table_name’ ORDER BY ORDINAL_POSITION ASC; Just replace ‘table_name’ with the name of the table you want to get information about. This is...