SQL Server Symbol Currency Hexadecimal

SQL Server 2000  http://msdn.microsoft.com/en-us/library/Aa223952

http://msdn.microsoft.com/en-us/library/aa902644(SQL.80).aspx

http://msdn.microsoft.com/en-us/library/aa902644(SQL.80).aspx#intlfeaturesinsqlserver2000_usingadpformat

SQL Server 2005 http://msdn.microsoft.com/zh-cn/library/ms188688(v=sql.90).aspx

SQL Server 2008 R2 http://msdn.microsoft.com/en-us/library/ms190303.aspx

http://msdn.microsoft.com/en-us/library/ms188688.aspx

---Symbol Currency Hexadecimal
--Geovin Du　涂聚文 缔友计算机信息技术有限公司
declare @dec decimal
set @dec=255.81
select convert(VARCHAR,nchar(0x24)+cast(@dec as varchar)) as '金额(美元)'
--货币符号
SELECT CONVERT(VARCHAR(400), N'Some Unicode characters: '
   +'Dollar'+ NCHAR(0x24)+'Pound'+NCHAR(0xA3)+'Currency'+NCHAR(0xA4)+'Yen'+NCHAR(0xA5)+'Euro-currency'+NCHAR(0x20AC));
GO