Archive for June, 2008

Foundation of Programming Ebook

June 27, 2008

Hi all,

The Foundation Of Programming Series Free ebook By Karl Seguin

Nguyen Minh Dung

Advertisements

J.D. Meier patterns and practices Complete Catalog

June 25, 2008

http://blogs.msdn.com/jmeier/archive/2008/03/04/patterns-and-practices-complete-catalog.aspx

10 new features of SQL 2008

June 25, 2008

Go to 10-reasons-why-sql-server-2008-is-going-to-rock

WPF Resource

June 25, 2008

http://roecode.wordpress.com/category/wpf/
http://wpf.netfx3.com/files/folders/code_snippets/entry3752.aspx

http://blogs.microsoft.co.il/blogs/tamir/archive/2008/01/29/printing-more-the…

VS 2008 & .NET 3.5 SP1 beta

June 25, 2008

Come to see Scott Gu describes new excellent things.
visual-studio-2008-and-net-framework-3-5-service-pack-1-beta

SAF 2007 Link

June 25, 2008

This is SAF 2007

Nice day!

Use Rank function in SQL Server 2005

June 25, 2008

Today another problem beats me again. I have a table Score

ID int PK

Name varchar

Score int

Date datetime

and my member asks me to retrieve all records of 10 last days with theirs max score. Again, another help from a friend of mine (the guy I mentioned in previous article) and bro Google.

The query is:

WITH PageScore (ID, Date, Score, PosNo)

AS

(

SELECT ID, Date, Score,

Dense_rank() OVER (ORDER BY Score desc, date desc)

AS PosNo

FROM Score

where date in

(select distinct top 10 date

from Score

order by date desc)

)

 

SELECT * FROM PageScore

WHERE PosNo <= 10;

 

 

Another great day!

Nguyen Minh Dung

Use CTE to retrieve hierarchical records of a self-join table in SQL Server 2005

June 25, 2008

A tired working day, I was going to turn my PC off and went home. Abruptly, I remembered there was remaining a stuff to finish. Oh, “what the hell is going on?”, a table named “Categories” and it is self-join and I had to select all records of its in terms of hierarchical style. I was confusing; also, hungry. I made a call to a friend, he is an expert in Oracle. He said in SQL Server 2005, “Common Table Expression (CTE)” should be my solution. After about 15 minutes of google, I found the T-SQL code to address my problem. It is about to show up bellow

 

WITH CategoriesView (CategoriesID, ParentID, CategoriesName, TreeOrder) AS

(

SELECT CategoriesID,

ParentID,

CategoriesName,

 

Cast(dbo.FormatString(SortOrder,5) as varchar)

 

FROM Categories

WHERE ParentID = 0

UNION ALL

SELECT e.CategoriesID,

e.ParentID,

e.CategoriesName,

Cast((dbo.FormatString(cv.TreeOrder,5) + dbo.FormatString(c.SortOrder,5)) as varchar) as TreeOrder

FROM Categories c

INNER JOIN CategoriesView cv

ON c.ParentID = cv.CategoriesID

)

 

SELECT *

FROM CategoriesView

ORDER BY TreeOrder

 

Description:

  • CategoriesID is an identity column of Int(4)
  • SortOrder is order of a Categories in its level.

Explanation:

  • We use CTE, a new feature in SQL Server 2005; So, with keyword “WITH”, we generate a view of all records in table Categories. In that view, a new column “TreeOrder” is spawned by recursively adding the TreeOrder value of parent Category to current SortOrder value.

dbo.FormatString(cv.TreeOrder,5) + dbo.FormatString(c.SortOrder,5)

 

There is another way (but a neglect one) is create a column “TreeOrder” in table Categories. Every time table Categories is updated (delete/add/update), we have to run a stored procedure to re-calculate the value of “TreeOrder”.

 

I was late for home about 1 hour, but had a great day!

Nguyen Minh Dung

One comprehensive resource is http://www.sqlservercentral.com/articles/SQL+Server+2005+-+TSQL/recursivequer…

2 useful hierarchical functions

.NET Culture Info List

June 25, 2008

Thanks to Culture Info List, I bring them here for easy reference

* Native name may not display properly if font for the language is not installed.

Name / Native*/ Display / English Currency English Name / Native* / Symbol / ISO ISO(2) / ISO(3) / Win GeoID / Metrics
AR-SA
المملكة العربية السعودية
Saudi Arabia
Saudi Arabia
Saudi Riyal
ريال سعودي
ر.س.‏
SAR
SA
SAU
SAU
205
True
BG-BG
България
Bulgaria
Bulgaria
Bulgarian Lev
лв.
лв
BGL
BG
BGR
BGR
35
True
CA-ES
Espanya
Spain
Spain
Euro
euro

