© Dmitri Korotkevitch 2016

Dmitri Korotkevitch, Pro SQL Server Internals, 10.1007/978-1-4842-1964-5_15

15. CLR Types

Dmitri Korotkevitch

(1)Tampa, Florida, USA

CLR types make up another area of Common Language Runtime (CLR) integration with SQL Server. User-defined CLR types allow us to expand the standard type library by developing .Net classes and registering them in the database. Standard CLR types, such as Geometry, Geography, and HierarchyId, provide built-in support for spatial and hierarchical data. You will learn about both user-defined and system CLR types in this chapter.

User-Defined CLR Types

SQL Server has supported user-defined types (UDT) for years. Historically, T-SQL-based user-defined types were used to enforce type consistency. ...

Get Pro SQL Server Internals, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.