Creating User Defined Types in SQL Server 2005
User Defined Types in SQL Server 2005 is a great new feature that allows you to extend the type system of the database. By authoring your new data type as .NET assemblies according to a specific contract, you can register these assemblies in the database and then use the types in them. This new capability opens up a lot of interesting possibilities in the database to store information. This article provides an overview of how to create, define and use user defined types using an example. We also see how to consume the user defined type from a client application like ADO.NET. The article is available at:
Creating User Defined Types. Have fun!