[Description] Database objects, such as triggers, stored procedures, and user-defined types, can be written in .NET Framework languages, such as Microsoft Visual C#. Development and debugging is integrated into the Microsoft Visual Studio environment allowing developers to use the same tools to develop database objects as they use to develop .NET Framework components and services. The Transact-SQL language has been extended with features such as improved error handling and support for recursive queries. [Topic] 
Database Engine Programmability Enhancements