Exporting the output into a text or csv file

Syntax

C:\>sqlcmd -S \\Server_pathname -i C:\script.sql -o C:\test.txt

Here Script.sql is a sql script in which the desired script is written and the related output is exported into test.txt file at the following location.