SQL 多筆資料合併為一個欄位

參考網址:http://www.dotblogs.com.tw/kevinya/archive/2012/06/01/72553.aspx?fid=60981

SELECT cast(ProductID AS NVARCHAR ) + ',' from [Order] 
where OrderID = '10248'
FOR XML PATH('')

SQL 從別的table匯入特定欄位

INSERT INTO newTable (col1, col2, col3)
SELECT column1, column2, column3
FROM oldTable

google api 地址轉經緯度

//取得地址轉經緯度
            var wc = new WebClient();
            byte[] bResult = wc.DownloadData("http://maps.googleapis.com/maps/api/geocode/json?address=" + HttpUtility.UrlEncode(地址字串) + "&sensor=false&language=zh-TW");
            addJson = Encoding.UTF8.GetString(bResult);
            addJson = addJson.Replace("\n", "");