EUR
ES
ESP
ESP
217
True
ZH-TW
台灣
Taiwan
Taiwan
New Taiwan Dollar
新台幣
NT$
TWD
TW
TWN
TWN
237
True
CS-CZ
Česká republika
Czech Republic
Czech Republic
Czech Koruna
Koruna Česká

CZK
CZ
CZE
CZE
75
True
DA-DK
Danmark
Denmark
Denmark
Danish Krone
Dansk krone
kr
DKK
DK
DNK
DNK
61
True
DE-DE
Deutschland
Germany
Germany
Euro
Euro

EUR
DE
DEU
DEU
94
True
EL-GR
Ελλάδα
Greece
Greece
Euro
ευρώ

EUR
GR
GRC
GRC
98
True
EN-US
United States
United States
United States
US Dollar
US Dollar
$
USD
US
USA
USA
244
False
FI-FI
Suomi
Finland
Finland
Euro
euro

EUR
FI
FIN
FIN
77
True
FR-FR
France
France
France
Euro
euro

EUR
FR
FRA
FRA
84
True
HE-IL
ישראל
Israel
Israel
Israeli New Shekel
שקל חדש

ILS
IL
ISR
ISR
117
True
HU-HU
Magyarország
Hungary
Hungary
Hungarian Forint
forint
Ft
HUF
HU
HUN
HUN
109
True
IS-IS
Ísland
Iceland
Iceland
Icelandic Krona
Króna
kr.
ISK
IS
ISL
ISL
110
True
IT-IT
Italia
Italy
Italy
Euro
euro

EUR
IT
ITA
ITA
118
True
JA-JP
日本
Japan
Japan
Japanese Yen

¥
JPY
JP
JPN
JPN
122
True
KO-KR
대한민국
Korea
Korea
Korean Won


KRW
KR
KOR
KOR
134
True
NL-NL
Nederland
Netherlands
Netherlands
Euro
euro

EUR
NL
NLD
NLD
176
True
NB-NO
Norge
Norway
Norway
Norwegian Krone
Norsk krone
kr
NOK
NO
NOR
NOR
177
True
PL-PL
Polska
Poland
Poland
Polish Zloty
Złoty

PLN
PL
POL
POL
191
True
PT-BR
Brasil
Brazil
Brazil
Real
Real
R$
BRL
BR
BRA
BRA
32
True
RO-RO
România
Romania
Romania
Romanian Leu
Leu
lei
ROL
RO
ROU
ROM
200
True
RU-RU
Россия
Russia
Russia
Russian Ruble
рубль
р.
RUR
RU
RUS
RUS
203
True
HR-HR
Hrvatska
Croatia
Croatia
Croatian Kuna
hrvatska kuna
kn
HRK
HR
HRV
HRV
108
True
SK-SK
Slovenská republika
Slovakia
Slovakia
Slovak Koruna
Slovenská koruna
Sk
SKK
SK
SVK
SVK
143
True
SQ-AL
Shqipëria
Albania
Albania
Albanian Lek
Lek
Lek
ALL
AL
ALB
ALB
6
True
SV-SE
Sverige
Sweden
Sweden
Swedish Krona
Svensk krona
kr
SEK
SE
SWE
SWE
221
True
TH-TH
ไทย
Thailand
Thailand
Thai Baht
บาท
฿
THB
TH
THA
THA
227
True
TR-TR
Türkiye
Turkey
Turkey
New Turkish Lira
Yeni Türk Lirası
YTL
TRY
TR
TUR
TUR
235
True
UR-PK
پاکستان
Islamic Republic of Pakistan
Islamic Republic of Pakistan
Pakistan Rupee
روپيه
Rs
PKR
PK
PAK
PAK
190
True
ID-ID
Indonesia
Indonesia
Indonesia
Indonesian Rupiah
Rupiah
Rp
IDR
ID
IDN
IDN
111
True
UK-UA
Україна
Ukraine
Ukraine
Ukrainian Grivna
гривня
грн.
UAH
UA
UKR
UKR
241
True
BE-BY
Беларусь
Belarus
Belarus
Belarusian Ruble
рубль
р.
BYB
BY
BLR
BLR
29
True
SL-SI
Slovenija
Slovenia
Slovenia
Slovenian Tolar
slovenski tolar
SIT
SIT
SI
SVN
SVN
212
True
ET-EE
Eesti
Estonia
Estonia
Estonian Kroon
Kroon
kr
EEK
EE
EST
EST
70
True
LV-LV
Latvija
Latvia
Latvia
Latvian Lats
Lats
Ls
LVL
LV
LVA
LVA
140
True
LT-LT
Lietuva
Lithuania
Lithuania
Lithuanian Litas
Litas
Lt
LTL
LT
LTU
LTU
141
True
FA-IR
ايران
Iran
Iran
Iranian Rial
رىال
ريال
IRR
IR
IRN
IRN
116
True
VI-VN
Việt Nam
Vietnam
Vietnam
Vietnamese Dong
Đồng

