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

Which is faster joins or subqueries?

929

What are the benefits of pl/sql packages?

1030

What is data manipulation language?

1134

What pl/sql package consists of?

1029

What are properties of the transaction?

956

What is the difference between sql and isql*plus?

1005

Are dml statements autocommit?

980

how is myisam table stored? : Sql dba

995

what is the difference between char and varchar data types? : Sql dba

996

Differentiate between % rowtype and type record.

1192

what are local and global variables and their differences? : Sql dba

1007

what is the use of double ampersand (&&) in sql queries?

1114

What is sqlite used for?

933

describe transaction-safe table types in mysql : sql dba

943

What are all different types of collation sensitivity?

973