Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Populate Table

Author  Topic 

1fred
Posting Yak Master

158 Posts

Posted - 2002-09-24 : 17:30:18
Is there a tool in sql server, that will put in a txt file all the inserts I need to populate my table.

Something like:
insert Into TTableT values(1,3,4)

Thanks

Fred

MichaelP
Jedi Yak

2489 Posts

Posted - 2002-09-24 : 17:55:24
Not that I found. I had to write one.
I wish I could share it with you, but I can't. I'm pretty sure there are tools out there that do this, and a few of them may be free.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page

jasper_smith
SQL Server MVP &amp; SQLTeam MVY

846 Posts

Posted - 2002-09-24 : 17:55:58
[url]http://vyaskn.tripod.com/code.htm#inserts[/url]


HTH
Jasper Smith
Go to Top of Page

MichaelP
Jedi Yak

2489 Posts

Posted - 2002-09-24 : 19:34:31
You better belive that helps!! Well it helps me sine my program isn't perfect.

Thanks!!

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page
   

- Advertisement -