VND
VN
VNM
VNM
251
True
HY-AM
Հայաստան
Armenia
Armenia
Armenian Dram
դրամ
դր.
AMD
AM
ARM
ARM
7
True
AZ-LATN-AZ
Azərbaycanca
Azerbaijan
Azerbaijan
Azerbaijanian Manat
manat
man.
AZM
AZ
AZE
AZE
5
True
EU-ES
Espainia
Spain
Spain
Euro
euro

EUR
ES
ESP
ESP
217
True
MK-MK
Македонија
Macedonia (FYROM)
Macedonia (FYROM)
Macedonian Denar
денар
ден.
MKD
MK
MKD
MKD
19618
True
AF-ZA
Suid Afrika
South Africa
South Africa
South African Rand
Rand
R
ZAR
ZA
ZAF
ZAF
209
True
KA-GE
საქართველო
Georgia
Georgia
Lari
ლარი
Lari
GEL
GE
GEO
GEO
88
True
FO-FO
Føroyar
Faroe Islands
Faroe Islands
Danish Krone
Dansk krone
kr
DKK
FO
FRO
FRO
81
True
HI-IN
भारत
India
India
Indian Rupee
रुपया
रु
INR
IN
IND
IND
113
True
MS-MY
Malaysia
Malaysia
Malaysia
Malaysian Ringgit
Ringgit Malaysia
R
MYR
MY
MYS
MYS
167
True
KK-KZ
Қазақстан
Kazakhstan
Kazakhstan
Tenge
Т
Т
KZT
KZ
KAZ
KAZ
137
True
KY-KG
Кыргызстан
Kyrgyzstan
Kyrgyzstan
som
сом
сом
KGS
KG
KGZ
KGZ
130
True
SW-KE
Kenya
Kenya
Kenya
Kenyan Shilling
Shilingi
S
KES
KE
KEN
KEN
129
False
UZ-LATN-UZ
U’zbekiston Respublikasi
Uzbekistan
Uzbekistan
Uzbekistan Sum
рубль
su’m
UZS
UZ
UZB
UZB
247
True
TT-RU
Россия
Russia
Russia
Russian Ruble
рубль
р.
RUR
RU
RUS
RUS
203
True
PA-IN
ਭਾਰਤ
India
India
Indian Rupee
ਰੁਪਿਆ
ਰੁ
INR
IN
IND
IND
113
True
GU-IN
ભારત
India
India
Indian Rupee
રૂપિયો
રૂ
INR
IN
IND
IND
113
True
TA-IN
இந்தியா
India
India
Indian Rupee
ரூபாய்
ரூ
INR
IN
IND
IND
113
True
TE-IN
భారత దేశం
India
India
Indian Rupee
రూపాయి
రూ
INR
IN
IND
IND
113
True
KN-IN
ಭಾರತ
India
India
Indian Rupee
ರೂಪಾಯಿ
ರೂ
INR
IN
IND
IND
113
True
MR-IN
भारत
India
India
Indian Rupee
रुपया
रु
INR
IN
IND
IND
113
True
SA-IN
भारतम्
India
India
Indian Rupee
रु्यकम्
रु
INR
IN
IND
IND
113
True
MN-MN
Монгол улс
Mongolia
Mongolia
Tugrik
Төгрөг

MNT
MN
MNG
MNG
154
True
GL-ES
España
Spain
Spain
Euro
euro

EUR
ES
ESP
ESP
217
True
KOK-IN
भारत
India
India
Indian Rupee
रुपय
रु
INR
IN
IND
IND
113
True
SYR-SY
سوريا
Syria
Syria
Syrian Pound
جنيه سوري
ل.س.‏
SYP
SY
SYR
SYR
222
True
DV-MV
ދިވެހި ރާއްޖެ
Maldives
Maldives
Rufiyaa
ރުފިޔާ
ރ.
MVR
MV
MDV
MDV
165
True
AR-IQ
العراق
Iraq
Iraq
Iraqi Dinar
دينار عراقي
د.ع.‏
IQD
IQ
IRQ
IRQ
121
True
ZH-CN
中华人民共和国
People’s Republic of China
People’s Republic of China
PRC Yuan Renminbi
人民币

