The command line tool of SQL Server.
sqlcmd -S localhost -U SA -P pwd
quit
sqlcmd.exe -S <server name> -d <database name> -U <username> -P <password> -I -Q "
CREATE TABLE DimDate2
(
DateId INT NOT NULL,
CalendarQuarter TINYINT NOT NULL,
FiscalQuarter TINYINT NOT NULL
)
WITH
(
CLUSTERED COLUMNSTORE INDEX,
DISTRIBUTION = ROUND_ROBIN
);
"
sqlcmd `
-S sqlpap0017t.database.windows.net `
-d Adventureworkstest `
-U user `
-P password `
-s ',' `
-W `
-Q "SELECT * FROM myTable" `
> MyTable.csv
where: