Thursday, August 1, 2013

t-sql list of currencies of the World

The following script (http://www.xsql.com/download/Scripts/Currencies.zip ) creates a "currencies" table and populates it with the complete ISO 4217 list of international currency codes (edition ISO 4217:2008).

Note that the first two letters of the [AlphabeticCode] in the Currencies table correspond to the [ISO_ALPHA2] code on the Countries table which you can get from http://blog.xsql.com/2012/10/t-sql-list-of-countries.html, whereas the [NumericCode] in the Currencies table is in most cases the same as the [NumericalCode] in the Countries table.
Please not that the list is current as of the date of this post.

If you have any questions or comments please post them here.

1 comment: