Sql server® 2012 t-sql fundamentals

Routines

Routines are programmable objects that encapsulate code to calculate a result or to execute activity. 

SQL Server supports three types of routines: user-defined functions, stored procedures, and triggers.

SQL Server allows you to choose whether to develop a routine with T-SQL or with Microsoft .NET 

code based on the CLR integration in the product. Because this book’s focus is T-SQL, the examples 

here use T-SQL. Generally speaking, when the task at hand mainly involves data manipulation, T-SQL 

is usually a better choice. When the task is more about iterative logic, string manipulation, or compu-

tationally intensive operations, .NET code is usually a better choice.