首先尋找出一支欲調效的Table或Query
 
再來我們可以先使用左上方工具列 'Query' 內的 Explain Current Statement
 便可以得到如以下的連結表
 
 
由圖中可以清楚的看見每一段Query後的資料量，並發現有數張表單是呈現紅色 'Full Table Scan'
，這代表該段Query對這張表單的每一行欄位都做了掃描。
再來我們在我們的Query前方加上 'EXPLAIN' 並執行
 
便得到了該段Query所關聯的表單與其詳細資訊

其中針對EXPLAIN的欄位說明如下：
table：關連到的資料表(Table)會顯示在此。
type：顯示使用了何種類型。從最優至最差的類型為const、eq_reg、ref、range、indexhe、ALL。
possible_keys：顯示可能使用到的索引。此為從WHERE語法中選擇一個適合的欄位名稱。
key：實際使用到的索引。如果為NULL，則是沒有使用索引。
key_len：使用索引的長度。長度越短 準確性越高。
ref：顯示那一列的索引被使用。一般是一個常數(const)。
rows：MySQL用來返回資料的筆數。
Extra：MySQL用來解析額外的查詢訊息。如果此欄位的值為：Using temporary和Using filesort，表示MySQL無法使用索引。
Extra為MySQL用來解析額外的查詢訊息，其中欄位值所代表的意義如下：
Distinct：當MySQL找到相關連的資料時，就不再搜尋。
Not exists：MySQL優化 LEFT JOIN，一旦找到符合的LEFT JOIN資料後，就不再搜尋。
Range checked for each Record(index map:#)：無法找到理想的索引。此為最慢的使用索引。
Using filesort：當出現這個值時，表示此SELECT語法需要優化。因為MySQL必須進行額外的步驟來進行查詢。
Using index：返回的資料是從索引中資料，而不是從實際的資料中返回，當返回的資料都出現在索引中的資料時就會發生此情況。
Using temporary：同Using filesort，表示此SELECT語法需要進行優化。此為MySQL必須建立一個暫時的資料表(Table)來儲存結果，此情況會發生在針對不同的資料進行ORDER BY，而不是GROUP BY。
Using where：使用WHERE語法中的欄位來返回結果。
System：system資料表，此為const連接類型的特殊情況。
Const：資料表中的一個記錄的最大值能夠符合這個查詢。因為只有一行，這個值就是常數，因為MySQL會先讀這個值然後把它當做常數。
eq_ref：MySQL在連接查詢時，會從最前面的資料表，對每一個記錄的聯合，從資料表中讀取一個記錄，在查詢時會使用索引為主鍵或唯一鍵的全部。
ref：只有在查詢使用了非唯一鍵或主鍵時才會發生。
range：使用索引返回一個範圍的結果。例如：使用大於>或小於<查詢時發生。
index：此為針對索引中的資料進行查詢。
ALL：針對每一筆記錄進行完全掃描，此為最壞的情況，應該盡量避免。

 
 
 
我們可以注意到 `browse_history` 這個表單在Query中並沒有使用索引，
可以從上方的QueryString中發現該段Query的Left Join是查詢`product_id`這個欄位，前往這個Table並幫其建立Index來增加檢索效率。
  
步驟三的時候可以選擇複數欄位來建立Index，但是要注意的是在使用索引欄位作為條件時，如果該索引是複合索引，那麼必須使用到該索引中的第一個欄位作為條件時才能保證系統使用該索引，否則該索引將不會被使用，並且應儘可能的讓欄位順序與索引順序相一致。

再來是在Query語句中應該注意以下事項
1.避免在索引列上進行運算， 這將導致引擎放棄使用索引而進行全表掃描。
2.不使用NOT IN和<>操作， NOT IN和<>操作都不會使用索引將進行全表掃描。NOT IN可以NOT EXISTS代替，id<>9則可使用id>9 or id<9來代替。
3.檢查where條件與order by 欄位，避免全表掃描。
4.應儘量避免在 where 子句中對欄位進行 null 值判斷，否則將導致引擎放棄使用索引而進行全表掃描，如： 可以在num上設定預設值0，確保表中num列沒有null值，然後這樣查詢： select id from t where num = 0
5.應儘量避免在 where 子句中使用 or 來連線條件，如果一個欄位有索引，一個欄位沒有索引，將導致引擎放棄使用索引而進行全表掃描。可以拆分條件，進行子句的union all查詢，如： select id from t where num=10 or name = 'admin'  拆分 select id from t where num = 10 union all select id from t where name = 'admin'
6.in 和 not in 也要慎用，否則會導致全表掃描，如： select id from t where num in(1,2,3) 對於連續的數值，能用 between 就不要用 in 了： select id from t where num between 1 and 3，
用 exists 代替 in 是一個好的選擇： select num from a where num in(select num from b) 換成 select num from a where exists(select 1 from b where num=a.num)
7.like語句的%不要前置， 否則索引失效 將導致全表掃描。
8.如果在 where 子句中使用引數，也會導致全表掃描。 因為SQL只有在執行時才會解析區域性變數，但優化程式不能將訪問計劃的選擇推遲到執行時；它必須在編譯時進行選擇。然 而，如果在編譯時建立訪問計劃，變數的值還是未知的，因而無法作為索引選擇的輸入項。
9.應儘量避免在where子句中對欄位進行函式操作，這將導致引擎放棄使用索引而進行全表掃描。
10.不要在 where 子句中的“=”左邊進行函式、算術運算或其他表示式運算，否則系統將可能無法正確使用索引。
11.在使用索引欄位作為條件時，如果該索引是複合索引，那麼必須使用到該索引中的第一個欄位作為條件時才能保證系統使用該索引，否則該索引將不會被使用，並且應儘可能的讓欄位順序與索引順序相一致。
12.Update 語句，如果只更改1、2個欄位，不要Update全部欄位，否則頻繁呼叫會引起明顯的效能消耗，同時帶來大量日誌。
對於多張大資料量（這裡幾百條就算大了）的表JOIN，要先分頁再JOIN，否則邏輯讀會很高，效能很差。
13.select count(*) from table；這樣不帶任何條件的count會引起全表掃描，並且沒有任何業務意義，是一定要杜絕的。
14.任何地方都不要使用 select * from t ，用具體的欄位列表代替“*”，不要返回用不到的任何欄位。
15.避免頻繁建立和刪除臨時表，以減少系統表資源的消耗。臨時表並不是不可使用，適當地使用它們可以使某些例程更有效，例如，當需要重複引用大型表或常用表中的某個資料集時。但是，對於一次性事件， 最好使用匯出表。
16.在新建臨時表時，如果一次性插入資料量很大，那麼可以使用 select into 代替 create table，避免造成大量 log ，以提高速度；如果資料量不大，為了緩和系統表的資源，應先create table，然後insert。
17.儘量拆分大的 DELETE 或INSERT 語句，批量提交SQL語句。
18.儘量避免使用遊標，因為遊標的效率較差，如果遊標操作的資料超過1萬行，那麼就應該考慮改寫。

參考來源:
1. http://blog.twbryce.com/mysql-explain/
2. https://www.gushiciku.cn/pl/gkis/zh-tw
3. https://www.itread01.com/content/1548581229.html

環境說明:

AD Server: dc1 (192.168.101.109)
PC: pc110 (192.168.101.110)
PC: pc111 (192.168.101.111)

第一步，把 PC 加入 AD, 這個算是基本操作，網路上說明很多, 就不再截圖了。不過在這裡還是遇到了第一個問題，解決過程請參考另一份文件: https://blog.uwinfo.com.tw/Article.aspx?Id=486

第二步，在 Visual Studio 的測試環境中測試:
一開始是使用 .Net 6.0 來實作，沒想到找到的文件都是 .Net Core 3.1 的，所以先用 .Net Core 3.1 實做了一次，後來改用 .Net 6.0 實作才成功。使用 .Net 6.0 實作的過程如下:

1. 建立一個 MVC 的標準專案: 
 
為了避免憑証問題，所以拿掉了 HTTPS 的設定


2. 改寫 launchSettings.json:
iisSettings 中的 windowsAuthentication 改為 True, anonymousAuthentication 改為 false。如下圖:
 
3. 修改 Program.cs, 加入以下四行指令:
builder.Services.AddAuthentication(IISDefaults.AuthenticationScheme);
builder.Services.AddAuthorization();
app.UseAuthentication();
app.UseAuthorization();
(注意: UseAuthentication 要加在 UseAuthentication 之後, VS 2022 應該會提示要新增 using Microsoft.AspNetCore.Server.IISIntegration;)
 
4. 在 HomeController 增加一個 Action, 以讀取驗証資料:

        [Route("GetAuthenticatedUser")]
        [HttpGet("[action]")]
        public IdentityUser GetUser()
        {
            return new IdentityUser()
            {
                Username = User.Identity?.Name,
                IsAuthenticated = User.Identity != null ? User.Identity.IsAuthenticated : false,
                AuthenticationType = User.Identity?.AuthenticationType
            };
        }

        public class IdentityUser
        {
            public string Username { get; set; }
            public bool IsAuthenticated { get; set; }
            public string AuthenticationType { get; set; }
        }
 
5. 啟動時記得要改用 IIS Express (感覺早上花了兩三個小時在為了這個問題打轉):


6. 執行結果:

第三步，在 IIS 中安裝網站：
1. 在安裝 IIS 時，記得要勾選 windows 驗證


2. 安裝 .Net 6.0 的 Hosting Bundle
https://dotnet.microsoft.com/en-us/download/dotnet/6.0
 
3. 新增網站:
主機名稱留空白 (AD 驗証在網域內好像不會使用指定的主機名稱，這個有待後續再做確認)


如果沒有刪除預設網站，會遇到警告，直接確認即可.


要把 Default Web Site 關閉，再啟動測試站
 
要啟動 windows 驗証: 
在 web.config 中增加 

      <security>

        <authentication>

          <anonymousAuthentication enabled="false" />

          <windowsAuthentication enabled="true" />

        </authentication>

      </security>

修改 applicationHost.config:

檔案位置: %windir%\system32\inetsrv\config\applicationHost.config
這兩地方的 Deny 改為 Allow

<section name="anonymousAuthentication" overrideModeDefault="Deny" />

<section name="windowsAuthentication" overrideModeDefault="Deny" />

 
參考文件: https://docs.microsoft.com/zh-tw/iis/get-started/planning-for-security/how-to-use-locking-in-iis-configuration

3. 可以取得登入資訊如下:

4. 從 Domain 中另一台主機來存取，不用登入，自動取得目前登入者的資訊。
 
5. 從非網域主機連線: 會要求認証
 

目前遇到問題: 在網域中的電腦只能用主機名稱登入，非網域的電腦，才能夠使用網址登入。

測試專案下載: https://github.com/bikehsu/AD60
 

C# PrintScreen to file

出現錯誤： 無法產生 ActiveX 控制項 '8856f961-340a-11d0-a96b-00c04fd705a2'，因為目前的執行緒不是在單一執行緒 Apartment。
 
解決方法： 
@Page 加上 AspCompat="true" 即可。
強迫網頁由 STA 執行緒集區服務

https://stackoverflow.com/questions/17186568/upload-from-ios-picture-to-net-app-rotate

 讀取某個參數來判斷            if (image_file.PropertyIdList.Contains(0x0112))
            {
                int rotationValue = image_file.GetPropertyItem(0x0112).Value[0];
                switch (rotationValue)
                {
                    case 1: // landscape, do nothing
                        break;

                    case 8: // rotated 90 right
                            // de-rotate:
                        image_file.RotateFlip(rotateFlipType: RotateFlipType.Rotate270FlipNone);
                        break;

                    case 3: // bottoms up
                        image_file.RotateFlip(rotateFlipType: RotateFlipType.Rotate180FlipNone);
                        break;

                    case 6: // rotated 90 left
                        image_file.RotateFlip(rotateFlipType: RotateFlipType.Rotate90FlipNone);

                        image_file.Save(Path + FileName);
                        break;
                }
            }

相關參考
https://vuejs.org/v2/guide/

1.
加入vue.js

2.
先"包裹"一層 要用到Vue的元素
個人覺得有點想原本習慣的<!--Content-->
但這次只要放入標籤(我是用Id)
像是範例為 vMain   
然後宣告js 物件 我是取名也叫做 vMain 不知道會不會有撞名問題
所以我的el: 就是 #vMain

3.
再來加入變數
{{Creat_Date}}  兩個括號 桃紅色的
如果data 這個物件裡面有一個叫Creat_Date 的資料他就會被放進去

這樣第一個app 就完成了。

其中 Vue 裡面包含幾樣東西 
el >> 標示 這個Vue 的標籤
data >> 裡面存放的資料變數
created >> 生命週期的
methods>>包含各種功能function

這次的列表頁需要用到以前用的 List Item 跟 Pager
對應到vue 會使用到
v-for for 迴圈
v-for" item in dt  ">> dt 為data中的一個array陣列 (此範例中 為PD 中的 DT)
item 則是在這裡的區域變數

有些要顯示有些要隱藏
v-if
v-if" pager.currentPage  > 1" pager 為data 中的一個物件 裡面有包含 currentPage 的變數

還有要傳ajax 回去要資料
所以要在 vue 中的 methods 建立 function
已這次的例子 getList就是目前的function 可以用到一些 data 裡面的資料
回傳成功之後資料也可以回寫在data上面

以及之前會在各種事件的觸發 
@click 觸發點擊事件
在標籤上加上 @click 可以觸發 類似 onclick 的事件 
但是是調用methods裡面function

日期格式
由於之前的套件PD 回傳的日期資料會是 yyyy-MM-ddTHH:mm:ss 這樣的格式
所以使用了 map  將 dt 裡面的日期 轉換成為我要的格式

v.dt.map(function (obj) {
      var rObj = obj;
      rObj["Create_Date"] = $.datepicker.formatDate('yy-mm-dd', new Date(obj["Create_Date"]));
      return rObj;
});

建立兩個表 city 和 area, 並填入值:

CREATE TABLE [dbo].[city](
    [id] [int] NOT NULL,
    [name] [varchar](8) NULL,
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]

INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (1, '基隆市')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (2, '台北市')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (3, '新北市')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (4, '桃園市')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (5, '新竹市')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (6, '新竹縣')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (7, '苗栗縣')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (8, '台中市')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (9, '彰化縣')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (10, '南投縣')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (11, '雲林縣')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (12, '嘉義市')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (13, '嘉義縣')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (14, '台南市')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (15, '高雄市')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (16, '屏東縣')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (17, '台東縣')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (18, '花蓮縣')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (19, '宜蘭縣')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (20, '澎湖縣')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (21, '金門縣')
INSERT INTO [dbo].[city] ([id] ,[name]) VALUES (22, '連江縣')



CREATE TABLE [dbo].[area](
    [city_id] [int] NULL,
    [id] [int] NOT NULL,
    [name] [varchar](8) NULL,
    [post_code] [varchar](3) NULL,
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

insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(1, 1, '仁愛區', '200')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(2, 1, '信義區', '201')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(3, 1, '中正區', '202')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(4, 1, '中山區', '203')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(5, 1, '安樂區', '204')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(6, 1, '暖暖區', '205')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(7, 1, '七堵區', '206')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(8, 2, '中正區', '100')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(9, 2, '大同區', '103')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(10, 2, '中山區', '104')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(11, 2, '松山區', '105')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(12, 2, '大安區', '106')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(13, 2, '萬華區', '108')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(14, 2, '信義區', '110')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(15, 2, '士林區', '111')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(16, 2, '北投區', '112')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(17, 2, '內湖區', '114')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(18, 2, '南港區', '115')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(19, 2, '文山區', '116')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(20, 3, '萬里區', '207')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(21, 3, '金山區', '208')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(22, 3, '板橋區', '220')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(23, 3, '汐止區', '221')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(24, 3, '深坑區', '222')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(25, 3, '石碇區', '223')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(26, 3, '瑞芳區', '224')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(27, 3, '平溪區', '226')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(28, 3, '雙溪區', '227')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(29, 3, '貢寮區', '228')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(30, 3, '新店區', '231')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(31, 3, '坪林區', '232')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(32, 3, '烏來區', '233')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(33, 3, '永和區', '234')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(34, 3, '中和區', '235')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(35, 3, '土城區', '236')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(36, 3, '三峽區', '237')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(37, 3, '樹林區', '238')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(38, 3, '鶯歌區', '239')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(39, 3, '三重區', '241')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(40, 3, '新莊區', '242')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(41, 3, '泰山區', '243')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(42, 3, '林口區', '244')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(43, 3, '蘆洲區', '247')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(44, 3, '五股區', '248')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(45, 3, '八里區', '249')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(46, 3, '淡水區', '251')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(47, 3, '三芝區', '252')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(48, 3, '石門區', '253')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(49, 4, '中壢區', '320')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(50, 4, '平鎮區', '324')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(51, 4, '龍潭區', '325')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(52, 4, '楊梅區', '326')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(53, 4, '新屋區', '327')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(54, 4, '觀音區', '328')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(55, 4, '桃園區', '330')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(56, 4, '龜山區', '333')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(57, 4, '八德區', '334')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(58, 4, '大溪區', '335')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(59, 4, '復興區', '336')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(60, 4, '大園區', '337')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(61, 4, '蘆竹區', '338')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(62, 5, '新竹市', '300')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(63, 6, '竹北市', '302')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(64, 6, '湖口鄉', '303')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(65, 6, '新豐鄉', '304')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(66, 6, '新埔鎮', '305')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(67, 6, '關西鎮', '306')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(68, 6, '芎林鄉', '307')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(69, 6, '寶山鄉', '308')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(70, 6, '竹東鎮', '310')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(71, 6, '五峰鄉', '311')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(72, 6, '橫山鄉', '312')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(73, 6, '尖石鄉', '313')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(74, 6, '北埔鄉', '314')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(75, 6, '峨眉鄉', '315')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(76, 7, '竹南鎮', '350')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(77, 7, '頭份鎮', '351')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(78, 7, '三灣鄉', '352')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(79, 7, '南庄鄉', '353')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(80, 7, '獅潭鄉', '354')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(81, 7, '後龍鎮', '356')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(82, 7, '通霄鎮', '357')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(83, 7, '苑裡鎮', '358')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(84, 7, '苗栗市', '360')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(85, 7, '造橋鄉', '361')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(86, 7, '頭屋鄉', '362')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(87, 7, '公館鄉', '363')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(88, 7, '大湖鄉', '364')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(89, 7, '泰安鄉', '365')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(90, 7, '銅鑼鄉', '366')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(91, 7, '三義鄉', '367')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(92, 7, '西湖鄉', '368')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(93, 7, '卓蘭鎮', '369')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(94, 8, '中區', '400')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(95, 8, '東區', '401')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(96, 8, '南區', '402')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(97, 8, '西區', '403')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(98, 8, '北區', '404')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(99, 8, '北屯區', '406')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(100, 8, '西屯區', '407')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(101, 8, '南屯區', '408')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(102, 8, '太平區', '411')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(103, 8, '大里區', '412')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(104, 8, '霧峰區', '413')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(105, 8, '烏日區', '414')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(106, 8, '豐原區', '420')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(107, 8, '后里區', '421')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(108, 8, '石岡區', '422')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(109, 8, '東勢區', '423')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(110, 8, '和平區', '424')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(111, 8, '新社區', '426')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(112, 8, '潭子區', '427')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(113, 8, '大雅區', '428')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(114, 8, '神岡區', '429')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(115, 8, '大肚區', '432')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(116, 8, '沙鹿區', '433')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(117, 8, '龍井區', '434')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(118, 8, '梧棲區', '435')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(119, 8, '清水區', '436')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(120, 8, '大甲區', '437')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(121, 8, '外埔區', '438')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(122, 8, '大安區', '439')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(123, 9, '彰化市', '500')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(124, 9, '芬園鄉', '502')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(125, 9, '花壇鄉', '503')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(126, 9, '秀水鄉', '504')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(127, 9, '鹿港鎮', '505')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(128, 9, '福興鄉', '506')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(129, 9, '線西鄉', '507')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(130, 9, '和美鄉', '508')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(131, 9, '伸港鄉', '509')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(132, 9, '員林鎮', '510')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(133, 9, '社頭鄉', '511')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(134, 9, '永靖鄉', '512')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(135, 9, '埔心鄉', '513')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(136, 9, '溪湖鎮', '514')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(137, 9, '大村鄉', '515')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(138, 9, '埔鹽鄉', '516')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(139, 9, '田中鎮', '520')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(140, 9, '北斗鎮', '521')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(141, 9, '田尾鄉', '522')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(142, 9, '埤頭鄉', '523')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(143, 9, '溪州鄉', '524')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(144, 9, '竹塘鄉', '525')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(145, 9, '二林鎮', '526')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(146, 9, '大城鄉', '527')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(147, 9, '芳苑鄉', '528')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(148, 9, '二水鄉', '530')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(149, 10, '南投市', '540')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(150, 10, '中寮鄉', '541')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(151, 10, '草屯鎮', '542')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(152, 10, '國姓鄉', '544')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(153, 10, '埔里鎮', '545')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(154, 10, '仁愛鄉', '546')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(155, 10, '名間鄉', '551')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(156, 10, '集集鎮', '552')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(157, 10, '水里鄉', '553')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(158, 10, '魚池鄉', '555')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(159, 10, '信義鄉', '556')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(160, 10, '竹山鎮', '557')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(161, 10, '鹿谷鄉', '558')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(162, 11, '斗南鎮', '630')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(163, 11, '大埤鄉', '631')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(164, 11, '虎尾鎮', '632')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(165, 11, '土庫鎮', '633')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(166, 11, '褒忠鄉', '634')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(167, 11, '東勢鄉', '635')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(168, 11, '台西鄉', '636')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(169, 11, '崙背鄉', '637')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(170, 11, '麥寮鄉', '638')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(171, 11, '斗六市', '640')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(172, 11, '林內鄉', '643')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(173, 11, '古坑鄉', '646')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(174, 11, '莿桐鄉', '647')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(175, 11, '西螺鎮', '648')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(176, 11, '二崙鄉', '649')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(177, 11, '北港鎮', '651')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(178, 11, '水林鄉', '652')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(179, 11, '口湖鄉', '653')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(180, 11, '四湖鄉', '654')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(181, 11, '元長鄉', '655')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(182, 12, '嘉義市', '600')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(183, 13, '番路鄉', '602')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(184, 13, '梅山鄉', '603')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(185, 13, '竹崎鄉', '604')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(186, 13, '阿里山', '605')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(187, 13, '中埔鄉', '606')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(188, 13, '大埔鄉', '607')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(189, 13, '水上鄉', '608')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(190, 13, '鹿草鄉', '611')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(191, 13, '太保鄉', '612')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(192, 13, '朴子市', '613')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(193, 13, '東石鄉', '614')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(194, 13, '六腳鄉', '615')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(195, 13, '新港鄉', '616')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(196, 13, '民雄鄉', '621')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(197, 13, '大林鎮', '622')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(198, 13, '溪口鄉', '623')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(199, 13, '義竹鄉', '624')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(200, 13, '布袋鄉', '625')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(201, 14, '中西區', '700')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(202, 14, '東區', '701')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(203, 14, '南區', '702')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(204, 14, '北區', '704')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(205, 14, '安平區', '708')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(206, 14, '安南區', '709')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(207, 14, '永康區', '710')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(208, 14, '歸仁區', '711')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(209, 14, '新化區', '712')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(210, 14, '左鎮區', '713')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(211, 14, '玉井區', '714')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(212, 14, '楠西區', '715')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(213, 14, '南化區', '716')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(214, 14, '仁德區', '717')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(215, 14, '關廟區', '718')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(216, 14, '龍崎區', '719')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(217, 14, '官田區', '720')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(218, 14, '麻豆區', '721')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(219, 14, '佳里區', '722')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(220, 14, '西港區', '723')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(221, 14, '七股區', '724')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(222, 14, '將軍區', '725')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(223, 14, '學甲區', '726')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(224, 14, '北門區', '727')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(225, 14, '新營區', '730')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(226, 14, '後壁區', '731')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(227, 14, '白河區', '732')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(228, 14, '東山區', '733')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(229, 14, '六甲區', '734')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(230, 14, '下營區', '735')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(231, 14, '柳營區', '736')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(232, 14, '鹽水區', '737')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(233, 14, '善化區', '741')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(234, 14, '大內區', '742')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(235, 14, '山上區', '743')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(236, 14, '新市區', '744')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(237, 14, '安定區', '745')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(238, 15, '新興區', '800')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(239, 15, '前金區', '801')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(240, 15, '苓雅區', '802')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(241, 15, '鹽埕區', '803')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(242, 15, '鼓山區', '804')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(243, 15, '旗津區', '805')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(244, 15, '前鎮區', '806')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(245, 15, '三民區', '807')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(246, 15, '楠梓區', '811')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(247, 15, '小港區', '812')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(248, 15, '左營區', '813')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(249, 15, '仁武區', '814')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(250, 15, '大社區', '815')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(251, 15, '岡山區', '820')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(252, 15, '路竹區', '821')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(253, 15, '阿蓮區', '822')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(254, 15, '田寮區', '823')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(255, 15, '燕巢區', '824')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(256, 15, '橋頭區', '825')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(257, 15, '梓官區', '826')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(258, 15, '彌陀區', '827')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(259, 15, '永安區', '828')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(260, 15, '湖內區', '829')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(261, 15, '鳳山區', '830')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(262, 15, '大寮區', '831')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(263, 15, '林園區', '832')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(264, 15, '鳥松區', '833')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(265, 15, '大樹區', '840')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(266, 15, '旗山區', '842')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(267, 15, '美濃區', '843')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(268, 15, '六龜區', '844')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(269, 15, '內門區', '845')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(270, 15, '杉林區', '846')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(271, 15, '甲仙區', '847')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(272, 15, '桃源區', '848')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(273, 15, '那瑪夏區', '849')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(274, 15, '茂林區', '851')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(275, 15, '茄萣區', '852')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(276, 15, '東沙', '817')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(277, 15, '南沙', '819')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(278, 16, '屏東市', '900')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(279, 16, '三地鄉', '901')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(280, 16, '霧台鄉', '902')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(281, 16, '瑪家鄉', '903')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(282, 16, '九如鄉', '904')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(283, 16, '里港鄉', '905')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(284, 16, '高樹鄉', '906')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(285, 16, '鹽埔鄉', '907')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(286, 16, '長治鄉', '908')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(287, 16, '麟洛鄉', '909')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(288, 16, '竹田鄉', '911')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(289, 16, '內埔鄉', '912')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(290, 16, '萬丹鄉', '913')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(291, 16, '潮州鎮', '920')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(292, 16, '泰武鄉', '921')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(293, 16, '來義鄉', '922')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(294, 16, '萬巒鄉', '923')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(295, 16, '崁頂鄉', '924')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(296, 16, '新埤鄉', '925')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(297, 16, '南州鄉', '926')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(298, 16, '林邊鄉', '927')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(299, 16, '東港鄉', '928')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(300, 16, '琉球鄉', '929')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(301, 16, '佳冬鄉', '931')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(302, 16, '新園鄉', '932')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(303, 16, '枋寮鄉', '940')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(304, 16, '枋山鄉', '941')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(305, 16, '春日鄉', '942')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(306, 16, '獅子鄉', '943')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(307, 16, '車城鄉', '944')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(308, 16, '牡丹鄉', '945')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(309, 16, '恆春鎮', '946')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(310, 16, '滿洲鄉', '947')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(311, 17, '台東市', '950')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(312, 17, '綠島鄉', '951')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(313, 17, '蘭嶼鄉', '952')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(314, 17, '延平鄉', '953')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(315, 17, '卑南鄉', '954')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(316, 17, '鹿野鄉', '955')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(317, 17, '關山鎮', '956')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(318, 17, '海端鄉', '957')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(319, 17, '池上鄉', '958')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(320, 17, '東河鄉', '959')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(321, 17, '成功鎮', '961')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(322, 17, '長濱鄉', '962')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(323, 17, '太麻里', '963')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(324, 17, '金峰鄉', '964')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(325, 17, '大武鄉', '965')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(326, 17, '達仁鄉', '966')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(327, 18, '花蓮市', '970')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(328, 18, '新城鄉', '971')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(329, 18, '秀林鄉', '972')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(330, 18, '吉安鄉', '973')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(331, 18, '壽豐鄉', '974')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(332, 18, '鳳林鎮', '975')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(333, 18, '光復鄉', '976')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(334, 18, '豐濱鄉', '977')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(335, 18, '瑞穗鄉', '978')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(336, 18, '萬榮鄉', '979')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(337, 18, '玉里鎮', '981')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(338, 18, '卓溪鄉', '982')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(339, 18, '富里鄉', '983')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(340, 19, '宜蘭巿', '260')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(341, 19, '頭城鎮', '261')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(342, 19, '礁溪鄉', '262')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(343, 19, '壯圍鄉', '263')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(344, 19, '員山鄉', '264')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(345, 19, '羅東鎮', '265')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(346, 19, '三星鄉', '266')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(347, 19, '大同鄉', '267')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(348, 19, '五結鄉', '268')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(349, 19, '冬山鄉', '269')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(350, 19, '蘇澳鎮', '270')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(351, 19, '南澳鄉', '272')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(352, 19, '釣魚台', '290')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(353, 20, '馬公市', '880')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(354, 20, '西嶼鄉', '881')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(355, 20, '望安鄉', '882')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(356, 20, '七美鄉', '883')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(357, 20, '白沙鄉', '884')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(358, 20, '湖西鄉', '885')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(359, 21, '金沙鎮', '890')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(360, 21, '金湖鎮', '891')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(361, 21, '金寧鄉', '892')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(362, 21, '金城鎮', '893')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(363, 21, '烈嶼鄉', '894')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(364, 21, '烏坵', '896')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(365, 22, '南竿', '209')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(366, 22, '北竿', '210')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(367, 22, '莒光', '211')
insert into area([id]      ,[city_id]      ,[name]      ,[post_code]) values(368, 22, '東引', '212')

https://stackoverflow.com/questions/628565/display-lines-number-in-stack-trace-for-net-assembly-in-release-mode/628590#628590

1. Go into the Properties window for the project where you want to see stack trace line numbers.
2. Click on the Build "vertical tab".
3. Select "Release" configuration. Check the DEBUG constant parameter.
4. Uncheck the "Optimize code" parameter to avoid the occasional trace issue with inlined code (this step is not essential).
5. Press the Advanced... button and choose Output -> Debug Info -> pdb-only.
6. Deploy the generated .pdb file with the assembly.

 
 
 

修改欄位設定時，出現需要刪除資料表(drop table)再建立資料表(create table)才能修改時，
於 [工具] > [選項] > [設計工具]
清除防止儲存需要重新建立資料表的變更] 核取方塊，即可。
如下圖


參考網址：https://support.microsoft.com/zh-tw/help/956176/error-message-when-you-try-to-save-a-table-in-sql-server-saving-change
 

由於工作排程往往有數十個甚至百來個 因此需要一個方法能快速備份及移轉到其他 server 的方法
查了一下，好像也只能這樣做

---- 使用指令把全部排程匯出 ----
參考網址
https://msdn.microsoft.com/en-us/library/windows/desktop/bb736357%28v=vs.85%29.aspx?f=255&MSPPError=-2147217396

schtasks /query /XML > all_tasks.xml  
schtasks /query /FO CSV /V >sched_tasks.csv

** xml 比較有用,可以用來匯入到其他server排程，但還要額外處理才能匯入
** csv 只是用來看看目前有哪些排程 可以用來做報表看看
** 這些是全部排程，還要特別處理把 Microsoft 及其他軟體建的排程移除

--------------------------------------------------------------

----如何匯入工作排程到其他 server --------

** 需再寫程式把 all_tasks.xml 拆解成所有排程的單一 xml
   並且生成指令 bat

** 注意 xml 必須是 UTF-16 (unicode) 
   因為 "schtasks /query /XML > all_tasks.xml"產生 xml 是 ansi 

參考網址
https://serverfault.com/questions/325569/how-do-i-import-multiple-tasks-from-a-xml-in-windows-server-2008
** /TN "排程名稱" --- 排程名稱可以是路徑名 
D:\>schtasks.exe /create /TN "\2016JOB\Global\CountryMonthlyStats" /XML "D:\one_task.xml"
** 下面程式碼只是下面程式碼只是參考 還沒實作過
=====================================

var taskXML = new XmlDocument();
taskXML.Load(@"d:\temp\schedtasksBackup.xml");
var batbody = new StringBuilder();

XmlNodeList tasks = taskXML.DocumentElement.GetElementsByTagName("Task");

string strFileName = "d:\\temp\\Task";

for (int i = 0; i < tasks.Count; i++) {
    string onetaskXML = tasks[i].OuterXml;

    //Create the New File. With a little more extra effort
    //you can get the name from a comment above the task -> 應該把註解裡的名稱抓出
    XmlWriter xw = XmlWriter.Create(strFileName + "_" + (i+1) + ".xml");
    batbody.AppendLine(string.Format("schtasks.exe /create /TN \"{0}\" /XML \"{1}\"", "Task " + (i+1) + " Name", strFileName + "_" + (i+1) + ".xml"));

    //Write the XML
    xw.WriteRaw(onetaskXML.ToString());
    xw.Close();

    // Write a bat to import all the tasks
    var batfile = new System.IO.StreamWriter("d:\\temp\\importAllTasks.bat");
    batfile.WriteLine(batbody.ToString());
    batfile.Close();

}
=====================================

#微軟的排程備份真是有夠爛沒有辦法用介面一鍵搞定

寫一下, 以備不時之需, Codepage 和 Name 可以用來取得 encoding.
CodePage, DisplayName, Name
37, IBM EBCDIC (美國-加拿大), IBM037
437, OEM 美國, IBM437
500, IBM EBCDIC (國際), IBM500
708, 阿拉伯文 (ASMO 708), ASMO-708
720, 阿拉伯文 (DOS), DOS-720
737, 希臘文 (DOS), ibm737
775, 波羅的海文 (DOS), ibm775
850, 西歐語系 (DOS), ibm850
852, 中歐語系 (DOS), ibm852
855, OEM 斯拉夫文, IBM855
857, 土耳其文 (DOS), ibm857
858, OEM 多語系拉丁文 I, IBM00858
860, 葡萄牙文 (DOS), IBM860
861, 冰島文 (DOS), ibm861
862, 希伯來文 (DOS), DOS-862
863, 加拿大法文 (DOS), IBM863
864, 阿拉伯文 (864), IBM864
865, 北歐字母 (DOS), IBM865
866, 斯拉夫文 (DOS), cp866
869, 希臘文，現代 (DOS), ibm869
870, IBM EBCDIC (多語系拉丁文 2), IBM870
874, 泰文 (Windows), windows-874
875, IBM EBCDIC (希臘現代), cp875
932, 日文 (Shift-JIS), shift_jis
936, 簡體中文 (GB2312), gb2312
949, 韓文, ks_c_5601-1987
950, 繁體中文 (Big5), big5
1026, IBM EBCDIC (土耳其拉丁文 5), IBM1026
1047, IBM 拉丁文 1, IBM01047
1140, IBM EBCDIC (美國-加拿大-歐洲), IBM01140
1141, IBM EBCDIC (德國-歐洲), IBM01141
1142, IBM EBCDIC (丹麥-挪威-歐洲), IBM01142
1143, IBM EBCDIC (芬蘭-瑞典-歐洲), IBM01143
1144, IBM EBCDIC (義大利-歐洲), IBM01144
1145, IBM EBCDIC (西班牙-歐洲), IBM01145
1146, IBM EBCDIC (英國-歐洲), IBM01146
1147, IBM EBCDIC (法國-歐洲), IBM01147
1148, IBM EBCDIC (國際-歐洲), IBM01148
1149, IBM EBCDIC (冰島-歐洲), IBM01149
1200, Unicode, utf-16
1201, Unicode (位元組由大到小), utf-16BE
1250, 中歐語系 (Windows), windows-1250
1251, 斯拉夫文 (Windows), windows-1251
1252, 西歐語系 (Windows), Windows-1252
1253, 希臘文 (Windows), windows-1253
1254, 土耳其文 (Windows), windows-1254
1255, 希伯來文 (Windows), windows-1255
1256, 阿拉伯文 (Windows), windows-1256
1257, 波羅的海文 (Windows), windows-1257
1258, 越南文 (Windows), windows-1258
1361, 韓文 (Johab), Johab
10000, 西歐語系 (Mac), macintosh
10001, 日文 (Mac), x-mac-japanese
10002, 繁體中文 (Mac), x-mac-chinesetrad
10003, 韓文 (Mac), x-mac-korean
10004, 阿拉伯文 (Mac), x-mac-arabic
10005, 希伯來文 (Mac), x-mac-hebrew
10006, 希臘文 (Mac), x-mac-greek
10007, 斯拉夫文 (Mac), x-mac-cyrillic
10008, 簡體中文 (Mac), x-mac-chinesesimp
10010, 羅馬尼亞文 (Mac), x-mac-romanian
10017, 烏克蘭文 (Mac), x-mac-ukrainian
10021, 泰文 (Mac), x-mac-thai
10029, 中歐語系 (Mac), x-mac-ce
10079, 冰島文 (Mac), x-mac-icelandic
10081, 土耳其文 (Mac), x-mac-turkish
10082, 克羅埃西亞文 (Mac), x-mac-croatian
12000, Unicode (UTF-32), utf-32
12001, Unicode (UTF-32 位元組由大到小), utf-32BE
20000, 繁體中文 (CNS), x-Chinese-CNS
20001, TCA 台灣, x-cp20001
20002, 繁體中文 (Eten), x-Chinese-Eten
20003, IBM5550 台灣, x-cp20003
20004, TeleText 台灣, x-cp20004
20005, Wang 台灣, x-cp20005
20105, 西歐語系 (IA5), x-IA5
20106, 德文 (IA5), x-IA5-German
20107, 瑞典文 (IA5), x-IA5-Swedish
20108, 挪威文 (IA5), x-IA5-Norwegian
20127, US-ASCII, us-ascii
20261, T.61, x-cp20261
20269, ISO-6937, x-cp20269
20273, IBM EBCDIC (德國), IBM273
20277, IBM EBCDIC (丹麥-挪威), IBM277
20278, IBM EBCDIC (芬蘭-瑞典), IBM278
20280, IBM EBCDIC (義大利), IBM280
20284, IBM EBCDIC (西班牙), IBM284
20285, IBM EBCDIC (UK), IBM285
20290, IBM EBCDIC (日文片假名), IBM290
20297, IBM EBCDIC (法國), IBM297
20420, IBM EBCDIC (阿拉伯文), IBM420
20423, IBM EBCDIC (希臘文), IBM423
20424, IBM EBCDIC (希伯來文), IBM424
20833, IBM EBCDIC (韓文擴充), x-EBCDIC-KoreanExtended
20838, IBM EBCDIC (泰國), IBM-Thai
20866, 斯拉夫文 (KOI8-R), koi8-r
20871, IBM EBCDIC (冰島), IBM871
20880, IBM EBCDIC (斯拉夫俄文), IBM880
20905, IBM EBCDIC (土耳其), IBM905
20924, IBM 拉丁文 1, IBM00924
20932, 日文 (JIS 0208-1990 和 0212-1990), EUC-JP
20936, 簡體中文 (GB2312-80), x-cp20936
20949, 韓文 Wansung, x-cp20949
21025, IBM EBCDIC (斯拉夫塞爾維亞文-保加利亞文), cp1025
21866, 斯拉夫文 (KOI8-U), koi8-u
28591, 西歐語系 (ISO), iso-8859-1
28592, 中歐語系 (ISO), iso-8859-2
28593, 拉丁文 3 (ISO), iso-8859-3
28594, 波羅的海文 (ISO), iso-8859-4
28595, 斯拉夫文 (ISO), iso-8859-5
28596, 阿拉伯文 (ISO), iso-8859-6
28597, 希臘文 (ISO), iso-8859-7
28598, 希伯來文 (ISO-Visual), iso-8859-8
28599, 土耳其文 (ISO), iso-8859-9
28603, 愛沙尼亞文 (ISO), iso-8859-13
28605, 拉丁文 9 (ISO), iso-8859-15
29001, 歐洲, x-Europa
38598, 希伯來文 (ISO-Logical), iso-8859-8-i
50220, 日文 (JIS), iso-2022-jp
50221, 日文 (JIS-Allow 1 byte Kana), csISO2022JP
50222, 日文 (JIS-Allow 1 byte Kana - SO/SI), iso-2022-jp
50225, 韓文 (ISO), iso-2022-kr
50227, 簡體中文 (ISO-2022), x-cp50227
51932, 日文 (EUC), euc-jp
51936, 簡體中文 (EUC), EUC-CN
51949, 韓文 (EUC), euc-kr
52936, 簡體中文 (HZ), hz-gb-2312
54936, 簡體中文 (GB18030), GB18030
57002, ISCII 梵文語系, x-iscii-de
57003, ISCII 孟加拉文, x-iscii-be
57004, ISCII 坦米爾文, x-iscii-ta
57005, ISCII 特拉古文, x-iscii-te
57006, ISCII 阿薩姆文, x-iscii-as
57007, ISCII 歐利亞文, x-iscii-or
57008, ISCII 坎那達文, x-iscii-ka
57009, ISCII 馬來亞拉姆文, x-iscii-ma
57010, ISCII 古吉拉特文, x-iscii-gu
57011, ISCII 旁遮普語, x-iscii-pa
65000, Unicode (UTF-7), utf-7
65001, Unicode (UTF-8), utf-8