SQL FORMAT Function to Format Currency with Culture
In this article, you will learn how to use currency format in sql server?. When working with currency formats, there are many different formats used around the world. For example, in the USA we use the $ for the currency symbol and a decimal point as a separator. Whereas in Latin America, we use the decimal point instead of a comma as the separator. Is there a simple way to handle the format of different currencies in Microsoft SQL Server?. There are above hundreds of cultures already defined for SQL databases and the below output shows how the FORMAT function can be used and what the output looks like.
CREATE TABLE #temp ([language] nvarchar(100), [langcode] nvarchar(20))
INSERT INTO #temp
VALUES('Afrikaans - South Africa','af-ZA')
,('Albanian - Albania','sq-AL')
,('Alsatian - France','gsw-FR')
,('Amharic - Ethiopia','am-ET')
,('Arabic - Algeria','ar-DZ')
,('Arabic - Bahrain','ar-BH')
,('Arabic - Egypt','ar-EG')
,('Arabic - Iraq','ar-IQ')
,('Arabic - Jordan','ar-JO')
,('Arabic - Kuwait','ar-KW')
,('Arabic - Lebanon','ar-LB')
,('Arabic - Libya','ar-LY')
,('Arabic - Morocco','ar-MA')
,('Arabic - Oman','ar-OM')
,('Arabic - Qatar','ar-QA')
,('Arabic - Saudi Arabia','ar-SA')
,('Arabic - Syria','ar-SY')
,('Arabic - Tunisia','ar-TN')
,('Arabic - U.A.E.','ar-AE')
,('Arabic - Yemen','ar-YE')
,('Armenian - Armenia','hy-AM')
,('Assamese - India','as-IN')
,('Azerbaijani - Azerbaijan (Cyrillic)','az-Cyrl-AZ')
,('Azerbaijani - Azerbaijan (Latin)','az-Latn-AZ')
,('Bangla (Bangladesh)','bn-BD')
,('Bangla - India (Bengali Script)','bn-IN')
,('Bashkir - Russia','ba-RU')
,('Basque - Basque','eu-ES')
,('Belarusian - Belarus','be-BY')
,('Bosnian - Bosnia and Herzegovina (Cyrillic)','bs-Cyrl-BA')
,('Bosnian - Bosnia and Herzegovina (Latin)','bs-Latn-BA')
,('Breton - France','br-FR')
,('Bulgarian - Bulgaria','bg-BG')
,('Burmese - Myanmar','my-MM')
,('Catalan - Catalan','ca-ES')
,('Central Atlas Tamazight (Latin) - Algeria','fr-FR')
,('Central Atlas Tamazight (Latin) - Algeria','tzm-Latn-DZ')
,('Central Atlas Tamazight (Tifinagh) - Morocco','tzm-Tfng-MA')
,('Central Kurdish (Iraq)','ku-Arab-IQ')
,('Cherokee (Cherokee, United States)','chr-Cher-US')
,('Chinese (Simplified, China)','zh-CN')
,('Chinese - (Traditional, Taiwan)','zh-TW')
,('Corsican - France','co-FR')
,('Croatian - Bosnia and Herzegovina','hr-BA')
,('Croatian - Croatia','hr-HR')
,('Czech - Czech Republic','cs-CZ')
,('Danish - Denmark','da-DK')
,('Dari - Afghanistan','prs-AF')
,('Divehi - Maldives','dv-MV')
,('Dutch - Belgium','nl-BE')
,('Dutch - Netherlands','nl-NL')
,('Dzongkha','dz-BT')
,('English - Australia','en-AU')
,('English - Belize','en-BZ')
,('English - Canada','en-CA')
,('English - Caribbean','en-029')
,('English - India','en-IN')
,('English - Ireland','en-IE')
,('English - Jamaica','en-JM')
,('English - Malaysia','en-MY')
,('English - New Zealand','en-NZ')
,('English - Philippines','en-PH')
,('English - Singapore','en-SG')
,('English - South Africa','en-ZA')
,('English - Trinidad','en-TT')
,('English - Great Britain','en-GB')
,('English - United States','en-US')
,('English - Zimbabwe','en-ZW')
,('Estonian - Estonia','et-EE')
,('Faroese - Faroe Islands','fo-FO')
,('Filipino - Philippines','fil-PH')
,('Finnish - Finland','fi-FI')
,('French - Belgium','fr-BE')
,('French - Canada','fr-CA')
,('French - France','fr-FR')
,('French - Luxembourg','fr-LU')
,('French - Monaco','fr-MC')
,('French - Switzerland','fr-CH')
,('Frisian - Netherlands','fy-NL')
,('Fulah (Latin, Senegal)','ff-Latn-SN')
,('Galician - Galician','gl-ES')
,('Georgian - Georgia','ka-GE')
,('German - Austria','de-AT')
,('German - Germany','de-DE')
,('German - Liechtenstein','de-LI')
,('German - Luxembourg','de-LU')
,('German - Switzerland','de-CH')
,('Greek - Greece','el-GR')
,('Greenlandic - Greenland','kl-GL')
,('Guarani - Paraguay','gn-PY')
,('Gujarati - India (Gujarati Script)','gu-IN')
,('Hausa (Latin) - Nigeria','ha-Latn-NG')
,('Hawaiian - United States','haw-US')
,('Hebrew - Israel','he-IL')
,('Hindi - India','hi-IN')
,('Hungarian - Hungary','hu-HU')
,('Icelandic - Iceland','is-IS')
,('Igbo - Nigeria','ig-NG')
,('Inari Sami - Finland','smn-FI')
,('Indonesian - Indonesia','id-ID')
,('Inuktitut (Latin) - Canada','iu-Latn-CA')
,('Inuktitut (Syllabics) - Canada','iu-Cans-CA')
,('Irish - Ireland','ga-IE')
,('isiXhosa / Xhosa - South Africa','xh-ZA')
,('isiZulu / Zulu - South Africa','zu-ZA')
,('Italian - Italy','it-IT')
,('Italian - Switzerland','it-CH')
,('Japanese - Japan','ja-JP')
,('Javanese (Latin) - Indonesia','jv-Latn-ID')
,('Kannada - India (Kannada Script)','kn-IN')
,('Kazakh - Kazakhstan','kk-KZ')
,('Khmer - Cambodia','km-KH')
,('K''iche - Guatemala','qut-GT')
,('Kinyarwanda - Rwanda','rw-RW')
,('Konkani - India','kok-IN')
,('Korean(Extended Wansung) - Korea','ko-KR')
,('Kyrgyz - Kyrgyzstan','ky-KG')
,('Lao - Lao PDR','lo-LA')
,('Latvian - Legacy','lv-LV')
,('Latvian - Standard','lv-LV')
,('Lithuanian - Lithuania','lt-LT')
,('Lower Sorbian - Germany','dsb-DE')
,('Lule Sami - Norway','smj-NO')
,('Lule Sami - Sweden','smj-SE')
,('Luxembourgish - Luxembourg','lb-LU')
,('Macedonian - F.Y.R.O.M','mk-MK')
,('Malay - Brunei','ms-BN')
,('Malay - Malaysia','ms-MY')
,('Malayalam - India (Malayalam Script)','ml-IN')
,('Maltese - Malta','mt-MT')
,('Maori - New Zealand','mi-NZ')
,('Mapudungun - Chile','arn-CL')
,('Marathi - India','mr-IN')
,('Mohawk - Mohawk','moh-CA')
,('Mongolian (Cyrillic) - Mongolia','mn-MN')
,('Mongolian (Mongolian) - Mongolia','mn-Mong-MN')
,('Mongolian (Traditional Mongolian – China – Legacy)','mn-Mong-CN')
,('Mongolian (Traditional Mongolian – China – Standard)','mn-Mong-CN')
,('N''ko – Guinea','nqo-GN')
,('Nepali - Federal Democratic Republic of Nepal','ne-NP')
,('Northern Sami - Finland','se-FI')
,('Northern Sami - Norway','se-NO')
,('Northern Sami - Sweden','se-SE')
,('Norwegian - Norway (Bokmål)','nb-NO')
,('Norwegian - Norway (Nynorsk)','nn-NO')
,('Occitan - France','oc-FR')
,('Odia - India (Odia Script)','or-IN')
,('Pashto - Afghanistan','ps-AF')
,('Persian','fa-IR')
,('Polish - Poland','pl-PL')
,('Portuguese - Brazil','pt-BR')
,('Portuguese - Portugal','pt-PT')
,('Punjabi - India (Gurmukhi Script)','pa-IN')
,('Punjabi (Islamic Republic of Pakistan)','pa-Arab-PK')
,('Quechua - Bolivia','quz-BO')
,('Quechua - Ecuador','quz-EC')
,('Quechua - Peru','quz-PE')
,('Romanian - Romania','ro-RO')
,('Romansh - Switzerland','rm-CH')
,('Russian - Russia','ru-RU')
,('Sakha - Russia','sah-RU')
,('Sanskrit - India','sa-IN')
,('Scottish Gaelic - Great Britain','gd-GB')
,('Serbian - Bosnia and Herzegovina (Cyrillic)','sr-Cyrl-BA')
,('Serbian - Bosnia and Herzegovina (Latin)','sr-Latn-BA')
,('Serbian - Montenegro (Cyrillic)','sr-Cyrl-ME')
,('Serbian - Montenegro (Latin)','sr-Latn-ME')
,('Serbian - Serbia (Cyrillic)','sr-Cyrl-RS')
,('Serbian - Serbia (Latin)','sr-Latn-RS')
,('Serbian - Serbia and Montenegro (Former) (Cyrillic)','sr-Cyrl-CS')
,('Serbian - Serbia and Montenegro (Former) (Latin)','sr-Latn-CS')
,('Sesotho sa Leboa / Northern Sotho - South Africa','nso-ZA')
,('Setswana / Tswana - Botswana','tn-BW')
,('Setswana / Tswana - South Africa','tn-ZA')
,('Shona – Zimbabwe','sn-Latn-ZW')
,('Sindhi (Islamic Republic of Pakistan)','sd-Arab-PK')
,('Sinhala - Sri Lanka','si-LK')
,('Skolt Sami - Finland','sms-FI')
,('Slovak - Slovakia','sk-SK')
,('Slovenian - Slovenia','sl-SI')
,('Southern Sami - Norway','sma-NO')
,('Southern Sami - Sweden','sma-SE')
,('Spanish - Argentina','es-AR')
,('Spanish - Bolivarian Republic of Venezuela','es-VE')
,('Spanish - Bolivia','es-BO')
,('Spanish - Chile','es-CL')
,('Spanish - Colombia','es-CO')
,('Spanish - Costa Rica','es-CR')
,('Spanish - Dominican Republic','es-DO')
,('Spanish - Ecuador','es-EC')
,('Spanish - El Salvador','es-SV')
,('Spanish - Guatemala','es-GT')
,('Spanish - Honduras','es-HN')
,('Spanish - Latin America','es-419')
,('Spanish - Mexico','es-MX')
,('Spanish - Nicaragua','es-NI')
,('Spanish - Panama','es-PA')
,('Spanish - Paraguay','es-PY')
,('Spanish - Peru','es-PE')
,('Spanish - Commonwealth of Puerto Rico','es-PR')
,('Spanish - Spain (International Sort)','es-ES')
,('Spanish - Spain (Traditional Sort)','es-ES_tradnl')
,('Spanish - United States','es-US')
,('Spanish - Uruguay','es-UY')
,('Standard Moroccan Tamazight - Morocco','zgh-Tfng-MA')
,('Swahili - Kenya','sw-KE')
,('Swedish - Finland','sv-FI')
,('Swedish - Sweden','sv-SE')
,('Syriac - Syria','syr-SY')
,('Tajik - Tajikistan','tg-Cyrl-TJ')
,('Tamil - India','ta-IN')
,('Tamil - Sri Lanka','ta-LK')
,('Tatar – Russia (Legacy)','tt-RU')
,('Tatar – Russia (Standard)','tt-RU')
,('Telugu - India (Telugu Script)','te-IN')
,('Thai - Thailand','th-TH')
,('Tibetan - China','bo-CN')
,('Tigrinya (Eritrea)','ti-ET')
,('Tigrinya (Ethiopia)','ti-ET')
,('Turkish - Turkey','tr-TR')
,('Turkmen - Turkmenistan','tk-TM')
,('Ukrainian - Ukraine','uk-UA')
,('Upper Sorbian - Germany','hsb-DE')
,('Urdu – India','ur-IN')
,('Urdu (Islamic Republic of Pakistan)','ur-PK')
,('Uyghur - China','ug-CN')
,('Uzbek - Uzbekistan (Cyrillic)','uz-Cyrl-UZ')
,('Uzbek - Uzbekistan (Latin)','uz-Latn-UZ')
,('Valencian - Valencia','ca-ES-valencia')
,('Vietnamese - Vietnam','vi-VN')
,('Welsh - Great Britain','cy-GB')
,('Wolof - Senegal','wo-SN')
,('Yi - China','ii-CN')
DECLARE @currencyValue decimal = 1000.360
SELECT [language], FORMAT (@currencyValue, 'c', [langcode]) as langcode
FROM #temp
DROP TABLE #temp
Output:-
Afrikaans - South Africa | R1 000,00 |
Albanian - Albania | 1 000 Lekë |
Alsatian - France | 1 000,00 € |
Amharic - Ethiopia | ብር1,000.00 |
Arabic - Algeria | 1,000.00 د.ج. |
Arabic - Bahrain | 1,000.000 د.ب. |
Arabic - Egypt | 1,000.00 ج.م. |
Arabic - Iraq | 1,000.00 د.ع. |
Arabic - Jordan | 1,000.000 د.ا. |
Arabic - Kuwait | 1,000.000 د.ك. |
Arabic - Lebanon | 1,000.00 ل.ل. |
Arabic - Libya | 1,000.000 د.ل. |
Arabic - Morocco | 1,000.00 د.م. |
Arabic - Oman | 1,000.000 ر.ع. |
Arabic - Qatar | 1,000.00 ر.ق. |
Arabic - Saudi Arabia | 1,000.00 ر.س. |
Arabic - Syria | 1,000.00 ل.س. |
Arabic - Tunisia | 1,000.000 د.ت. |
Arabic - U.A.E. | 1,000.00 د.إ. |
Arabic - Yemen | 1,000.00 ر.ي. |
Armenian - Armenia | 1,000.00 ֏ |
Assamese - India | ₹ 1,000.00 |
Azerbaijani - Azerbaijan (Cyrillic) | 1 000,00 ₼ |
Azerbaijani - Azerbaijan (Latin) | 1.000,00 ₼ |
Bangla (Bangladesh) | 1,000.00৳ |
Bangla - India (Bengali Script) | ₹ 1,000.00 |
Bashkir - Russia | 1 000,00 ₽ |
Basque - Basque | 1.000,00 € |
Belarusian - Belarus | 1 000,00 Br |
Bosnian - Bosnia and Herzegovina (Cyrillic) | 1.000,00 КМ |
Bosnian - Bosnia and Herzegovina (Latin) | 1.000,00 KM |
Breton - France | 1 000,00 € |
Bulgarian - Bulgaria | 1 000,00 лв. |
Burmese - Myanmar | 1,000 K |
Catalan - Catalan | 1.000,00 € |
Central Atlas Tamazight (Latin) - Algeria | 1 000,00 € |
Central Atlas Tamazight (Latin) - Algeria | 1 000,00 DA |
Central Atlas Tamazight (Tifinagh) - Morocco | 1 000,00 ⴷⵔ |
Central Kurdish (Iraq) | د.ع.1,000.00 |
Cherokee (Cherokee, United States) | $1,000.00 |
Chinese (Simplified, China) | ¥1,000.00 |
Chinese - (Traditional, Taiwan) | NT$1,000.00 |
Corsican - France | 1 000,00 € |
Croatian - Bosnia and Herzegovina | 1.000,00 KM |
Croatian - Croatia | 1.000,00 kn |
Czech - Czech Republic | 1 000,00 Kč |
Danish - Denmark | 1.000,00 kr. |
Dari - Afghanistan | ؋1,000.00 |
Divehi - Maldives | 1,000.00 ރ. |
Dutch - Belgium | € 1.000,00 |
Dutch - Netherlands | € 1.000,00 |
Dzongkha | Nu.1,000.00 |
English - Australia | $1,000.00 |
English - Belize | $1,000.00 |
English - Canada | $1,000.00 |
English - Caribbean | EC$1,000.00 |
English - India | ₹ 1,000.00 |
English - Ireland | € 1,000.00 |
English - Jamaica | $1,000.00 |
English - Malaysia | RM1,000.00 |
English - New Zealand | $1,000.00 |
English - Philippines | ₱1,000.00 |
English - Singapore | $1,000.00 |
English - South Africa | R1 000,00 |
English - Trinidad | $1,000.00 |
English - Great Britain | £1,000.00 |
English - United States | $1,000.00 |
English - Zimbabwe | US$1,000.00 |
Estonian - Estonia | 1 000,00 € |
Faroese - Faroe Islands | 1.000,00 kr |
Filipino - Philippines | ₱1,000.00 |
Finnish - Finland | 1 000,00 € |
French - Belgium | 1.000,00 € |
French - Canada | 1 000,00 $ |
French - France | 1 000,00 € |
French - Luxembourg | 1.000,00 € |
French - Monaco | 1 000,00 € |
French - Switzerland | 1 000.00 CHF |
Frisian - Netherlands | € 1.000,00 |
Fulah (Latin, Senegal) | 1 000,00 CFA |
Galician - Galician | 1.000,00 € |
Georgian - Georgia | 1 000,00 ₾ |
German - Austria | € 1.000,00 |
German - Germany | 1.000,00 € |
German - Liechtenstein | CHF 1’000.00 |
German - Luxembourg | 1.000,00 € |
German - Switzerland | CHF 1’000.00 |
Greek - Greece | 1.000,00 € |
Greenlandic - Greenland | kr.1.000,00 |
Guarani - Paraguay | 1.000 ₲ |
Gujarati - India (Gujarati Script) | ₹1,000.00 |
Hausa (Latin) - Nigeria | ₦ 1,000.00 |
Hawaiian - United States | $1,000.00 |
Hebrew - Israel | ₪ 1,000.00 |
Hindi - India | ₹1,000.00 |
Hungarian - Hungary | 1 000,00 Ft |
Icelandic - Iceland | 1.000 kr |
Igbo - Nigeria | ₦1,000.00 |
Inari Sami - Finland | 1 000,00 € |
Indonesian - Indonesia | Rp1.000,00 |
Inuktitut (Latin) - Canada | $1,000.00 |
Inuktitut (Syllabics) - Canada | $1,000.00 |
Irish - Ireland | € 1,000.00 |
isiXhosa / Xhosa - South Africa | R1 000.00 |
isiZulu / Zulu - South Africa | R1,000.00 |
Italian - Italy | 1.000,00 € |
Italian - Switzerland | CHF 1’000.00 |
Japanese - Japan | ¥1,000 |
Javanese (Latin) - Indonesia | Rp1.000 |
Kannada - India (Kannada Script) | ₹1,000.00 |
Kazakh - Kazakhstan | 1 000,00 ₸ |
Khmer - Cambodia | 1,000.00៛ |
K'iche - Guatemala | Q1,000.00 |
Kinyarwanda - Rwanda | RF 1.000 |
Konkani - India | ₹ 1,000.00 |
Korean(Extended Wansung) - Korea | ₩1,000 |
Kyrgyz - Kyrgyzstan | 1 000,00 сом |
Lao - Lao PDR | ₭1.000 |
Latvian - Legacy | 1 000,00 € |
Latvian - Standard | 1 000,00 € |
Lithuanian - Lithuania | 1 000,00 € |
Lower Sorbian - Germany | 1.000,00 € |
Lule Sami - Norway | kr 1 000,00 |
Lule Sami - Sweden | 1.000,00 kr |
Luxembourgish - Luxembourg | 1 000,00 € |
Macedonian - F.Y.R.O.M | 1.000,00 ден |
Malay - Brunei | $ 1.000,00 |
Malay - Malaysia | RM1,000.00 |
Malayalam - India (Malayalam Script) | ₹1,000.00 |
Maltese - Malta | € 1,000.00 |
Maori - New Zealand | $1,000.00 |
Mapudungun - Chile | $ 1.000,00 |
Marathi - India | ₹1,000`00 |
Mohawk - Mohawk | $1,000.00 |
Mongolian (Cyrillic) - Mongolia | ₮ 1,000.00 |
Mongolian (Mongolian) - Mongolia | ₮1,000.00 |
Mongolian (Traditional Mongolian – China – Legacy) | ¥1,000.00 |
Mongolian (Traditional Mongolian – China – Standard) | ¥1,000.00 |
N'ko – Guinea | ߖߕ. 1,000.00 |
Nepali - Federal Democratic Republic of Nepal | रु 1,000.00 |
Northern Sami - Finland | 1 000,00 € |
Northern Sami - Norway | 1 000,00 kr |
Northern Sami - Sweden | 1.000,00 kr |
Norwegian - Norway (Bokmål) | kr 1 000,00 |
Norwegian - Norway (Nynorsk) | 1 000,00 kr |
Occitan - France | 1 000,00 € |
Odia - India (Odia Script) | ₹ 1,000.00 |
Pashto - Afghanistan | 1.000 ؋ |
Persian | 1,000/00ريال |
Polish - Poland | 1 000,00 zł |
Portuguese - Brazil | R$ 1.000,00 |
Portuguese - Portugal | 1 000,00 € |
Punjabi - India (Gurmukhi Script) | ₹ 1,000.00 |
Punjabi (Islamic Republic of Pakistan) | Rs 1,000.00 |
Quechua - Bolivia | Bs. 1.000,00 |
Quechua - Ecuador | $ 1.000,00 |
Quechua - Peru | S/ 1,000.00 |
Romanian - Romania | 1.000,00 lei |
Romansh - Switzerland | 1’000.00 CHF |
Russian - Russia | 1 000,00 ₽ |
Sakha - Russia | 1 000,00 ₽ |
Sanskrit - India | ₹ 1,000.00 |
Scottish Gaelic - Great Britain | £1,000.00 |
Serbian - Bosnia and Herzegovina (Cyrillic) | 1.000,00 КМ |
Serbian - Bosnia and Herzegovina (Latin) | 1.000,00 KM |
Serbian - Montenegro (Cyrillic) | 1.000,00 € |
Serbian - Montenegro (Latin) | 1.000,00 € |
Serbian - Serbia (Cyrillic) | 1.000,00 дин. |
Serbian - Serbia (Latin) | 1.000 RSD |
Serbian - Serbia and Montenegro (Former) (Cyrillic) | 1.000,00 дин. |
Serbian - Serbia and Montenegro (Former) (Latin) | 1.000,00 din. |
Sesotho sa Leboa / Northern Sotho - South Africa | R 1 000.00 |
Setswana / Tswana - Botswana | P1 000.00 |
Setswana / Tswana - South Africa | R1 000.00 |
Shona – Zimbabwe | $1,000.00 |
Sindhi (Islamic Republic of Pakistan) | Rs 1,000.00 |
Sinhala - Sri Lanka | රු.1,000.00 |
Skolt Sami - Finland | 1 000,00 € |
Slovak - Slovakia | 1 000,00 € |
Slovenian - Slovenia | 1.000,00 € |
Southern Sami - Norway | kr 1 000,00 |
Southern Sami - Sweden | 1.000,00 kr |
Spanish - Argentina | $ 1.000,00 |
Spanish - Bolivarian Republic of Venezuela | Bs.S1.000,00 |
Spanish - Bolivia | Bs1.000,00 |
Spanish - Chile | $1.00 |
Spanish - Colombia | $ 1.000,00 |
Spanish - Costa Rica | ₡1 000,00 |
Spanish - Dominican Republic | $1,000.00 |
Spanish - Ecuador | $1.000,00 |
Spanish - El Salvador | $1,000.00 |
Spanish - Guatemala | Q1,000.00 |
Spanish - Honduras | L1,000.00 |
Spanish - Latin America | XDR1,000.00 |
Spanish - Mexico | $1,000.00 |
Spanish - Nicaragua | C$1,000.00 |
Spanish - Panama | B/.1,000.00 |
Spanish - Paraguay | ₲ 1.000 |
Spanish - Peru | S/ 1,000.00 |
Spanish - Commonwealth of Puerto Rico | $1,000.00 |
Spanish - Spain (International Sort) | 1.000,00 € |
Spanish - Spain (Traditional Sort) | 1.000,00 € |
Spanish - United States | $1,000.00 |
Spanish - Uruguay | $ 1.000,00 |
Standard Moroccan Tamazight - Morocco | 1 000,00MAD |
Swahili - Kenya | Ksh 1,000.00 |
Swedish - Finland | 1 000,00 € |
Swedish - Sweden | 1 000,00 kr |
Syriac - Syria | 1,000.00 ܠ.ܣ. |
Tajik - Tajikistan | 1 000,00 смн |
Tamil - India | ₹ 1,000.00 |
Tamil - Sri Lanka | Rs. 1,000.00 |
Tatar – Russia (Legacy) | 1 000,00 ₽ |
Tatar – Russia (Standard) | 1 000,00 ₽ |
Telugu - India (Telugu Script) | ₹1,000.00 |
Thai - Thailand | ฿1,000.00 |
Tibetan - China | ¥1,000.00 |
Tigrinya (Eritrea) | Br1,000.00 |
Tigrinya (Ethiopia) | Br1,000.00 |
Turkish - Turkey | ₺1.000,00 |
Turkmen - Turkmenistan | 1 000,00m. |
Ukrainian - Ukraine | 1 000,00 ₴ |
Upper Sorbian - Germany | 1.000,00 € |
Urdu – India | ₹1,000.00 |
Urdu (Islamic Republic of Pakistan) | Rs 1,000.00 |
Uyghur - China | ¥1,000.00 |
Uzbek - Uzbekistan (Cyrillic) | 1 000,00 сўм |
Uzbek - Uzbekistan (Latin) | 1 000,00 soʻm |
Valencian - Valencia | 1.000,00 € |
Vietnamese - Vietnam | 1.000,00 ₫ |
Welsh - Great Britain | £1,000.00 |
Wolof - Senegal | 1 000,00 CFA |
Yi - China | ¥1,000.00 |
Currency format in SQL Server- you will learn how to use currency format in sql server?. When working with currency formats, there are many different formats used around the world. For example, in the USA we use the $ for the currency symbol and a decimal point as a separator. Whereas in Latin America, we use the decimal point instead of a comma as the separator.
C# is a programming language developed by Microsoft that runs on the .NET Framework. C# is used to develop web, desktop, mobile, games and much more application.
C# is a object-oriented programming language developed by Microsoft within its .NET Framework. Led by Anders Hejlsberg, your basic C# programming
and will also take you through various advanced concepts related to C# programming language.
C# such as control statements, objects and classes, inheritance, constructor, destructor, this, static, sealed, polymorphism, abstraction, abstract class, interface, File IO, Collections, namespace, encapsulation, properties, indexer, arrays, strings, regex, exception handling, multithreading etc.
For example...
using System;
namespace MinifyCode
{
class Program
{
static void Main(string[] args)
{
Console.WriteLine("Hello Minify Code");
}
}
}
Output: Hello Minify Code
In this article you will learn, what is server side controls. We will discuss each of these objects in due time. In this tutorial we will explore the Server object, the Request object, and the Response object.
Session
Application
Cache
Request
Response
Server
User
Trace
Server Object
The Server object in Asp.NET is an instance of the System.Web.HttpServerUtility class. The HttpServerUtility class provides numerous properties and methods to perform many type of jobs.
Methods and Properties of the Server object
The methods and properties of the HttpServerUtility class are exposed through the intrinsic Server object provided by ASP.NET.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Optimization;
using System.Web.Routing;
using System.Web.Security;
using System.Web.SessionState;
using System.Data.Entity;
namespace minifycode
{
public class Global : HttpApplication
{
void Application_Start(object sender, EventArgs e)
{
// Code that runs on application startup
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
// Initialize the product database.
Database.SetInitializer(new ProductDatabaseInitializer());
// Create custom role and user.
RoleActions roleActions = new RoleActions();
roleActions.AddUserAndRole();
// Add Routes.
RegisterCustomRoutes(RouteTable.Routes);
}
void RegisterCustomRoutes(RouteCollection routes)
{
routes.MapPageRoute(
"ProductsCategoryRoute",
"Category/{categoryName}",
"~/ProductList.aspx"
);
routes.MapPageRoute(
"ProductNameRoute",
"Product/{productName}",
"~/ProductDetails.aspx"
);
}
}
}