Appendix A. Companion to CLR Routines

This book has common language runtime (CLR) code scattered in multiple chapters. CLR routine code for functions, stored procedures, and triggers appears in four chapters (Chapter 2, Chapter 3, Chapter 4, and Chapter 8). For your convenience and for reference purposes, I centralized all routine code from the four chapters in this appendix.

CLR user-defined types (UDTs) are covered in Chapter 11. The CLR code coverage there is already centralized and independent, so I didn’t see any value in providing it in this appendix as well. Note that CLR user-defined aggregates (UDAs) are discussed in the prequel to this book, T-SQL Querying.

You will also be provided with step-by-step instructions on how to develop and ...

Get Inside Microsoft® SQL Server® 2008: T-SQL Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.