In SQL Server 2005 it is possible to create stored procedures in any (.NET) programming language that supports Common Language Runtime (CLR). Usage of such procedures is similar to usage of Transact-SQL user-defined stored procedures. They can return tabular results, integer return value, and output parameters, modify data and some database objects. We will explore them in details in Chapters 11 and 13.