Sql - Generate Script for Table Data

<< Sql Compare | Home | Auto/Car VIN Decoding >>

Sql - Generate Script for Table Data

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.

Print | posted on Wednesday, January 21, 2004 6:03 PM |

Feedback

# re: Sql - Generate Script for Table Data

thanks, saved me much time

5/4/2007 6:10 AM | m

# re: Sql - Generate Script for Table Data

hu hu hu!
thanks a lot, U saved many hours.
I have been looking for something like this for a long time.
LOL

6/12/2008 4:08 PM | Loloto

# re: Sql - Generate Script for Table Data

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.

6/16/2008 8:38 AM | dhaval

# re: Sql - Generate Script for Table Data

Hi guys,

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

Manish

10/20/2008 1:53 AM | Manish K

# re: Sql - Generate Script for Table Data

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.

11/13/2008 3:55 PM | May

# re: Sql - Generate Script for Table Data

Check out http://www.sqlscripter.com to generate data scripts for SQL Server. All DML commands (Insert, Update, Delete) are supported.

3/1/2009 6:08 AM | Thomas

# re: Sql - Generate Script for Table Data

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

4/15/2009 10:48 AM | Menita

# re: Sql - Generate Script for Table Data

Excellent post - Thanks for sharing.

5/8/2009 5:13 AM | Nw

# re: Sql - Generate Script for Table Data

This post was a great help, thanks alot guys, cudos to Narayana Vyas Kondreddi!

6/15/2009 6:01 AM | Marius

# re: Sql - Generate Script for Table Data

That's dude.

8/4/2009 10:10 AM | Tenzin

# re: Sql - Generate Script for Table Data

Thanks mate, that saved me hell lot of time.

9/3/2009 11:17 PM | VINOD

# re: Sql - Generate Script for Table Data

hey gyus i m looking for scripts in sql pls help me out

9/14/2009 11:56 PM | ashish

# re: Sql - Generate Script for Table Data

Hi all,

Could you please anyone help me in writing a script for removing data from History tables and it should be scheduled for daily at a particular time..

10/8/2009 4:46 AM | Darshan M R

# re: Sql - Generate Script for Table Data

Download and install free SSMS tools (http://www.ssmstoolspack.com/)

11/17/2009 6:05 AM | Lijo

Matt Watson

My Links

News

Archives

My Links