Generating Insert Statements

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Oleg Netchaev » Generating Insert Statements

58 posts, Page 6 of 6

«««2 3 4 5 6

Generating Insert Statements

Rate Topic

Display Mode

Topic Options

Author

Message

Emito

Posted Friday, May 14, 2010 6:21 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 8:33 AM
Points: 353, Visits: 325

You have a really good script for this in this url:

http://vyaskn.tripod.com/code/generate_inserts.txt
Written by: Narayana Vyas Kondreddi

I used a lot, its really nice!!! BigGrin

Post #921956

Oleg Netchaev

Posted Friday, May 14, 2010 8:47 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 10:53 AM
Points: 1,662, Visits: 1,709

Emito (5/14/2010)

You have a really good script for this in this url:

http://vyaskn.tripod.com/code/generate_inserts.txt
Written by: Narayana Vyas Kondreddi

I used a lot, its really nice!!! BigGrin

Yes, the old script you mention has been used by many in the past. It does not handle some data types, such as image and varbinary(max). Additionally, that script has a while loop in it used just to get column names and their data types. Using the loop is not a good idea when you can use a rather simple select statement to do the work. I specifically mentioned in the beginning of the article that I am offering no cursors, no while loops, no bunch of single quotes solution to the task of generating insert statements.

My script also suffers from data type limitations, but this is only because of the small bugs in it. For example, I simply did not check floats and handling them requires small tweaks to the script. However, my script can potentially handle the data types which are not handled by the script to which you refer.

Oleg

Post #922101

Slawomir Swietoniowski

Posted Friday, May 14, 2010 10:54 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 2:14 AM
Points: 2,885, Visits: 463

Hi,

Well, in SSMS 2008 R2 this feature (scripting data) is no longer available, so this solutions is usefull again Smile

.

Another option is to use this add-in to SSMS (it can scripting out table content): http://www.ssmstoolspack.com/.

Anyway, this solution is brilliant.

Regards

Slawomir Swietoniowski, MCITP:DBA+Developer (2005/2008)

Post #922190

SQLRNNR

Posted Friday, May 14, 2010 11:54 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

Nice article. I'm glad to have finally seen it.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #922231

Mike-1076638

Posted Friday, May 14, 2010 12:06 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 01, 2012 3:16 PM
Points: 9, Visits: 29

Oleg

The script is excellent no doubt about it.
The problem with it that it is database specific + you have to connect to the database first.

I had several situations when I was in the airport and all I had an excel file from the customer.

Likely there is another solution which can help you in time of need

http://www.dbsoftlab.com/Advanced-ETL-Processor-News/Generate-Insert-Statements.html

Keep coding,
Mike

Post #922235

Atif-ullah Sheikh

Posted Monday, May 17, 2010 3:53 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, March 14, 2013 4:15 AM
Points: 3,240, Visits: 4,960

Nice Article. Very helpful.

Thanks.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.

You can check my BLOG here

Post #922779

Federico Iori

Posted Monday, May 17, 2010 4:09 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 15, 2013 1:33 AM
Points: 31, Visits: 261

Nice script !!!
I suggest a small improving,
special handling not only of text datatype
but also of ntext

when 'ntext' then 'cast([' + column_name + '] as nvarchar(max))'

You can update your script with it

Post #922783

John Dempsey

Posted Tuesday, January 18, 2011 10:06 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, May 13, 2013 12:24 PM
Points: 908, Visits: 1,671

Slawomir Swietoniowski (5/14/2010)

Hi,

Well, in SSMS 2008 R2 this feature (scripting data) is no longer available, so this solutions is usefull again Smile

.

Another option is to use this add-in to SSMS (it can scripting out table content): http://www.ssmstoolspack.com/.

Anyway, this solution is brilliant.

Regards

Slawomir,

The scripting data feature is still available in SSMS 2008 R2, but it appears to be under a different heading from SSMS 2008. The property option is now available under the "General" header and called "Type of data to script". It has 3 options in the drop down: Data Only, Schema and data, Schema Only. For those not aware, you can get to the scripting: by right clicking the mouse on a database, Tasks > Generate Scripts... > Choose "Select specific database objects" > Select the tables you want to script > then select the "Advanced" button to get to the "Type of data to script" property.

Thanks,
John D

Post #1049506

« Prev Topic | Next Topic »

58 posts, Page 6 of 6

«««2 3 4 5 6

Permissions