What is your favorite "I didn't know that"...

Where to start?

Drag and drop columns from Object Explorer in Query Analyzer?

Declaring column names in derived tables in a way later used in CTE?

FROM (

select 1, 2

) DT (ID, Value)

Running totals trick with UPDATE using accumulating variables?

I'm sure I'll remember more when I'm offline... 😉