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 to export the table data (this table having 18 million
records) to .csv file. Please tell me is there any faster
way to export the data.

Answer Posted / aryasen vaikom

Hi Kiran,
pls go through the below link.
http://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What's the procedure?

910


Which is faster joins or subqueries?

967


Can we create table inside stored procedure?

937


What is difference between rank () row_number () and dense_rank () in sql?

1088


What is crud sql?

961


What is the purpose of design view?

993


What is the difference between an inner join and an outer join?

999


Why stored procedure is faster than query?

1033


Is id a reserved word in sql?

1132


What does seeding a database mean?

932


What is before trigger?

983


What is the primary use of normalization?

983


Can instead of triggers be used to fire once for each statement on a view?

947


How do we accept inputs from user during runtime?

1040


what are the differences among rownum, rank and dense_rank? : Sql dba

1026