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

?

1 2 3 4 5 6 7 8 9

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