Is it possible to export a table using sql query in management studio, sort of like:

SELECT *
INTO "C:\TEMP\Test.c sv"
FROM Mytable

Or through a
EXECUTE('Export MyTable to "C:\TEMP\Test.c sv"')?