ketankshah
IS-IT--Management
Is there any way I can create an SQL file with INSERT statements from the existing data of a table?
Ketan
Ketan
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Create INSERT SQLs from Data
- Thread starter ketankshah
- Start date
- Status
It is possible, but you will not be able to create it or it will be hard to create it for fields with large data (text, character more than 255, binary).
It is MUCH better to use bulk copy, much more quick. Take a look to the BCP.EXE utility, or to the BULK INSERT command.
Vlad Grynchyshyn
vgryn@softserve.lviv.ua
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is MUCH better to use bulk copy, much more quick. Take a look to the BCP.EXE utility, or to the BULK INSERT command.
Vlad Grynchyshyn
vgryn@softserve.lviv.ua
The professional level of programmer could be determined by level of stupidity of his/her bugs
tlbroadbent
MIS
You may find the answer you need at SWYNK.COM. Check this page for the download of a script to "Generate Insert Statements Easily ".
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
- Status
Similar threads
