• Here is way to copy data between tables with the same structure/layout:

Trucate table destination_tablename

Insert Into destination_tablename
Select *  from source_tablename

• T-SQL to count columns in a table:

SELECT count(column_name) from Information_schema.columns where table_name = 'Table_Name'

• Here is an excellent post by John Robbins on tools used at Wintellect:
  
  http://www.wintellect.com/CS/blogs/jrobbins/archive/2009/12/01/tools-we-use.aspx