"Currency" User Defined Type

Description:

This user defined type represents a specific quantity of money in a specific culture's monetary system. For example, 12 US Dollars or 15 Euros. The script below exposes the Currency  managed class in the AdventureWorks CLR sample as the Currency user defined type in the Adventure Works Cycles database. Instances of this user defined type are created by the ConvertCurrency  user defined function which is based on the managed method ConvertCurrency in the same assembly.

Definition:
CREATE TYPE Currency EXTERNAL NAME [CurrencyType].[Microsoft.Samples.SqlServer.Currency];