After updating my SQL Server 2005 to SP1 I tried to find out what version was running. So I open a new query window and type:
SELECT @@VERSION
and get as result:
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) ...
I'm not so good at deciphering these version numbers so I wanted to look them up. Only then I found out that there were some changes to Transact-SQL.