CNY
CN
CHN
CHN
45
True
DE-CH
Schweiz
Switzerland
Switzerland
Swiss Franc
Schweizer Franken
SFr.
CHF
CH
CHE
CHE
223
True
EN-GB
United Kingdom
United Kingdom
United Kingdom
UK Pound Sterling
Pound Sterling
£
GBP
GB
GBR
GBR
242
True
ES-MX
México
Mexico
Mexico
Mexican Peso
Peso
$
MXN
MX
MEX
MEX
166
True
FR-BE
Belgique
Belgium
Belgium
Euro
euro

EUR
BE
BEL
BEL
21
True
IT-CH
Svizzera
Switzerland
Switzerland
Swiss Franc
Franco svizzero
SFr.
CHF
CH
CHE
CHE
223
True
NL-BE
België
Belgium
Belgium
Euro
euro

EUR
BE
BEL
BEL
21
True
NN-NO
Noreg
Norway
Norway
Norwegian Krone
Norsk krone
kr
NOK
NO
NOR
NOR
177
True
PT-PT
Portugal
Portugal
Portugal
Euro
euro

EUR
PT
PRT
PRT
193
True
SR-LATN-CS
Srbija
Serbia
Serbia
Serbian Dinar
dinar
Din.
CSD
CS
SCG
SCG
269
True
SV-FI
Finland
Finland
Finland
Euro
euro

EUR
FI
FIN
FIN
77
True
AZ-CYRL-AZ
Азәрбајҹан
Azerbaijan
Azerbaijan
Azerbaijanian Manat
рубль
ман.
AZM
AZ
AZE
AZE
5
True
MS-BN
Brunei Darussalam
Brunei Darussalam
Brunei Darussalam
Brunei Dollar
Ringgit Brunei
$
BND
BN
BRN
BRN
37
True
UZ-CYRL-UZ
Ўзбекистон Республикаси
Uzbekistan
Uzbekistan
Uzbekistan Sum
рубль
сўм
UZS
UZ
UZB
UZB
247
True
AR-EG
مصر
Egypt
Egypt
Egyptian Pound
جنيه مصري
ج.م.‏
EGP
EG
EGY
EGY
67
True
ZH-HK
香港特别行政區
Hong Kong S.A.R.
Hong Kong S.A.R.
Hong Kong Dollar
港幣
HK$
HKD
HK
HKG
HKG
104
True
DE-AT
Österreich
Austria
Austria
Euro
Euro

EUR
AT
AUT
AUT
14
True
EN-AU
Australia
Australia
Australia
Australian Dollar
Australian Dollar
$
AUD
AU
AUS
AUS
12
True
ES-ES
España
Spain
Spain
Euro
euro

EUR
ES
ESP
ESP
217
True
FR-CA
Canada
Canada
Canada
Canadian Dollar
Dollar canadien
$
CAD
CA
CAN
CAN
39
True
SR-CYRL-CS
Србија
Serbia
Serbia
Serbian Dinar
динар
Дин.
CSD
CS
SCG
SCG
269
True
AR-LY
ليبيا
Libya
Libya
Libyan Dinar
دينار ليبي
د.ل.‏
LYD
LY
LBY
LBY
148
True
ZH-SG
新加坡
Singapore
Singapore
Singapore Dollar
新币
$
SGD
SG
SGP
SGP
215
False
DE-LU
Luxemburg
Luxembourg
Luxembourg
Euro
Euro

EUR
LU
LUX
LUX
147
True
EN-CA
Canada
Canada
Canada
Canadian Dollar
Canadian Dollar
$
CAD
CA
CAN
CAN
39
True
ES-GT
Guatemala
Guatemala
Guatemala
Guatemalan Quetzal
Quetzal
Q
GTQ
GT
GTM
GTM
99
True
FR-CH
Suisse
Switzerland
Switzerland
Swiss Franc
Franc suisse
SFr.
CHF
CH
CHE
CHE
223
True
AR-DZ
الجزائر
Algeria
Algeria
Algerian Dinar
دينار جزائري
د.ج.‏
DZD
DZ
DZA
DZA
4
True
ZH-MO
澳門特别行政區
Macao S.A.R.
Macao S.A.R.
Macao Pataca
Pataca
MOP
MOP
MO
MAC
MCO
151
True
DE-LI
Liechtenstein
Liechtenstein
Liechtenstein
Swiss Franc
Schweizer Franken
CHF
CHF
LI
LIE
LIE
145
True
EN-NZ
New Zealand
New Zealand
New Zealand
New Zealand Dollar
New Zealand Dollar
$
NZD
NZ
NZL
NZL
183
True
ES-CR
Costa Rica
Costa Rica
Costa Rica
Costa Rican Colon
Colón

