One of the most prominent enhancements to SQL Server 2005 was the introduction of the integrated SQL Common Language Runtime (SQL CLR). SQL CLR is a SQL Server-specific version of the .NET Common Language Runtime, which allows you to run .NET managed code in the database. SQL CLR programming is a broad subject that could easily fill an entire book, and in fact it does—Pro SQL Server 2005 Assembliesit, by Robin Dewson and Julian Skinner (Apress, 2005), is an excellent resource for in-depth coverage of SQL CLR programming. In this chapter, I’ll discuss the methods used to extend SQL Server functionality in the past, and explain the basics of the SQL CLR programming model and the improvements made to SQL CLR in SQL Server 2008.
- Complex Number
- Data Type
- Regular Expression
- Input String
- Visual Studio
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
This is a preview of subscription content, access via your institution.
Tax calculation will be finalised at checkout
Purchases are for personal use onlyLearn about institutional subscriptions
Unable to display preview. Download preview PDF.
© 2008 Michael Coles
About this chapter
Cite this chapter
(2008). SQL CLR Programming. In: Pro T-SQL 2008 Programmer’s Guide. Apress. https://doi.org/10.1007/978-1-4302-1002-3_14
Publisher Name: Apress
Print ISBN: 978-1-4302-1001-6
Online ISBN: 978-1-4302-1002-3