Hi.

I need to select data from a table and create a sql file with the insert statements using the data selected , What's the best way to do this?

Why? Particularly if there is a large volume of data, most databases have facilities to generate and consume something like a deliited text file rather efficiently. Unless you have a tool that generates such a script (Toad may), this woul require some development effort on your part.

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

Do you want to create a script of insert statments based on current data in a table? If so, supply the table structure.

In MsSQLServer
Try SELECT * FROM TABLE1 FROM TABLE1 WHERE 1=2

By MS SQL SERVER
Try

select * into table2 from table1 where 1=2