CRC
CR
CRI
CRI
54
True
FR-LU
Luxembourg
Luxembourg
Luxembourg
Euro
euro

EUR
LU
LUX
LUX
147
True
AR-MA
المملكة المغربية
Morocco
Morocco
Moroccan Dirham
درهم مغربي
د.م.‏
MAD
MA
MAR
MAR
159
True
EN-IE
Eire
Ireland
Ireland
Euro
Euro

EUR
IE
IRL
IRL
68
True
ES-PA
Panamá
Panama
Panama
Panamanian Balboa
Balboa
B/.
PAB
PA
PAN
PAN
192
True
FR-MC
Principauté de Monaco
Principality of Monaco
Principality of Monaco
Euro
euro

EUR
MC
MCO
MCO
158
True
AR-TN
تونس
Tunisia
Tunisia
Tunisian Dinar
دينار تونسي
د.ت.‏
TND
TN
TUN
TUN
234
True
EN-ZA
South Africa
South Africa
South Africa
South African Rand
Rand
R
ZAR
ZA
ZAF
ZAF
209
True
ES-DO
República Dominicana
Dominican Republic
Dominican Republic
Dominican Peso
Peso
RD$
DOP
DO
DOM
DOM
65
True
AR-OM
عمان
Oman
Oman
Rial Omani
ريال عماني
ر.ع.‏
OMR
OM
OMN
OMN
164
True
EN-JM
Jamaica
Jamaica
Jamaica
Jamaican Dollar
Jamaican Dollar
J$
JMD
JM
JAM
JAM
124
False
ES-VE
Republica Bolivariana de Venezuela
Venezuela
Venezuela
Venezuelan Bolivar
Bolívar
Bs
VEB
VE
VEN
VEN
249
True
AR-YE
اليمن
Yemen
Yemen
Yemeni Rial
ريال يمني
ر.ي.‏
YER
YE
YEM
YEM
261
True
EN-029
Caribbean
Caribbean
Caribbean
US Dollar
US Dollar
$
USD
029
029
CAR
124
False
ES-CO
Colombia
Colombia
Colombia
Colombian Peso
Peso
$
COP
CO
COL
COL
51
True
AR-SY
سوريا
Syria
Syria
Syrian Pound
ليرة سوري
ل.س.‏
SYP
SY
SYR
SYR
222
True
EN-BZ
Belize
Belize
Belize
Belize Dollar
Belize Dollar
BZ$
BZD
BZ
BLZ
BLZ
24
True
ES-PE
Perú
Peru
Peru
Peruvian Nuevo Sol
Nuevo Sol
S/.
PEN
PE
PER
PER
187
True
AR-JO
الأردن
Jordan
Jordan
Jordanian Dinar
دينار اردني
د.ا.‏
JOD
JO
JOR
JOR
126
True
EN-TT
Trinidad y Tobago
Trinidad and Tobago
Trinidad and Tobago
Trinidad Dollar
Trinidad Dollar
TT$
TTD
TT
TTO
TTO
225
True
ES-AR
Argentina
Argentina
Argentina
Argentine Peso
Peso
$
ARS
AR
ARG
ARG
11
True
AR-LB
لبنان
Lebanon
Lebanon
Lebanese Pound
ليرة لبناني
ل.ل.‏
LBP
LB
LBN
LBN
139
True
EN-ZW
Zimbabwe
Zimbabwe
Zimbabwe
Zimbabwe Dollar
Zimbabwe Dollar
Z$
ZWD
ZW
ZWE
ZWE
264
False
ES-EC
Ecuador
Ecuador
Ecuador
US Dollar
US Dolar
$
USD
EC
ECU
ECU
66
True
AR-KW
الكويت
Kuwait
Kuwait
Kuwaiti Dinar
دينار كويتي
د.ك.‏
KWD
KW
KWT
KWT
136
True
EN-PH
Philippines
Republic of the Philippines
Republic of the Philippines
Philippine Peso
Philippine Peso
Php
PHP
PH
PHL
PHL
201
False
ES-CL
Chile
Chile
Chile
Chilean Peso
Peso
$
CLP
CL
CHL
CHL
46
True
AR-AE
الإمارات العربية المتحدة
U.A.E.
U.A.E.
UAE Dirham
درهم اماراتي
د.إ.‏
AED
AE
ARE
ARE
224
True
ES-UY
Uruguay
Uruguay
Uruguay
Peso Uruguayo
Peso
$U
UYU
UY
URY
URY
246
True
AR-BH
البحرين
Bahrain
Bahrain
Bahraini Dinar
دينار بحريني
د.ب.‏
BHD
BH
BHR
BHR
17
True
ES-PY
Paraguay
Paraguay
Paraguay
Paraguay Guarani
Guaraní
Gs
PYG
PY
PRY
PRY
185
True
AR-QA
قطر
Qatar
Qatar
Qatari Rial
ريال قطري
ر.ق.‏
QAR
QA
QAT
QAT
197
True
ES-BO
Bolivia
Bolivia
Bolivia
Boliviano
Boliviano
$b
BOB
BO
BOL
BOL
26
True
ES-SV
El Salvador
El Salvador
El Salvador
US Dollar
US Dolar
$
USD
SV
SLV
SLV
72
True
ES-HN
Honduras
Honduras
Honduras
Honduran Lempira
Lempira
L.
HNL
HN
HND
HND
106
True
ES-NI
Nicaragua
Nicaragua
Nicaragua
Nicaraguan Cordoba Oro
Córdoba
C$
NIO
NI
NIC
NIC
182
True
ES-PR
Puerto Rico
Puerto Rico
Puerto Rico
US Dollar
US Dollar
$
USD
PR
PRI
PRI
202
True
SMA-NO
Nöörje
Norway
Norway
Norwegian Krone
kråvnoe
kr
NOK
NO
NOR
NOR
177
True
BN-BD
বাংলাদেশ
Bangladesh
Bangladesh
Bangladeshi Taka
টাকা

