VS 2010 Premium or Ultimate has a refactor feature (http://msdn.microsoft.com/en-us/library/dd193416.aspx) for SQL that allows the expansion of wildcards such that:

TableA
{
Col1 int
Col2 int
Col3 int
}

select * from TableA could be refactored into:

select [t0].Col1, [t0].Col2, [t0].Col3 from TableA [t0]

Much of the time I will start out writing the select * from TableA statement and later need to go back and define out the columns.