標簽：mongo 匈牙利 aos 分享 hana public 哥倫比亞 blog pen
DROP TABLE sp_countries CREATE TABLE sp_countries( id INT NOT NULL IDENTITY(1,1) PRIMARY KEY, zh_name NVARCHAR(100) NULL, en_name NVARCHAR(100) NULL, code NVARCHAR(50) NULL, parent_code INT NULL ) SELECT * FROM sp_countries INSERT INTO sp_countries (zh_name, code) VALUES (‘阿爾巴尼亞‘, ‘ALB‘), (‘阿爾及利亞‘, ‘DZA‘), (‘阿富汗‘, ‘AFG‘), (‘阿根廷‘, ‘ARG‘), (‘阿拉伯聯合酋長國‘, ‘ARE‘), (‘阿魯巴‘, ‘ABW‘), (‘阿曼‘, ‘OMN‘), (‘阿塞拜疆‘, ‘AZE‘), (‘阿森松島‘, ‘ASC‘), (‘埃及‘, ‘EGY‘), (‘埃塞俄比亞‘, ‘ETH‘), (‘愛爾蘭‘, ‘IRL‘), (‘愛沙尼亞‘, ‘EST‘), (‘安道爾‘, ‘AND‘), (‘安哥拉‘, ‘AGO‘), (‘安圭拉‘, ‘AIA‘), (‘安提瓜島和巴布達‘, ‘ATG‘), (‘奧地利‘, ‘AUT‘), (‘奧蘭群島‘, ‘ALA‘), (‘澳大利亞‘, ‘AUS‘), (‘巴巴多斯島‘, ‘BRB‘), (‘巴布亞新幾內亞‘, ‘PNG‘), (‘巴哈馬‘, ‘BHS‘), (‘巴基斯坦‘, ‘PAK‘), (‘巴拉圭‘, ‘PRY‘), (‘巴勒斯坦‘, ‘PSE‘), (‘巴林‘, ‘BHR‘), (‘巴拿馬‘, ‘PAN‘), (‘巴西‘, ‘BRA‘), (‘白俄羅斯‘, ‘BLR‘), (‘百慕大‘, ‘BMU‘), (‘保加利亞‘, ‘BGR‘), (‘北馬裏亞納群島‘, ‘MNP‘), (‘貝甯‘, ‘BEN‘), (‘比利時‘, ‘BEL‘), (‘冰島‘, ‘ISL‘), (‘波多黎各‘, ‘PRI‘), (‘波蘭‘, ‘POL‘), (‘波斯尼亞和黑塞哥維那‘, ‘BIH‘), (‘玻利維亞‘, ‘BOL‘), (‘伯利茲‘, ‘BLZ‘), (‘博茨瓦納‘, ‘BWA‘), (‘不丹‘, ‘BTN‘), (‘布基納法索‘, ‘BFA‘), (‘布隆迪‘, ‘BDI‘), (‘布韋島‘, ‘BVT‘), (‘朝鮮‘, ‘PRK‘), (‘丹麥‘, ‘DNK‘), (‘德國‘, ‘DEU‘), (‘東帝汶‘, ‘TLS‘), (‘多哥‘, ‘TGO‘), (‘多米尼加‘, ‘DMA‘), (‘多米尼加共和國‘, ‘DOM‘), (‘俄羅斯‘, ‘RUS‘), (‘厄瓜多爾‘, ‘ECU‘), (‘厄立特裏亞‘, ‘ERI‘), (‘法國‘, ‘FRA‘), (‘法羅群島‘, ‘FRO‘), (‘法屬波利尼西亞‘, ‘PYF‘), (‘法屬圭亞那‘, ‘GUF‘), (‘法屬南部領地‘, ‘ATF‘), (‘梵蒂岡‘, ‘VAT‘), (‘菲律賓‘, ‘PHL‘), (‘斐濟‘, ‘FJI‘), (‘芬蘭‘, ‘FIN‘), (‘佛得角‘, ‘CPV‘), (‘弗蘭克群島‘, ‘FLK‘), (‘岡比亞‘, ‘GMB‘), (‘剛果‘, ‘COG‘), (‘剛果民主共和国‘, ‘COD‘), (‘哥倫比亞‘, ‘COL‘), (‘哥斯達黎加‘, ‘CRI‘), (‘格恩西島‘, ‘GGY‘), (‘格林納達‘, ‘GRD‘), (‘格陵蘭‘, ‘GRL‘), (‘古巴‘, ‘CUB‘), (‘瓜德羅普‘, ‘GLP‘), (‘關島‘, ‘GUM‘), (‘圭亞那‘, ‘GUY‘), (‘哈薩克斯坦‘, ‘KAZ‘), (‘海地‘, ‘HTI‘), (‘韓國‘, ‘KOR‘), (‘荷蘭‘, ‘NLD‘), (‘荷屬安地列斯‘, ‘ANT‘), (‘赫德和麥克唐納群島‘, ‘HMD‘), (‘洪都拉斯‘, ‘HND‘), (‘基裏巴斯‘, ‘KIR‘), (‘吉布提‘, ‘DJI‘), (‘吉爾吉斯斯坦‘, ‘KGZ‘), (‘幾內亞‘, ‘GIN‘), (‘幾內亞比绍‘, ‘GNB‘), (‘加拿大‘, ‘CAN‘), (‘加納‘, ‘GHA‘), (‘加蓬‘, ‘GAB‘), (‘柬埔寨‘, ‘KHM‘), (‘捷克共和國‘, ‘CZE‘), (‘津巴布韋‘, ‘ZWE‘), (‘喀麥隆‘, ‘CMR‘), ( ‘卡塔爾‘, ‘QAT‘), ( ‘開曼群島‘, ‘CYM‘), ( ‘科科斯群島‘, ‘CCK‘), ( ‘科摩羅‘, ‘COM‘), ( ‘科特迪瓦‘, ‘CIV‘), ( ‘科威特‘, ‘KWT‘), ( ‘克羅地亞‘, ‘HRV‘), ( ‘肯尼亞‘, ‘KEN‘), ( ‘庫克群島‘, ‘COK‘), ( ‘拉脫維亞‘, ‘LVA‘), ( ‘萊索托‘, ‘LSO‘), ( ‘老撾‘, ‘LAO‘), ( ‘黎巴嫩‘, ‘LBN‘), ( ‘立陶宛‘, ‘LTU‘), ( ‘利比裏亞‘, ‘LBR‘), ( ‘利比亞‘, ‘LBY‘), ( ‘列支敦士登‘, ‘LIE‘), ( ‘留尼旺島‘, ‘REU‘), ( ‘盧森堡‘, ‘LUX‘), ( ‘盧旺達‘, ‘RWA‘), ( ‘羅馬尼亞‘, ‘ROU‘), ( ‘馬達加斯加‘, ‘MDG‘), ( ‘馬爾代夫‘, ‘MDV‘), ( ‘馬耳他‘, ‘MLT‘), ( ‘馬拉維‘, ‘MWI‘), ( ‘馬來西亞‘, ‘MYS‘), ( ‘馬裏‘, ‘MLI‘), ( ‘馬其頓‘, ‘MKD‘), ( ‘馬紹爾群島‘, ‘MHL‘), ( ‘馬提尼克‘, ‘MTQ‘), ( ‘馬約特島‘, ‘MYT‘), ( ‘曼島‘, ‘IMN‘), ( ‘毛裏求斯‘, ‘MUS‘), ( ‘毛裏塔尼亞‘, ‘MRT‘), ( ‘美國‘, ‘USA‘), ( ‘美屬薩摩亞‘, ‘ASM‘), ( ‘美屬外島‘, ‘UMI‘), ( ‘蒙古‘, ‘MNG‘), ( ‘蒙特塞拉特‘, ‘MSR‘), ( ‘孟加拉‘, ‘BGD‘), ( ‘秘魯‘, ‘PER‘), ( ‘密克羅尼西亞‘, ‘FSM‘), ( ‘緬甸‘, ‘MMR‘), ( ‘摩爾多瓦‘, ‘MDA‘), ( ‘摩洛哥‘, ‘MAR‘), ( ‘摩納哥‘, ‘MCO‘), ( ‘莫桑比克‘, ‘MOZ‘), ( ‘墨西哥‘, ‘MEX‘), ( ‘納米比亞‘, ‘NAM‘), ( ‘南非‘, ‘ZAF‘), ( ‘南極洲‘, ‘ATA‘), ( ‘南喬治亞和南桑德威奇群島‘, ‘SGS‘), ( ‘瑙魯‘, ‘NRU‘), ( ‘尼泊爾‘, ‘NPL‘), ( ‘尼加拉瓜‘, ‘NIC‘), ( ‘尼日爾‘, ‘NER‘), ( ‘尼日利亞‘, ‘NGA‘), ( ‘紐埃‘, ‘NIU‘), ( ‘挪威‘, ‘NOR‘), ( ‘諾福克‘, ‘NFK‘), ( ‘帕勞群島‘, ‘PLW‘), ( ‘皮特凱恩‘, ‘PCN‘), ( ‘葡萄牙‘, ‘PRT‘), ( ‘喬治亞‘, ‘GEO‘), ( ‘日本‘, ‘JPN‘), ( ‘瑞典‘, ‘SWE‘), ( ‘瑞士‘, ‘CHE‘), ( ‘薩爾瓦多‘, ‘SLV‘), ( ‘薩摩亞‘, ‘WSM‘), ( ‘塞爾維亞,黑山‘, ‘SCG‘), ( ‘塞拉利昂‘, ‘SLE‘), ( ‘塞內加爾‘, ‘SEN‘), ( ‘塞浦路斯‘, ‘CYP‘), ( ‘塞舌爾‘, ‘SYC‘), ( ‘沙特阿拉伯‘, ‘SAU‘), ( ‘聖誕島‘, ‘CXR‘), ( ‘聖多美和普林西比‘, ‘STP‘), ( ‘聖赫勒拿‘, ‘SHN‘), ( ‘聖基茨和尼維斯‘, ‘KNA‘), ( ‘聖盧西亞‘, ‘LCA‘), ( ‘聖馬力諾‘, ‘SMR‘), ( ‘聖皮埃爾和米克隆群島‘, ‘SPM‘), ( ‘聖文森特和格林納丁斯‘, ‘VCT‘), ( ‘斯裏蘭卡‘, ‘LKA‘), ( ‘斯洛伐克‘, ‘SVK‘), ( ‘斯洛文尼亞‘, ‘SVN‘), ( ‘斯瓦爾巴和揚馬廷‘, ‘SJM‘), ( ‘斯威士蘭‘, ‘SWZ‘), ( ‘蘇丹‘, ‘SDN‘), ( ‘蘇裏南‘, ‘SUR‘), ( ‘所羅門群島‘, ‘SLB‘), ( ‘索馬裏‘, ‘SOM‘), ( ‘塔吉克斯坦‘, ‘TJK‘), ( ‘泰國‘, ‘THA‘), ( ‘坦桑尼亞‘, ‘TZA‘), ( ‘湯加‘, ‘TON‘), ( ‘特克斯和凱克特斯群島‘, ‘TCA‘), ( ‘特裏斯坦達昆哈‘, ‘TAA‘), ( ‘特立尼達和多巴哥‘, ‘TTO‘), ( ‘突尼斯‘, ‘TUN‘), ( ‘圖瓦盧‘, ‘TUV‘), ( ‘土耳其‘, ‘TUR‘), ( ‘土庫曼斯坦‘, ‘TKM‘), ( ‘托克勞‘, ‘TKL‘), ( ‘瓦利斯和福圖納‘, ‘WLF‘), ( ‘瓦努阿圖‘, ‘VUT‘), ( ‘危地馬拉‘, ‘GTM‘), ( ‘維爾京群島，美屬‘, ‘VIR‘), ( ‘維爾京群島，英屬‘, ‘VGB‘), ( ‘委內瑞拉‘, ‘VEN‘), ( ‘文萊‘, ‘BRN‘), ( ‘烏幹達‘, ‘UGA‘), ( ‘烏克蘭‘, ‘UKR‘), ( ‘烏拉圭‘, ‘URY‘), ( ‘烏茲別克斯坦‘, ‘UZB‘), ( ‘西班牙‘, ‘ESP‘), ( ‘希臘‘, ‘GRC‘), ( ‘新加坡‘, ‘SGP‘), ( ‘新喀裏多尼亞‘, ‘NCL‘), ( ‘新西蘭‘, ‘NZL‘), ( ‘匈牙利‘, ‘HUN‘), ( ‘敘利亞‘, ‘SYR‘), ( ‘牙買加‘, ‘JAM‘), ( ‘亞美尼亞‘, ‘ARM‘), ( ‘也門‘, ‘YEM‘), ( ‘伊拉克‘, ‘IRQ‘), ( ‘伊朗‘, ‘IRN‘), ( ‘以色列‘, ‘ISR‘), ( ‘意大利‘, ‘ITA‘), ( ‘印度‘, ‘IND‘), ( ‘印度尼西亞‘, ‘IDN‘), ( ‘英國‘, ‘GBR‘), ( ‘英屬印度洋領地‘, ‘IOT‘), ( ‘約旦‘, ‘JOR‘), ( ‘越南‘, ‘VNM‘), ( ‘贊比亞‘, ‘ZMB‘), ( ‘澤西島‘, ‘JEY‘), ( ‘乍得‘, ‘TCD‘), ( ‘直布羅陀‘, ‘GIB‘), ( ‘智利‘, ‘CHL‘), (‘中國‘, ‘PRC‘), ( ‘中非共和國‘, ‘CAF‘);
USE [Standard_RichData3] GO /****** Object: Table [dbo].[sp_countries] Script Date: 08/31/2017 11:46:26 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[sp_countries]( [id] [int] IDENTITY(1,1) NOT NULL, [zh_name] [nvarchar](300) NULL, [en_name] [nvarchar](300) NULL, [code] [nvarchar](300) NULL, [parent_code] [int] NULL, CONSTRAINT [PK__sp_count__3213E83F123F82FA] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET IDENTITY_INSERT [dbo].[sp_countries] ON INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (1, N‘阿爾巴尼亞‘, N‘Albania‘, N‘ALB‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (2, N‘阿爾及利亞‘, N‘Algeria‘, N‘DZA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (3, N‘阿富汗‘, N‘Afghanistan‘, N‘AFG‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (4, N‘阿根廷‘, N‘Argentina‘, N‘ARG‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (5, N‘阿拉伯聯合酋長國‘, N‘The United Arab Emirates‘, N‘ARE‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (6, N‘阿魯巴‘, N‘Aruba‘, N‘ABW‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (7, N‘阿曼‘, N‘Oman‘, N‘OMN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (8, N‘阿塞拜疆‘, N‘Azerbaijan‘, N‘AZE‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (9, N‘阿森松島‘, N‘Ascension‘, N‘ASC‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (10, N‘埃及‘, N‘Egypt‘, N‘EGY‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (11, N‘埃塞俄比亞‘, N‘Ethiopia‘, N‘ETH‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (12, N‘愛爾蘭‘, N‘Ireland‘, N‘IRL‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (13, N‘愛沙尼亞‘, N‘Estonia‘, N‘EST‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (14, N‘安道爾‘, N‘Andorra‘, N‘AND‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (15, N‘安哥拉‘, N‘Angola‘, N‘AGO‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (16, N‘安圭拉‘, N‘Anguilla‘, N‘AIA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (17, N‘安提瓜島和巴布達‘, N‘Antigua and Barbuda‘, N‘ATG‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (18, N‘奧地利‘, N‘Austria‘, N‘AUT‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (19, N‘奧蘭群島‘, N‘Oran Islands‘, N‘ALA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (20, N‘澳大利亞‘, N‘Australia‘, N‘AUS‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (21, N‘巴巴多斯島‘, N‘Barbados‘, N‘BRB‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (22, N‘巴布亞新幾內亞‘, N‘papua new guinea‘, N‘PNG‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (23, N‘巴哈馬‘, N‘Bahamas‘, N‘BHS‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (24, N‘巴基斯坦‘, N‘Pakistan‘, N‘PAK‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (25, N‘巴拉圭‘, N‘Paraguay‘, N‘PRY‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (26, N‘巴勒斯坦‘, N‘Palestine‘, N‘PSE‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (27, N‘巴林‘, N‘Bahrain‘, N‘BHR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (28, N‘巴拿馬‘, N‘Panama‘, N‘PAN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (29, N‘巴西‘, N‘Brazil‘, N‘BRA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (30, N‘白俄羅斯‘, N‘Belarus‘, N‘BLR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (31, N‘百慕大‘, N‘Bermuda‘, N‘BMU‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (32, N‘保加利亞‘, N‘Bulgaria‘, N‘BGR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (33, N‘北馬裏亞納群島‘, N‘Northern Mariana Islands‘, N‘MNP‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (34, N‘貝甯‘, N‘Benin‘, N‘BEN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (35, N‘比利時‘, N‘Belgium‘, N‘BEL‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (36, N‘冰島‘, N‘Iceland‘, N‘ISL‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (37, N‘波多黎各‘, N‘Puerto Rico‘, N‘PRI‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (38, N‘波蘭‘, N‘poland‘, N‘POL‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (39, N‘波斯尼亞和黑塞哥維那‘, N‘Bosnia and Herzegovina‘, N‘BIH‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (40, N‘玻利維亞‘, N‘bolivia‘, N‘BOL‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (41, N‘伯利茲‘, N‘Belize‘, N‘BLZ‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (42, N‘博茨瓦納‘, N‘botswana‘, N‘BWA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (43, N‘不丹‘, N‘Bhutan‘, N‘BTN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (44, N‘布基納法索‘, N‘burkina faso‘, N‘BFA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (45, N‘布隆迪‘, N‘burundi‘, N‘BDI‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (46, N‘布韋島‘, N‘Bouvet Island‘, N‘BVT‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (47, N‘朝鮮‘, N‘North Korea‘, N‘PRK‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (48, N‘丹麥‘, N‘Denmark‘, N‘DNK‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (49, N‘德國‘, N‘Germany‘, N‘DEU‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (50, N‘東帝汶‘, N‘Timor-Leste‘, N‘TLS‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (51, N‘多哥‘, N‘Togo‘, N‘TGO‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (52, N‘多米尼加‘, N‘Dominican‘, N‘DMA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (53, N‘多米尼加共和國‘, N‘Dominican Republic‘, N‘DOM‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (54, N‘俄羅斯‘, N‘Russia‘, N‘RUS‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (55, N‘厄瓜多爾‘, N‘Ecuador‘, N‘ECU‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (56, N‘厄立特裏亞‘, N‘Eritrea‘, N‘ERI‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (57, N‘法國‘, N‘France‘, N‘FRA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (58, N‘法羅群島‘, N‘Faroe Islands‘, N‘FRO‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (59, N‘法屬波利尼西亞‘, N‘French Polynesia‘, N‘PYF‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (60, N‘法屬圭亞那‘, N‘French Guiana‘, N‘GUF‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (61, N‘法屬南部領地‘, N‘French Southern Territories‘, N‘ATF‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (62, N‘梵蒂岡‘, N‘Vatican‘, N‘VAT‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (63, N‘菲律賓‘, N‘The Philippines‘, N‘PHL‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (64, N‘斐濟‘, N‘Fiji‘, N‘FJI‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (65, N‘芬蘭‘, N‘Finland‘, N‘FIN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (66, N‘佛得角‘, N‘Cape Verde‘, N‘CPV‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (67, N‘弗蘭克群島‘, N‘Frank Islands‘, N‘FLK‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (68, N‘岡比亞‘, N‘Gambia‘, N‘GMB‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (69, N‘剛果‘, N‘Congo‘, N‘COG‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (70, N‘剛果民主共和国‘, N‘Democratic Republic of Congo‘, N‘COD‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (71, N‘哥倫比亞‘, N‘Columbia‘, N‘COL‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (72, N‘哥斯達黎加‘, N‘Costa Rica‘, N‘CRI‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (73, N‘格恩西島‘, N‘guernsey‘, N‘GGY‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (74, N‘格林納達‘, N‘Grenada‘, N‘GRD‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (75, N‘格陵蘭‘, N‘Greenland‘, N‘GRL‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (76, N‘古巴‘, N‘Cuba‘, N‘CUB‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (77, N‘瓜德羅普‘, N‘Gua de Ropp‘, N‘GLP‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (78, N‘關島‘, N‘Guam‘, N‘GUM‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (79, N‘圭亞那‘, N‘Guyana‘, N‘GUY‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (80, N‘哈薩克斯坦‘, N‘Kazakhstan‘, N‘KAZ‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (81, N‘海地‘, N‘Haiti‘, N‘HTI‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (82, N‘韓國‘, N‘The Republic of Korea‘, N‘KOR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (83, N‘荷蘭‘, N‘Netherlands‘, N‘NLD‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (84, N‘荷屬安地列斯‘, N‘netherlands antilles‘, N‘ANT‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (85, N‘赫德和麥克唐納群島‘, N‘Heard And Mcdonald Islands‘, N‘HMD‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (86, N‘洪都拉斯‘, N‘Honduras‘, N‘HND‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (87, N‘基裏巴斯‘, N‘Kiribati‘, N‘KIR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (88, N‘吉布提‘, N‘Djibouti‘, N‘DJI‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (89, N‘吉爾吉斯斯坦‘, N‘Kyrgyzstan‘, N‘KGZ‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (90, N‘幾內亞‘, N‘Guinea‘, N‘GIN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (91, N‘幾內亞比绍‘, N‘Guinea-Bissau‘, N‘GNB‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (92, N‘加拿大‘, N‘Canada‘, N‘CAN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (93, N‘加納‘, N‘Ghana‘, N‘GHA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (94, N‘加蓬‘, N‘Gabon‘, N‘GAB‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (95, N‘柬埔寨‘, N‘Cambodia‘, N‘KHM‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (96, N‘捷克共和國‘, N‘Czech Republic‘, N‘CZE‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (97, N‘津巴布韋‘, N‘zimbabwe‘, N‘ZWE‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (98, N‘喀麥隆‘, N‘Cameroon‘, N‘CMR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (99, N‘卡塔爾‘, N‘Qatar‘, N‘QAT‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (100, N‘開曼群島‘, N‘Cayman Islands‘, N‘CYM‘, NULL) GO print ‘Processed 100 total records‘ INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (101, N‘科科斯群島‘, N‘Cocos Islands‘, N‘CCK‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (102, N‘科摩羅‘, N‘Comoros‘, N‘COM‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (103, N‘科特迪瓦‘, N‘Cote d‘‘Ivoire‘, N‘CIV‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (104, N‘科威特‘, N‘Kuwait‘, N‘KWT‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (105, N‘克羅地亞‘, N‘Croatia‘, N‘HRV‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (106, N‘肯尼亞‘, N‘Kenya‘, N‘KEN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (107, N‘庫克群島‘, N‘Cook Islands‘, N‘COK‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (108, N‘拉脫維亞‘, N‘Latvia‘, N‘LVA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (109, N‘萊索托‘, N‘Lesotho‘, N‘LSO‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (110, N‘老撾‘, N‘Laos‘, N‘LAO‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (111, N‘黎巴嫩‘, N‘Lebanon‘, N‘LBN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (112, N‘立陶宛‘, N‘Lithuania‘, N‘LTU‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (113, N‘利比裏亞‘, N‘Liberia‘, N‘LBR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (114, N‘利比亞‘, N‘Libya‘, N‘LBY‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (115, N‘列支敦士登‘, N‘Liechtenstein‘, N‘LIE‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (116, N‘留尼旺島‘, N‘Reunion‘, N‘REU‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (117, N‘盧森堡‘, N‘Luxembourg‘, N‘LUX‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (118, N‘盧旺達‘, N‘Rwanda‘, N‘RWA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (119, N‘羅馬尼亞‘, N‘Romania‘, N‘ROU‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (120, N‘馬達加斯加‘, N‘Madagascar‘, N‘MDG‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (121, N‘馬爾代夫‘, N‘Maldives‘, N‘MDV‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (122, N‘馬耳他‘, N‘Malta‘, N‘MLT‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (123, N‘馬拉維‘, N‘Malawi‘, N‘MWI‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (124, N‘馬來西亞‘, N‘Malaysia‘, N‘MYS‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (125, N‘馬裏‘, N‘Mali‘, N‘MLI‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (126, N‘馬其頓‘, N‘Macedonia‘, N‘MKD‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (127, N‘馬紹爾群島‘, N‘Marshall Islands‘, N‘MHL‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (128, N‘馬提尼克‘, N‘Martinique‘, N‘MTQ‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (129, N‘馬約特島‘, N‘Mayotte‘, N‘MYT‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (130, N‘曼島‘, N‘The Isle of man‘, N‘IMN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (131, N‘毛裏求斯‘, N‘Mauritius‘, N‘MUS‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (132, N‘毛裏塔尼亞‘, N‘Mauritania‘, N‘MRT‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (133, N‘美國‘, N‘U.S.A‘, N‘USA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (134, N‘美屬薩摩亞‘, N‘American Samoa‘, N‘ASM‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (135, N‘美屬外島‘, N‘The outlying islands‘, N‘UMI‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (136, N‘蒙古‘, N‘Mongolia‘, N‘MNG‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (137, N‘蒙特塞拉特‘, N‘Montserrat‘, N‘MSR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (138, N‘孟加拉‘, N‘Bengal‘, N‘BGD‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (139, N‘秘魯‘, N‘Peru‘, N‘PER‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (140, N‘密克羅尼西亞‘, N‘Micronesia‘, N‘FSM‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (141, N‘緬甸‘, N‘Myanmar‘, N‘MMR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (142, N‘摩爾多瓦‘, N‘Moldova‘, N‘MDA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (143, N‘摩洛哥‘, N‘Morocco‘, N‘MAR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (144, N‘摩納哥‘, N‘Monaco‘, N‘MCO‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (145, N‘莫桑比克‘, N‘Mozambique‘, N‘MOZ‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (146, N‘墨西哥‘, N‘Mexico‘, N‘MEX‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (147, N‘納米比亞‘, N‘Namibia‘, N‘NAM‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (148, N‘南非‘, N‘South Africa‘, N‘ZAF‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (149, N‘南極洲‘, N‘Antarctica‘, N‘ATA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (150, N‘南喬治亞和南桑德威奇群島‘, N‘South Georgia and the South Sandwich Islands‘, N‘SGS‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (151, N‘瑙魯‘, N‘Nauru‘, N‘NRU‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (152, N‘尼泊爾‘, N‘Nepal‘, N‘NPL‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (153, N‘尼加拉瓜‘, N‘Nicaragua‘, N‘NIC‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (154, N‘尼日爾‘, N‘Niger‘, N‘NER‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (155, N‘尼日利亞‘, N‘Nigeria‘, N‘NGA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (156, N‘紐埃‘, N‘Niue‘, N‘NIU‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (157, N‘挪威‘, N‘Norway‘, N‘NOR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (158, N‘諾福克‘, N‘Norfolk‘, N‘NFK‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (159, N‘帕勞群島‘, N‘Palau‘, N‘PLW‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (160, N‘皮特凱恩‘, N‘Pitcairn‘, N‘PCN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (161, N‘葡萄牙‘, N‘Portugal‘, N‘PRT‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (162, N‘喬治亞‘, N‘Georgia‘, N‘GEO‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (163, N‘日本‘, N‘Japan‘, N‘JPN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (164, N‘瑞典‘, N‘Sweden‘, N‘SWE‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (165, N‘瑞士‘, N‘Switzerland‘, N‘CHE‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (166, N‘薩爾瓦多‘, N‘Salvatore‘, N‘SLV‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (167, N‘薩摩亞‘, N‘Samoa‘, N‘WSM‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (168, N‘塞爾維亞,黑山‘, N‘Montenegro, Serbia‘, N‘SCG‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (169, N‘塞拉利昂‘, N‘sierra leone‘, N‘SLE‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (170, N‘塞內加爾‘, N‘Senegal‘, N‘SEN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (171, N‘塞浦路斯‘, N‘Cyprus‘, N‘CYP‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (172, N‘塞舌爾‘, N‘Seychelles‘, N‘SYC‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (173, N‘沙特阿拉伯‘, N‘Saudi Arabia‘, N‘SAU‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (174, N‘聖誕島‘, N‘Christmas Island‘, N‘CXR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (175, N‘聖多美和普林西比‘, N‘Sao Tome and Principe‘, N‘STP‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (176, N‘聖赫勒拿‘, N‘Helena‘, N‘SHN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (177, N‘聖基茨和尼維斯‘, N‘Saint Kitts and Nevis‘, N‘KNA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (178, N‘聖盧西亞‘, N‘Saint Lucia‘, N‘LCA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (179, N‘聖馬力諾‘, N‘San Marino‘, N‘SMR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (180, N‘聖皮埃爾和米克隆群島‘, N‘San Pierre and M Islands‘, N‘SPM‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (181, N‘聖文森特和格林納丁斯‘, N‘Saint Vincent and the Grenadines‘, N‘VCT‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (182, N‘斯裏蘭卡‘, N‘Sri Lanka‘, N‘LKA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (183, N‘斯洛伐克‘, N‘Slovakia‘, N‘SVK‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (184, N‘斯洛文尼亞‘, N‘Slovenia‘, N‘SVN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (185, N‘斯瓦爾巴和揚馬廷‘, N‘J Val Ba and Yang Ting Ting‘, N‘SJM‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (186, N‘斯威士蘭‘, N‘Swaziland‘, N‘SWZ‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (187, N‘蘇丹‘, N‘Sultan‘, N‘SDN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (188, N‘蘇裏南‘, N‘Suriname‘, N‘SUR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (189, N‘所羅門群島‘, N‘Solomon Islands‘, N‘SLB‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (190, N‘索馬裏‘, N‘Somalia‘, N‘SOM‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (191, N‘塔吉克斯坦‘, N‘Tajikistan‘, N‘TJK‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (192, N‘泰國‘, N‘Thailand‘, N‘THA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (193, N‘坦桑尼亞‘, N‘Tanzania‘, N‘TZA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (194, N‘湯加‘, N‘Tonga‘, N‘TON‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (195, N‘特克斯和凱克特斯群島‘, N‘The Turks and Kaiketesi Islands‘, N‘TCA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (196, N‘特裏斯坦達昆哈‘, N‘Tristan Da khuon ha‘, N‘TAA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (197, N‘特立尼達和多巴哥‘, N‘Trinidad and Tobago‘, N‘TTO‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (198, N‘突尼斯‘, N‘Tunisia‘, N‘TUN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (199, N‘圖瓦盧‘, N‘Tuvalu‘, N‘TUV‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (200, N‘土耳其‘, N‘Turkey‘, N‘TUR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (201, N‘土庫曼斯坦‘, N‘Turkmenistan‘, N‘TKM‘, NULL) GO print ‘Processed 200 total records‘ INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (202, N‘托克勞‘, N‘Tokelau‘, N‘TKL‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (203, N‘瓦利斯和福圖納‘, N‘Wallis and Futuna‘, N‘WLF‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (204, N‘瓦努阿圖‘, N‘Vanuatu‘, N‘VUT‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (205, N‘危地馬拉‘, N‘Guatemala‘, N‘GTM‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (206, N‘維爾京群島，美屬‘, N‘Virgin Islands, American‘, N‘VIR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (207, N‘維爾京群島，英屬‘, N‘Virgin Islands, British‘, N‘VGB‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (208, N‘委內瑞拉‘, N‘Venezuela‘, N‘VEN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (209, N‘文萊‘, N‘Brunei‘, N‘BRN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (210, N‘烏幹達‘, N‘Uganda‘, N‘UGA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (211, N‘烏克蘭‘, N‘Ukraine‘, N‘UKR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (212, N‘烏拉圭‘, N‘Uruguay‘, N‘URY‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (213, N‘烏茲別克斯坦‘, N‘Uzbekistan‘, N‘UZB‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (214, N‘西班牙‘, N‘Spain‘, N‘ESP‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (215, N‘希臘‘, N‘Greece‘, N‘GRC‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (216, N‘新加坡‘, N‘Singapore‘, N‘SGP‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (217, N‘新喀裏多尼亞‘, N‘New Caledonia‘, N‘NCL‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (218, N‘新西蘭‘, N‘New Zealand‘, N‘NZL‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (219, N‘匈牙利‘, N‘Hungary‘, N‘HUN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (220, N‘敘利亞‘, N‘Syria‘, N‘SYR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (221, N‘牙買加‘, N‘Jamaica‘, N‘JAM‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (222, N‘亞美尼亞‘, N‘Armenia‘, N‘ARM‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (223, N‘也門‘, N‘Yemen‘, N‘YEM‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (224, N‘伊拉克‘, N‘Iraq‘, N‘IRQ‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (225, N‘伊朗‘, N‘Iran‘, N‘IRN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (226, N‘以色列‘, N‘Israel‘, N‘ISR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (227, N‘意大利‘, N‘Italy‘, N‘ITA‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (228, N‘印度‘, N‘India‘, N‘IND‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (229, N‘印度尼西亞‘, N‘Indonesia‘, N‘IDN‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (230, N‘英國‘, N‘Britain‘, N‘GBR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (231, N‘英屬印度洋領地‘, N‘British India Ocean Territory‘, N‘IOT‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (232, N‘約旦‘, N‘Jordan‘, N‘JOR‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (233, N‘越南‘, N‘Vietnam‘, N‘VNM‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (234, N‘贊比亞‘, N‘Zambia‘, N‘ZMB‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (235, N‘澤西島‘, N‘Jersey‘, N‘JEY‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (236, N‘乍得‘, N‘Chad‘, N‘TCD‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (237, N‘直布羅陀‘, N‘Gibraltar‘, N‘GIB‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (238, N‘智利‘, N‘Chile‘, N‘CHL‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (239, N‘中國‘, N‘China‘, N‘PRC‘, NULL) INSERT [dbo].[sp_countries] ([id], [zh_name], [en_name], [code], [parent_code]) VALUES (240, N‘中非共和國‘, N‘Central African Republic‘, N‘CAF‘, NULL) SET IDENTITY_INSERT [dbo].[sp_countries] OFF
標簽：mongo 匈牙利 aos 分享 hana public 哥倫比亞 blog pen
原文地址：http://www.cnblogs.com/SmilePastaLi/p/7457386.html
