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
Can you explain various data region available in ssrs with their use?
Explain various On-Delete options in a DB table. Which is the default option?
Write SQL queries on Self Join and Inner Join.
What is the library index called?
Explain indexes disadvantages?
what is denormalization? : Sql server database administration
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
Define tool Manage Statistics in SQL Server 2000 query ?
Can sql servers linked to other servers like oracle?
Explain the disadvantages/limitation of the cursor?
What can be used instead of trigger?
Is there any difference between the primary key and unique key?
Can we use having clause without group by?
What are the different subsets of sql?
How to convert a table data in XML format in sql server?