[dba-SQLServer]Generate Insert Statements

Mark L. Breen subs at solution-providers.ie
Tue May 13 08:53:41 CDT 2003


Hello Arthur,

Is that what I think it is?

I have been considering writing a tool for a while that will concatenate
onto the script that EM can generate that would repopulate my tables for me,
especially with ones with the ID set to 0,

At a glance, it looks like he has done it for us,

Tks

Mark



----- Original Message -----
From: "Arthur Fuller" <artful at rogers.com>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Tuesday, May 13, 2003 1:51 PM
Subject: [dba-SQLServer]Generate Insert Statements


> While pondering how to write a sproc that would generate inserts, I came
> across this wonderful chunk of code that does everything we could want.
> Since it's a no-brainer to generate CREATE TABLE scripts, with this script
> in hand, any and all of us can quickly generate a script enabling fellow
> listers to create a database, the requisite tables, and some sample data.
> Thus complex questions can be posed, along with a script to recreate the
> gory details.
>
> Get the generate-insers script here:
> http://vyaskn.tripod.com/code/generate_inserts.txt. IMO it is a very slick
> hunk of T-SQL.
>
> Arthur
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>




More information about the dba-SQLServer mailing list