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 the command dbcc checkdb used for?
How can we delete a table in sql server?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What are the Advantages of using CTE in sql server?
How to get a list all databases on the sql server?
How to update values in a table with update statements in ms sql server?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
explain extended properties
Explain Geography datatype in SQL Server
What different steps will a sql server developer take to secure sql server?
whats new about truncate in sql server 2008?
What is the native system stored procedure to execute a command against all databases?
What is default constraint?
How to query multiple tables jointly?
What is the difference in accessing db between sql server vs sql azure?