User-defined Stored Procedures

As you may infer from the name, user-defined stored procedures are simply groups of Transact-SQL statements assembled by administrators or developers and compiled into a single execution plan. The design of this type of stored procedure is the primary focus of this book.