Archive for the 'SQL Server' Category

 Sql server 2005 includes new Transact-SQL (T-SQL) functionality. The enhancements span the range from an alternative mechanism for transaction isolation to declarative support for hierarchical queries. And statement-level recompilation even improves existing T-SQL applications that were written before 2005.
Improvements to Transact-SQL
Microsoft has continually improved the Transact SQL language and the infrastructure of SQL Server itself. [...]