Sql server query to get data directly from the server to local

SQL Server Administration
1

Is there any sql server query that saves data directly from table to some csv file or text file in local .

2

hi hope this helps

at cmd prompt ..

bcp "SELECT * FROM Database.dbo.Table" queryout C:\Test.csv -c -t',' -T -S .\SQLEXPRESS