[dba-SQLServer]Generate Insert Statements

Yup, that's what it is.

Arthur

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mark L.
Breen
Sent: May 13, 2003 9:54 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer]Generate Insert Statements


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