using System;

public class Program

{

    public static void Main()

    {

​

​

​

        --指令說明一定要建一個資料匣才有權限，            

        --指令T代表不輸入SQL 帳密，預設應該是連線呼叫SP的那個 ，可以用-U -P登入SQL 

        exec xp_cmdShell 'mkdir D:\dump\'

        --匯出

        exec xp_cmdShell 'bcp "SELECT  ProductId, RTrim(CAST([Name] As nVarChar(300))), Price, RTrim(CAST([HyperLink] As nVarChar(300))) as Url, RTrim(CAST([ImageUrl] As nVarChar(300))) as ImgUrl, 8 as ECId FROM SaverDb.dbo.Products8 where Item_StatusId = 1 AND ECId = 8  " queryout "D:\dump\Products8.csv" -q -c -t  '',''  -T '

        --匯入

        exec xp_cmdShell 'bcp Product_8_20160705 in "D:\dump\Products8.csv"  -d AdvMetrialDb  -q -c -t  '','' -T'

​

​

    }

}