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

What is the use of for clause?

577

How to write a query with a left outer join in ms sql server?

572

What are entities and relationships?

547

What is the exact numeric data type in sql?

547

How to create a dynamic cursor with the dynamic option?

547

What is oltp (online transaction processing)?

581

What is the default schema of your login session in ms sql server?

584

How to assign new column names in a view?

505

What is sql service broker?

586

Can foreign key be duplicate?

623

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

546

How do I view views in sql server?

514

what is the Ticketing tool used in Wipro technologies at Bangalore...???

7472

What are different types of join?

756

Explain transaction server auto commit?

531