Hi Kiran, pls go through the below link. http://www.simple-talk.com/sql/d

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.

Question Posted / aryasen vaikom

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

Please Help Members By Posting Answers For Below Questions

How do you delete duplicates in sql query using rowid?

943

What are different functions in sql?

938

What are the parts of a sql statement?

1082

What is trigger in flip flop?

1007

What is left join in postgresql?

1041

What is the difference between local variables and global variables?

1121

what is myisam? : Sql dba

1073

What is Collation Sensitivity ? What are the various type ?

948

What is multiple partition?

962

What are views in sql?

975

Why cross join is used?

1074

What is pls integer?

1031

what's the difference between a primary key and a unique key? : Sql dba

1040

what are all types of user defined functions? : Sql dba

1040

Is delete faster than truncate?

1002