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

How do I find the sql server instance name?

918

What are the properties and different types of sub-queries?

958

What is a heap?

981

Is it safe to delete log files?

867

Explain the difference between delete,drop and truncate in SQL Server?

1018

What are built in functions?

951

What to check if a User database is locked?

1017

Differentiate between truncate vs delete in mssql?

994

What is a trigger and types of a trigger?

923

If no size is defined while creating the database, what size will the database have?

923

What do you understand by recursive stored procedures?

937

What are the types of subscriptions in SQL Server replication?

961

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

882

What is the return type of executeupdate ()?

857

What is the index requirement in SQL Azure?