SEO

#1 (**permalink**) 02-29-2008, 02:21 AM

does anyone know if there is a way to generate an insert script based
on the records in a table? I want to distribute the contents of a
couple of tables to customers without having to use BCP or DTS.

Greetings Sjaak

#2 (**permalink**) 02-29-2008, 02:22 AM

"Sjaak van Esdonk" <sjaakvanesdonk@hotmail.com> wrote in message
news:7479e65c.0404050347.1105649b@posting.google.c om...
> does anyone know if there is a way to generate an insert script based
> on the records in a table? I want to distribute the contents of a
> couple of tables to customers without having to use BCP or DTS.
>
> Greetings Sjaak

http://vyaskn.tripod.com/code.htm#inserts
http://www.rac4sql.net/objectscriptr_main.asp

Simon

#3 (**permalink**) 02-29-2008, 02:22 AM

Thanks Simon, thats exactly what i needed! This is going to save me lots of time !

#4 (**permalink**) 02-29-2008, 02:24 AM

sjaakvanesdonk@hotmail.com (Sjaak van Esdonk) wrote in message news:<7479e65c.0404050347.1105649b@posting.google. com>...
> does anyone know if there is a way to generate an insert script based
> on the records in a table? I want to distribute the contents of a
> couple of tables to customers without having to use BCP or DTS.
>
> Greetings Sjaak

Hi,
use SQL Scripter (http://www.sqlscripter.com) to create Insert, Update
or Delete scripts ...

Thomas

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Generate insert script