BDT
BD
BGD
BGD
23
True
BS-CYRL-BA
Босна и Херцеговина
Bosnia and Herzegovina
Bosnia and Herzegovina
Convertible Marks
конвертибилна марка
КМ
BAM
BA
BIH
BIH
25
True
TG-CYRL-TJ
Тоҷикистон
Tajikistan
Tajikistan
Ruble
рубл
т.р.
TJR
TJ
TAJ
TAJ
228
True
EN-SG
Singapore
Singapore
Singapore
Singapore Dollar
Singapore Dollar
$
SGD
SG
SGP
SGP
215
True
EN-MY
Malaysia
Malaysia
Malaysia
Malaysian Ringgit
Malaysian Ringgit
RM
MYR
MY
MYS
MYS
167
True
MN-MONG-CN
ᠪᠦᠭᠦᠳᠡ ᠨᠠᠢᠷᠠᠮᠳᠠᠬᠤ ᠳᠤᠮᠳᠠᠳᠤ ᠠᠷᠠᠳ ᠣᠯᠣᠰ
People’s Republic of China
People’s Republic of China
PRC Renminbi
ᠠᠷᠠᠳ  ᠤᠨ ᠵᠤᠭᠤᠰ
¥
CNY
CN
CHN
CHN
154
True
PRS-AF
افغانستان
Afghanistan
Afghanistan
Afghani
افغانى
؋
AFA
AF
AFG
AFG
3
True
WO-SN
Sénégal
Senegal
Senegal
XOF Senegal
XOF Senegal
XOF
XOF
SN
SEN
SEN
210
True
RW-RW
Rwanda
Rwanda
Rwanda
Rwandan Franc
Ifaranga
RWF
RWF
RW
RWA
RWA
204
True
QUT-GT
Guatemala
Guatemala
Guatemala
Guatemalan Quetzal
Quetzal
Q
GTQ
GT
GTM
GTM
99
True
SAH-RU
Россия
Russia
Russia
Russian Ruble
солкуобай
с.
RUR
RU
RUS
RUS
203
True
GSW-FR
Frànkrisch
France
France
Euro
euro

EUR
FR
FRA
FRA
84
True
CO-FR
France
France
France
Euro
euro

