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. ...
