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 command dbcc checkdb used for?

974

How can we delete a table in sql server?

936

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

903

What are the Advantages of using CTE in sql server?

1065

How to get a list all databases on the sql server?

1040

How to update values in a table with update statements in ms sql server?

971

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1063

explain extended properties

937

Explain Geography datatype in SQL Server

1076

What different steps will a sql server developer take to secure sql server?

948

whats new about truncate in sql server 2008?

2458

What is the native system stored procedure to execute a command against all databases?

983

What is default constraint?

947

How to query multiple tables jointly?

933

What is the difference in accessing db between sql server vs sql azure?

174