EUR
FR
FRA
FRA
84
True
RM-CH
Svizra
Switzerland
Switzerland
Swiss Franc
Franc svizzer
fr.
CHF
CH
CHE
CHE
223
True
MI-NZ
Aotearoa
New Zealand
New Zealand
New Zealand Dollar
tāra
$
NZD
NZ
NZL
NZL
183
True
UG-CN
جۇڭخۇا خەلق جۇمھۇرىيىتى
People’s Republic of China
People’s Republic of China
PRC Renminbi
خەلق پۇلى
¥
CNY
CN
CHN
CHN
45
True
BR-FR
Frañs
France
France
Euro
euro

EUR
FR
FRA
FRA
84
True
MOH-CA
Canada
Canada
Canada
Canadian Dollar
Canadian Dollar
$
CAD
CA
CAN
CAN
39
False
ARN-CL
Chile
Chile
Chile
Chilean Peso
Peso
$
CLP
CL
CHL
CHL
46
True
GA-IE
Éire
Ireland
Ireland
Euro
Euro

EUR
IE
IRL
IRL
68
True
II-CN
ꍏꉸꏓꂱꇭꉼꇩ
People’s Republic of China
People’s Republic of China
PRC Renminbi
ꎆꃀ
¥
CNY
CN
CHN
CHN
45
True
SMA-SE
Sveerje
Sweden
Sweden
Swedish Krona
kråvnoe
kr
SEK
SE
SWE
SWE
221
True
SR-LATN-BA
Bosna i Hercegovina
Bosnia and Herzegovina
Bosnia and Herzegovina
Convertible Marks
konvertibilna marka
KM
BAM
BA
BIH
BIH
25
True
QUZ-PE
Peru Suyu
Peru
Peru
Peruvian Nuevo Sol
Nuevo Sol
S/.
PEN
PE
PER
PER
187
True
IG-NG
Nigeria
Nigeria
Nigeria
Nigerian Naira
Naira
N
NIO
NG
NGA
NGA
175
True
KL-GL
Kalaallit Nunaat
Greenland
Greenland
Danish Krone
korunni
kr.
DKK
GL
GRL
GRL
93
True
LB-LU
Luxembourg
Luxembourg
Luxembourg
Euro
euro

EUR
LU
LUX
LUX
147
True
BA-RU
Россия
Russia
Russia
Russian Ruble
һум
һ.
RUR
RU
RUS
RUS
203
True
NSO-ZA
Afrika Borwa
South Africa
South Africa
South African Rand
Rand
R
ZAR
ZA
ZAF
ZAF
209
True
QUZ-BO
Bolivia Suyu
Bolivia
Bolivia
Boliviano
Boliviano
$b
BOB
BO
BOL
BOL
26
True
YO-NG
Nigeria
Nigeria
Nigeria
Nigerian Naira
Naira
N
NIO
NG
NGA
NGA
175
True
SMS-FI
Lää´ddjânnam
Finland
Finland
Euro
euro

EUR
FI
FIN
FIN
77
True
HA-LATN-NG
Nigeria
Nigeria
Nigeria
Nigerian Naira
Naira
N
NIO
NG
NGA
NGA
175
True
HR-BA
Bosna i Hercegovina
Bosnia and Herzegovina
Bosnia and Herzegovina
Convertible Marks
konvertibilna marka
KM
BAM
BA
BIH
BIH
25
True
FIL-PH
Pilipinas
Philippines
Philippines
Philippine Peso
Philippine Peso
PhP
PHP
PH
PHL
PHL
201
False
PS-AF
افغانستان
Afghanistan
Afghanistan
Afghani
افغانى
؋
AFA
AF
AFG
AFG
3
True
FY-NL
Nederlân
Netherlands
Netherlands
Euro
euro

EUR
NL
NLD
NLD
176
True
NE-NP
नेपाल
Nepal
Nepal
Nepalese Rupees
रुपैयाँ
रु
NPR
NP
NEP
NEP
178
True
AM-ET
ኢትዮጵያ
Ethiopia
Ethiopia
Ethiopian Birr
ብር
ETB
ETB
ET
ETH
ETH
73
True
IU-CANS-CA
ᑲᓇᑕ
Canada
Canada
Canadian Dollar
ᑲᓇᑕᐅᑉᑮᓇᐅᔭᖕᒐ
$
CAD
CA
CAN
CAN
39
True
QUZ-EC
Ecuador Suyu
Ecuador
Ecuador
US Dollar
US Dolar
$
USD
EC
ECU
ECU
66
True
SI-LK
ශ්‍රී ලංකා
Sri Lanka
Sri Lanka
Sri Lanka Rupee
රුපියල්
රු.
LKR
LK
LKA
LKA
42
True
SMJ-SE
Svierik
Sweden
Sweden
Swedish Krona
kråvnnå
kr
SEK
SE
SWE
SWE
221
True
LO-LA
ສ.ປ.ປ. ລາວ
Lao P.D.R.
Lao P.D.R.
Kip
ກີບ

