Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Can you explain various data region available in ssrs with their use?

1020


Explain various On-Delete options in a DB table. Which is the default option?

1532


Write SQL queries on Self Join and Inner Join.

1215


What is the library index called?

1109


Explain indexes disadvantages?

1141


what is denormalization? : Sql server database administration

973


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?

1689


Define tool Manage Statistics in SQL Server 2000 query ?

1166


Can sql servers linked to other servers like oracle?

1008


Explain the disadvantages/limitation of the cursor?

1008


What can be used instead of trigger?

1207


Is there any difference between the primary key and unique key?

1042


Can we use having clause without group by?

1030


What are the different subsets of sql?

1616


How to convert a table data in XML format in sql server?

2595