Export a huge table to csv text file

The most easiest and quick method even for large table using the bcp:

bcp dbname.dbo.tablename out T:\temp\table5.txt -S localhost -T -c -t, -a 32768

1	bcp dbname.dbo.tablename out T:\temp\table5.txt -S localhost -T -c -t, -a 32768

if you use unicode add: -w