CLR types is another area of Common Language Runtime integration in SQL Server. User-defined CLR types allow us to expand the standard type library by developing .Net classes and registering them as user-defined types in the database. Standard CLR types, such as Geometry, Geography, and HierarchyId, provide built-in support for spatial and hierarchical data.
In this chapter, you will learn about both user-defined and system CLR types.
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. For example, when you ...