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

Answer Posted / skybeaver

Use the BCP utility

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

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is database replicaion? : Sql server database administration

617


What is “asynchronous” communication in sql server service broker?

551


What is the security principal at the server level that represents your session?

571


What is report subscription?

93


Can you explain the disadvantages/limitation of the cursor?

511






What is cdc in sql server?

580


How is SQL Azure different than SQL server?

93


What is the difference between an index and a unique index?

556


What do you mean by 'normalization'?

615


what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

543


What you can do to delete a table without the delete trigger firing?

538


Do you know what is a linked server in sql server?

559


How to replace given values with null using nullif()?

582


What is report server project?

106


Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

591