O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL CLR Types

The last SQL CLR feature for us to explore is user-defined types (UDTs). This feature is perhaps the most interesting, yet also the most controversial. It’s interesting because, technically, it allows for storage of objects in the database. It’s controversial because it’s prone to abuse. SQL CLR types were not implemented to allow developers to create object-oriented databases; they were created to allow multivalue or multibehavior data types to be stored, retrieved, and easily manipulated.

SQL CLR types have certain indexing limitations, and their entire value must be updated when any of their individual property/field values is updated.

More Info

More information about SQL CLR UDTs is available in the MSDN article "Using CLR Integration ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required