sqlcmd - sql server cli untuk export data ke csv

sqlcmd -S localhost -U user -P password -Q "SET NOCOUNT ON; SELECT getdate() tgl" -d "master" -h -1 -s "," -o "test2.csv" -W

-S server

-U user

-P password

-d database

-s delimeter

-o output to file

-W remove space

-h -1 no header

SET NOCOUNT ON

agar tidak ada informasi (x rows affected) di paling bawah dokumen

Terima kasih,

Ade Nugroho Widjaja