SQL Server supports atomic blocks only at the top-level of natively compiled stored procedures. Every natively compiled stored procedure contains exactly one block of Transact-SQL statements.

In SQL Server 2000, though, the QA has metamorphosed into a much more powerful tool for the Transact-SQL developer — it’s truly a programmer’s editor now.

Maybe it's not the sexiest programming language, but SQL continues to be relevant. In fact, TIOBE Software, which publishes a TIOBE Programming Community Index gauging the popularity of programming ...