bcp データベース名.dbo.テーブル名 out ファイルを保存するパス -c -U ユーザ名 -P パスワード -t "," -T -S サーバ名



bcp databasename.dbo.tablename out c:\tablename.csv -c -U sa -P ******* -t "," -T -S servername


bcp karax.dbo.RoomInfo out E:\psp\csv\RoomInfo.csv -c -U sa -P es10Um88 -t "," -T -S CLIENT1\SQLEXPRESS

bcp dbo.EMPLOYEES format nul -c -x -f formatfile.xml -t, -S YUUSUKE-VAIO\INS_NISHI2016 -U sa -P system -d sales


bcp databasename.dbo.tablename out c:\tablename.csv -c -U sa -P ******* -t "," -T -S servername
bcp karax.dbo.RoomInfo format nul -c -x -f E:\psp\csv\formatfile.xml -t, -U sa -P es10Um88 -T  -S CLIENT1\SQLEXPRESS

bcp databasename.dbo.tablename out c:\tablename.csv -c -U sa -P ******* -t "," -T -S servername
bcp karax.dbo.RoomInfo format nul -c -x -f E:\psp\csv\formatfile.xml -t, -U sa -P es10Um88 -T  -S CLIENT1\SQLEXPRESS



BitConfigTable
BusinessCorrect
BusinessCredit
BusinessCust
BusinessDetails
BusinessDiscount
BusinessInfo
BusinessInfo2
BusinessSales
BusinessStaying
BusinessTicket
ChargePlan
ChargeSetting
ChargeTable
ColorTable
ColorTemp
ComingCustomer
ControlInfo
Credit
Customer
CustomerGrade
CustomerTable1
CustomerTable2
CustomerTable3
DayCont
DenkonKick
DigitalCash
DiscountInfo
EmployeeInfo
FprKick
Goods
Goods2
GoodsClass
GoodsSection
Holiday
InfoTable
IntConfigTable
KprKick
MoneyTicket
NakajimeInfo
NyuuSyutu
OrderButton
OrderInfo
PointInfo
PostCode
ReceiptInfo
ReportCloseInfo
ReportSetting
ReserveInfo
RoKick
RoomCharge
RoomGroup
RoomInfo
RoomInfo2
RoomInfo3
SalesCorrect
SalesGoods
SlipData
SlipInfo
SlipPrintData
SlipSlipType
StandSetting
StayingCorrect
TicketInfo
UseRoomInfo