BCP

为什么80%的码农都做不了架构师？>>>   

#BCP study

#The pre-condition is that you must install MSSQL

#It will generate the file named QueryOut.csv whose content is the result of execute the sql command

BCP "Select * from database_name.dbo.table_name" queryout C:\QueryOut.csv -w -t\t -S server -U username -P password

 

转载于:https://my.oschina.net/little/blog/744