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
what is database replicaion? : Sql server database administration
What is “asynchronous” communication in sql server service broker?
What is the security principal at the server level that represents your session?
What is report subscription?
Can you explain the disadvantages/limitation of the cursor?
What is cdc in sql server?
How is SQL Azure different than SQL server?
What is the difference between an index and a unique index?
What do you mean by 'normalization'?
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?
What you can do to delete a table without the delete trigger firing?
Do you know what is a linked server in sql server?
How to replace given values with null using nullif()?
What is report server project?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?