Selecting specific fields to make a CSV file

Question

I want to extract the data for selected months in csv format, but the thing is, i dont need all the fields to be in my output file, just want to extract for some selected fields.

For eg: I need fname, lname, mobile, emailid

I am using SQL 2005.

Answer 1

0

If you are using some external tool to make the CSV file and you can not (why not?) specify the specific fields you need then you could make a VIEW and query that instead:

CREATE VIEW MyView            
AS            
SELECT MyCol1,            
    MyCol2,            
    ...            
FROM MyTable

answered Oct 29 '09 at 10:21 AM

Kristen ♦
2.2k ● 6 ● 7 ● 10

(comments are locked)

Answer 2

0

or use bcp command and select the required columns

            
exec xp_cmdshell 'bcp "select col1,col2..colN from dbname..table"             
queryout "C:\test.csv" -T'

answered Nov 13 '09 at 03:41 AM

Madhivanan
1.1k ● 1 ● 2 ● 6

(comments are locked)

Selecting specific fields to make a CSV file

Follow this question

Related Questions