I’m reading up a little on SQL Server 2005 and found a couple of deprecated features worth noting.
- TIMESTAMP – use rowversion instead for theese operations
- SET ROWCOUNT – wich I often used to compensate for the lameness of TOP. No more, TOP has been doing steroids between versions and is now more able.
- T-SQL joins – No more ”WHERE Customers.CustomerID *= Orders.CustomerID” in future versions of SQL Server only the ANSI syntax will be supported (LEFT OUTER JOIN Orders ON Customer.CustomerID = Orders.CustomerID). I’ve always used ANSI syntax but I’ve seen a lot of T-SQL join syntax in the systems of my clients.
Just to clarify, theese features are deprecated not removed or unsupported in the current version.