--I like using a super special 4 char row delimiter to be sure it doesn't exist in the data
--flags explanation:
-- -c        = character data
-- -t"[||]" = field terminator instead of comma?
-- -r"[~~]" = row terminator instead of CrLf \n
-- -T'      = Trusted connection
--out
declare @cmd varchar(4000)
SELECT @cmd = 'bcp.exe' --the executable...if not in the PATH variable, you might need something like 'C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\bcp.exe '
            + ' ' --space required for parameterizing
            + '"SELECT EMAILTEMPLATESID, EMAILBODY FROM BFONRA.dbo.EMAILTEMPLATES ORDER BY EMAILTEMPLATESID"' 
                                       --<-- the query itself: no CrLf allowed.
            + ' '                      -- space required for parameterizing
            + 'queryout'               -- bcp  parameter for query direction
            + ' '                      -- space required for parameterizing
            + 'c:\Data\bcpExample2.txt' -- destination file name:
            + ' '                      -- space required for parameterizing
            + '-c'                     -- -c = character data
            + ' '                      -- space required for parameterizing
            + '-t","'                  -- comma delimited -t"[||]" = field terminator
            + ' '                      -- space required for parameterizing
            + '-t"\n"'        -- -r"[~~]" = row terminator
            + ' '                      -- space required for parameterizing
            + '-T"'                    -- -T' = Trusted connection


EXECUTE master.dbo.xp_cmdshell @cmd

declare @cmd varchar(4000)
--sqlcmd -q "select col1,col2,col3 from table" -oc:\myfile.csv -h-1 -s","'
SELECT @cmd = 'sqlcmd.exe' --the executable...if not in the PATH variable, you might need something like 'C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\bcp.exe '
            + ' '                       --space required for parameterizing
            + '-q'                      -- -q = sqlcmd parameter 
            + '"SELECT EMAILTEMPLATESID, EMAILBODY FROM BFONRA.dbo.EMAILTEMPLATES ORDER BY EMAILTEMPLATESID"' 
                                        --<-- the query itself: no CrLf allowed.
            + ' '                       -- space required for parameterizing
            + '-o '                     -- -o = sqlcmd parameter 
            + 'c:\Data\bcpExample3.txt' -- destination file name:
            + ' '                       -- space required for parameterizing
            + '-h-1'                      -- -h = headers -1 = no 
            + ' '                       -- space required for parameterizing
            + '-s","'                   -- comma delimited -s"[||]" = field terminator


EXECUTE master.dbo.xp_cmdshell @cmd