BOL has become harder to use in this last edition. A problem is that the new functions and enhancements are not clearly marked to define which version of SQL Server will allow its use.
A simple header at the beginning of each content page (like Knowledge Base) would show quickly which features will work with which version.
For example, we just picked up a project in SQL 6.5. One of my developers came in looking puzzled because his SET statement didn't work. I changed it to the older SELECT and his T-SQL code worked.
Yesterday I had a discussion with a new developer about @@Identity. The first question I asked was which version of SQL Server. An hour later he came to me and asked why IDENT_CURRENT didn't work for him.
MCT, MCDBA, MCSD
Quand on parle du loup, on en voit la queue