July 29, 2003 at 1:15 am
How to make script for tables Data.
I have number of records in table, i want to make a script for data in INSERT statement format. There is import and export facility, but i need in Inseret statement format
Please help me.
Thanks in Advance.
Sachin
Sachin Bhaygude
Sachin Bhaygude
July 29, 2003 at 4:42 am
Hi,
insertXpress is the product you need. It comes as a 14 day trial . A great rpoduct to generate insert statements! Hope this helps..;)
July 29, 2003 at 4:58 am
Or for free, look at a script I posted here (not mine, can't take the credit).
This version chokes on some binary data -- I've since made modifications to the script to allow it to process this kind of data, if you want that let me know and I'll post it.
July 30, 2003 at 7:52 am
dbezze will also work well for this -- see http://www.sqlservercentral.com/products/dbezze/
July 30, 2003 at 11:24 am
Hi !
SQL Scripter is able to create INSERT, UPDATE and DELETE statements (or combinations of them). It's freeware.
Regards
July 31, 2003 at 1:02 am
Dbezze is fine for small amount of rows say 2000. It keeps write to the text box , becoming heavy after a lot of rows .
July 31, 2003 at 5:27 am
just for a quick hack:
select 'insert into your_table (fld1, fld2) values (' +
char(39) + fld1 + char(39) + ', ' + char(39) + fld2 + char(39) + ')'
from your_table
don't forget to cast your field values if necessary
best regards,
chris.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply