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

Explain few examples of RDBMS?

1047

What is wide table?

955

What is merge?

1026

Can foreign key be deleted?

930

why would you call update statistics? : Sql server database administration

1098

Explain why variables called the most powerful component of ssis?

1110

What is indexed view? How to create it?

1022

explain different types of joins? : Sql server database administration

993

Can we check locks in database? If so, how can we do this lock check?

951

Can we install sql server 2016 on windows 7?

1145

What is the maximum row of a size?

1022

What is the difference between functions and stored procedures?

1172

How is foreign key related to primary key?

978

Explain what is the function of sql server agent windows service?

1001

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2792