Minifycode 2022-05-18 Viewed 59 times C#

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" ); } } }