Column_Gitter

Total article views: 146 | Views in the last 30 days: 2

 Rate this |   Join the discussion |  Briefcase

This little utility comes in handy if you do a lot of SQL coding. Given a table name, it'll return four results: The names of the columns, the names with their datatypes, the list of columns with each one set to an identically-named variable, and a list of variables with the same names as the columns.

If you run it as a script, just type in the name of the table on the second line. I prefer to make this a stored procedure, and pass the table name as a parameter. If you do this, then you can open a Query Analyzer window, type

Column_Gitter 'myTableName'

and hit F5, in less time than it takes to browse the table properties.

No more column-name typing! I hope this helps you.

Rick

Total article views: 146 | Views in the last 30 days: 2