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.
| Author |
Topic |
|
cecilius
Starting Member
19 Posts |
 Posted - 2003-09-10 : 13:26:39
|
| Hi all, does anybody know a tool, that can convert values from a table into sql-insert-statements.this is very useful for testing and db-initialisation.thank you very much,thomas |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-10 : 13:28:54
|
| Vyaskn wrote a stored procedure that can do this. It is mentioned in the link below:[url]http://vyaskn.tripod.com/code.htm[/url]Here is the link to the stored procedure:[url]http://vyaskn.tripod.com/code/generate_inserts.txt[/url]It is well documented, so it should be fairly easy to use.Tara |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-10 : 14:00:08
|
| Way cool...Brett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-10 : 14:03:53
|
| Vyaskn has a lot of cool stored procedures, so you should check out his site. He is one of the MS MVPers.Tara |
|
|
|
|
|
|
insert-tool