Kip
LA
LAO
LAO
138
True
KM-KH
កម្ពុជា
Cambodia
Cambodia
Riel
x179Aៀល

KHR
KH
KHM
KHM
40
True
CY-GB
y Deyrnas Unedig
United Kingdom
United Kingdom
UK Pound Sterling
UK Pound Sterling
£
GBP
GB
GBR
GBR
242
True
BO-CN
ཀྲུང་ཧྭ་མི་དམངས་སྤྱི་མཐུན་རྒྱལ་ཁབ།
People’s Republic of China
People’s Republic of China
PRC Renminbi
མི་དམངས་ཤོག་སྒོཪ།
¥
CNY
CN
CHN
CHN
45
True
SE-SE
Ruoŧŧa
Sweden
Sweden
Swedish Krona
kruvdno
kr
SEK
SE
SWE
SWE
221
True
SMJ-NO
Vuodna
Norway
Norway
Norwegian Krone
kråvnnå
kr
NOK
NO
NOR
NOR
177
True
AS-IN
ভাৰত
India
India
Indian Rupee
টকা

INR
IN
IND
IND
113
True
ML-IN
ഭാരതം
India
India
Indian Rupee
രൂപ

INR
IN
IND
IND
113
True
SE-FI
Suopma
Finland
Finland
Euro
euro

EUR
FI
FIN
FIN
77
True
OR-IN
ଭାରତ
India
India
Indian Rupee
ଟଙ୍କା

INR
IN
IND
IND
113
True
SR-CYRL-BA
Босна и Херцеговина
Bosnia and Herzegovina
Bosnia and Herzegovina
Convertible Marks
конвертибилна марка
КМ
BAM
BA
BIH
BIH
25
True
BN-IN
ভারত
India
India
Indian Rupee
টাকা
টা
INR
IN
IND
IND
113
True
EN-IN
India
India
India
Indian Rupee;
Rupee;
Rs.
INR
IN
IND
IND
113
True
DSB-DE
Nimska
Germany
Germany
Euro
Euro

EUR
DE
DEU
GER
94
True
TK-TM
Türkmenistan
Turkmenistan
Turkmenistan
Turkmen manat
manat
m.
TMM
TM
TKM
TKM
238
True
SMN-FI
Suomâ
Finland
Finland
Euro
evro

EUR
FI
FIN
FIN
77
True
OC-FR
França
France
France
Euro
euro

EUR
FR
FRA
FRA
84
True
ES-US
Estados Unidos
United States
United States
US Dollar
Dólar de EE.UU.
$
USD
US
USA
USA
244
False
SE-NO
Norga
Norway
Norway
Norwegian Krone
kruvdno
kr
NOK
NO
NOR
NOR
177
True
MT-MT
Malta
Malta
Malta
Maltese Lira
Lira Maltija
Lm
MTL
MT
MLT
MLT
163
True
BS-LATN-BA
Bosna i Hercegovina
Bosnia and Herzegovina
Bosnia and Herzegovina
Convertible Marks
konvertibilna marka
KM
BAM
BA
BIH
BIH
25
True
ZU-ZA
iNingizimu Afrika
South Africa
South Africa
South African Rand
Rand
R
ZAR
ZA
ZAF
ZAF
209
True
XH-ZA
uMzantsi Afrika
South Africa
South Africa
South African Rand
Rand
R
ZAR
ZA
ZAF
ZAF
209
True
TN-ZA
Aforika Borwa
South Africa
South Africa
South African Rand
Rand
R
ZAR
ZA
ZAF
ZAF
209
True
TZM-LATN-DZ
Djazaïr
Algeria
Algeria
Algerian Dinar
Dinar
DZD
DZD
DZ
DZA
DZA
4
True
IU-LATN-CA
kanata
Canada
Canada
Canadian Dollar
Kanataup Kiinaujanga;
$
CAD
CA
CAN
CAN
39
True
HSB-DE
Němska
Germany
Germany
Euro
Euro

EUR
DE
DEU
GER
94
True

UseCase include and extend

June 25, 2008
UseCase include and extend magnify
To know exactly what are included and and extended relationship in Use Case diagram, I post this blog for you. I’d like to say thank you to 2 my bro, who are experts in this field.