Export a table in SQL Server 2008

Question

• How do I Export a table SQL Server to a single flat file? (all data and the first row as column names)??
• Is there a query that do this?

Answer 1

1. Right Click over the Database name -> Tasks -> ExportData
2. Choose the table as Data Source
3. Choose Flat file destination as destination
4. Choose a FileName
5. Mark "Column Names in the first data row"

Answer 2

DECLARE  
     @saveas VARCHAR(2048)
    ,@query VARCHAR(2048)
    ,@bcpquery VARCHAR(2048)
    ,@bcpconn VARCHAR(64)
    ,@bcpdelim VARCHAR(2)

SET @query      = 'select * from table1'
SET @saveas     = '\\SERVER1\SHARE1\FOLDER\QueryOutput.txt'
SET @bcpdelim   = '|'
SET @bcpconn    = '-T' -- Trusted
--SET @bcpconn    = '-U <username> -P <password>' -- SQL authentication


SET @bcpquery = 'bcp "' + replace(@query, char(10), '') + '" QUERYOUT "' + @saveas + '" -c -t^' + @bcpdelim + ' ' + @bcpconn + ' -S ' + @@servername
EXEC master..xp_cmdshell @bcpquery