Geeks With Blogs
Matt Watson Software developer, product visionary, and master of #dadops

Ever needed to create a script for the records in a database table?

I found a great stored proc today that can help do just that from this site:

http://vyaskn.tripod.com/code.htm#inserts

It has like every option you could ever need in it too. A must have.

They also have a ton of other cool toys for Sql Server


Check out Stackify! They provide a DevOps application dashboard for developers that gives them remote server access to everything they need to do application support!

Posted on Wednesday, January 21, 2004 6:03 PM | Back to top


Comments on this post: Sql - Generate Script for Table Data

# re: Sql - Generate Script for Table Data
Requesting Gravatar...
thanks, saved me much time
Left by m on May 04, 2007 6:10 AM

# re: Sql - Generate Script for Table Data
Requesting Gravatar...
hu hu hu!
thanks a lot, U saved many hours.
I have been looking for something like this for a long time.
LOL
Left by Loloto on Jun 12, 2008 4:08 PM

# re: Sql - Generate Script for Table Data
Requesting Gravatar...
When i am executing the above SP with columns whose total length is greater than 128 characters it is giving me an error.

My SP

EXEC sp_generate_inserts @table_name = fieldmaster, @cols_to_include = "'intReportFieldID','intReportTypeID','vcrFieldName','vcrEclerxFieldCaption','vcrCsFieldCaption','bitActive','bitEconomic','bitShow'"

The error :

The identifier that starts with ''intReportFieldID','intReportTypeID','vcrFieldName','vcrEclerxFieldCaption','vcrCsFieldCaption','bitActive','bitEconomic','bitSh' is too long. Maximum length is 128.

i know that identifiers do not take more than 128 characters but is there some other way round?? Can anyone help me with this?? Thanks in advance.
Left by dhaval on Jun 16, 2008 8:38 AM

# re: Sql - Generate Script for Table Data
Requesting Gravatar...
Hi guys,

I am looking for some help, to generate the scripts of table in SQL2005 / 2008 ,
Many thanks.

Manish
Left by Manish K on Oct 20, 2008 1:53 AM

# re: Sql - Generate Script for Table Data
Requesting Gravatar...
Hi guys..

i need a way to generate a full script of a Database build in SQL Anywhere 10.0.0...including stored procedures, triggers, etc...

Thanx.
Left by May on Nov 13, 2008 3:55 PM

# re: Sql - Generate Script for Table Data
Requesting Gravatar...
http://www.codeplex.com/Wiki/View.aspx?ProjectName=sqlhost&title=Database%20Publishing%20Wizard

downlaod the Database publishing wizard from the above link. It can help you script database schema and data. I have used this only in SQL server DBs
Left by Menita on Apr 15, 2009 10:48 AM

# re: Sql - Generate Script for Table Data
Requesting Gravatar...
Excellent post - Thanks for sharing.
Left by Nw on May 08, 2009 5:13 AM

# re: Sql - Generate Script for Table Data
Requesting Gravatar...
This post was a great help, thanks alot guys, cudos to Narayana Vyas Kondreddi!
Left by Marius on Jun 15, 2009 6:01 AM

# re: Sql - Generate Script for Table Data
Requesting Gravatar...
That's dude.
Left by Tenzin on Aug 04, 2009 10:10 AM

# re: Sql - Generate Script for Table Data
Requesting Gravatar...
Thanks mate, that saved me hell lot of time.
Left by VINOD on Sep 03, 2009 11:17 PM

# re: Sql - Generate Script for Table Data
Requesting Gravatar...
hey gyus i m looking for scripts in sql pls help me out
Left by ashish on Sep 14, 2009 11:56 PM

# re: Sql - Generate Script for Table Data
Requesting Gravatar...
Download and install free SSMS tools (http://www.ssmstoolspack.com/)
Left by Lijo on Nov 17, 2009 6:05 AM

# re: Sql - Generate Script for Table Data
Requesting Gravatar...
I am using MDBScript(http://www.mdbscript.com), it works well for me.
Left by brian on Feb 17, 2010 11:20 PM

# re: Sql - Generate Script for Table Data
Requesting Gravatar...
You can use free tool Mygeneration in Microsoft SQL Server/Data/Built inserts from table
Left by Raef on May 21, 2010 5:31 AM

# re: Sql - Generate Script for Table Data
Requesting Gravatar...
Thank you
Left by Ismady Asmavy on Jun 21, 2011 11:42 PM

# re: Sql - Generate Script for Table Data
Requesting Gravatar...
no coments
Left by siva on Aug 07, 2011 11:15 PM

# re: Sql - Generate Script for Table Data
Requesting Gravatar...
I want to know about,how to create script to particular database files.
Left by Md.Waseem on Oct 08, 2011 4:33 AM

Your comment:
 (will show your gravatar)


Copyright © Matt Watson | Powered by: GeeksWithBlogs.net