Posted by Erland Sommarskog on 10/24/07 21:19

Artie (artie2269@yahoo.com) writes:
> I did not post the full DDL because there are so many fields that are not
> relevant and felt it would complicate things. It would open up a can of
> worms as to why it is desgined the way it is (I did not design it).

In many cases it's better to post a simplied schema that captures the
essence of the problem.

> Do you guys (or gals) have a preferred method of generating insert
> statements that pull data from the table? I have used sp_generate_inserts
> from http://vyaskn.tripod.com but have run into some cases where the 8000
> char limit was not enough.

I haven't looked in to Vyas's code, but if you are on SQL 2005, it should
be easy to modify it to use varchar(MAX) rather than varchar(8000).

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]