The most easiest and quick method even for large table using the bcp:
|
1 |
bcp dbname.dbo.tablename out T:\temp\table5.txt -S localhost -T -c -t, -a 32768 |
if you use unicode add: -w
Just another Select of Ms SQL DBA site
Just another Select of Ms SQL DBA site
The most easiest and quick method even for large table using the bcp:
|
1 |
bcp dbname.dbo.tablename out T:\temp\table5.txt -S localhost -T -c -t, -a 32768 |
if you use unicode add: -w