This next tip works as long you have SSMS 2008 against any instance. You can drag the table name, column name or even the column folder to write a query. So if I want to write a select against a table and especially when I don’t have intellisense, I can just drag and drop.
If I drag the Columns folders I get the a comma-separated list of the columns. You can also drag several other items such as individual table and column names.