Post: Database: Generate Inserts for MS SQL tables!

Hints And Tips research knowledge archive

Browse > Computers > Programming > Databases

Tip# 520

Sponsored Links

Subject:	Database: Generate Inserts for MS SQL tables!
Updated:	Feb-25-2008
Rating:	Not Rated
By:	Rocky Moore - Member #: 461
Location:	Klamath Falls, Oregon USA
Website:	www.ReflectedThought.com
Category:	Computers > Programming > Databases

Rate This Tip (10=Great): 1 2 3 4 5 6 7 8 9 10

Did you ever have the time when you just wanted to generate a script that would include a set of inserts to copy the contents of a table? Recently, I had an issue where my local SQL Server is not able to connect to my remote MS SQL server but still needed to copy the data of a couple tables.

Well, here is a link to a routine that has been around for a while that is a stored procedure which will generate the inserts for a specified table. Really handy! Install the SP and forget about it until you need it again!

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

[Submit DIGG for this tip]

<- Back

-----------
Note: Use the tips posted on this site at your own risk. The tips are posted by the public and as such may or may not be valid.

Categories

< Previous

Sponsor Sites To Visit

www.OrgainzedPrayer.com

Prayer changes things!
Join with other Born-Again
Christians and pray for others,
sharing the work!

Busy? Surely you can commit to
one minute of special prayer per day!

Be involved and and part of changing
lives as little as one minute per day!

CICK HERE

www.BringingInTheHarvest.com

Christian: The harvest is ripe and
the day is short, we need to bring in
the harvest while there is time!

CLICK HERE

RSS Feed

You can now get updates to the Recent Tips section by using RSS. The address is:

HintsAndTips.com/Rss.aspx

* Posting Tips *

To post a Tip, Recommendation or Tips Wanted, simply browse to the category you feel is a best fit for your post (click on the Recommention or Tips Wanted tab if fitting) and then click on "New Post" option.