IN THIS CHAPTER
Even though SQL Server 2005 supports writing stored procedure, functions, and triggers using .NET languages such as C#, Transact-SQL (T-SQL) will still be the primary language that database developers and DBAs will use to write scripts and procedural code. SQLCLR integration is provided as a supplement to help in writing business logic or complex computational tasks, or to perform functions that cannot easily be done by using T-SQL. SQLCLR is not a replacement for T-SQL. In fact, SQL Server 2005 introduces several new enhancements to the T-SQL language, as you will learn in this chapter.
The first section in this chapter compares .NET integration support with T-SQL, and the rest of the chapter details the new and improved T-SQL features.