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.

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.

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 ...

Even though the SQL value is a string, SQL Server executes the string as if it is SQL code. Transact SQL, or T-SQL, provides you with the language to create the dynamic code.