Use the BCP utility bcp out Database.dbo.TableName FileName.txt -T -c

How can I create a plain-text flat file from SQL Server as
input to another application?

Question Posted / skybeaver

Answer Posted / skybeaver

Use the BCP utility

bcp out Database.dbo.TableName FileName.txt -T -c

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Difference between LEN() and DATALENGTH() in sql server ?

1088

Why truncate is ddl?

1071

What is the difference between NOROW and LOCKROW?

2819

Mention what are the core components of ssrs?

323

What is the importance of a recovery model?

1034

How to add additional conditions in SQL?

1010

What is sql server query analyzer?

1007

Does server sql treat char as a variable-length or fixed-length column?

983

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2060

Tell me when is the update_statistics command used?

1087

How adventureworkslt tables are related?

913

Is it safe to delete log files?

903

What is the recovery model? List the types of recovery model available in sql server?

888

Why are sql functions used?

1102

Explain primary key?

949