generate insert script sql server

I’m using a backup database to do some testing.  This database already has data in it, but I would Like to add some additional data to it, possibly through a use rinterface and scripts.  If everything works well, I want to add the data that I added to backup database to another database.  I don’t want to have to do an export or Bulk Copy.  It seems like to many steps.  What I would rather have is just an insert statement the would crate the data. 
 
The following links are for script that generate insert statements:
 
This one is very simple, but I needed to change nvarchar(…)s to nvarchar(Max).
 
Here are some more links generate insert script for sql server
 
 
 

Leave a Reply

Your email address will not be published. Required fields are marked *