title: What are the new t-sql features sql server 2005?
body: <p>Where do I find a complete list of new T-SQL features in sql server 2005 comparing with 2000? </p>
  
  <p>A few ones that I know:
  Pivot, Output, Try..Catch. Anything else? Thank you.</p>