Auto Create SQL from Table

Printable View

May 15th, 2002, 11:13 AM

Auto Create SQL from Table

Anyone have a tool that will automatically create SQL INSERT & UPDATE statements from a table?

Thanks in advance!

Joan
May 15th, 2002, 11:27 AM
Bonker Gudd

I might be able to help, what database are you using?
May 15th, 2002, 11:31 AM

I would like it in Access now, but I could see myself wanting to use the same tool with SQL-Server. :)
May 15th, 2002, 11:37 AM
Bonker Gudd

Nuts, I've got something in Oracle.

Have a search around the Forum, I expect someone has posted something similar to what you need, e.g. I remember seeing an automatic SP generator for SQL Server posted on here.
May 15th, 2002, 11:42 AM

Quote:

Have a search around the Forum, I expect someone has posted something similar to what you need, e.g. I remember seeing an automatic SP generator for SQL Server posted on here.

I did find this thread here but no one posted any real good answer.

Quote:

Nuts, I've got something in Oracle.

If you did it in VB for Oracle, and wouldnt mind me hacking up the code to work with SQL.. I wouldnt mind changing it.

Maybe I should build one from scratch... I believe .NET has something called command builder or something. Ill have to look into that.

Joan
May 15th, 2002, 12:20 PM
Bonker Gudd

It's an Oracle SP that creates SPs, so I don't think it'll be much use for you, I'll email it to you if you want.

I'm sure I had an SQL Server SP for creating SPs, I'll try and find it...
May 15th, 2002, 12:28 PM
JoshT

Well, for MS SQL you could use the SQLDMO objects to get enough info from the table to do it yourself - I've tried doing this for sprocs, its easy, I just haven't had the time to finish it. I also want to write a tool that will automatically write ASP/VBScript code to call to sprocs.
May 15th, 2002, 12:37 PM

Quote:

Well, for MS SQL you could use the SQLDMO objects to get enough info from the table to do it yourself - I've tried doing this for sprocs, its easy, I just haven't had the time to finish it. I also want to write a tool that will automatically write ASP/VBScript code to call to sprocs.

Thats what I just started.. After i get the INSERTS & UPDATES, im going to auto generate an ASP class off of the table too. :) Im still open to looking at someone elses code though to help me get along.

I'll obviously share the code when or if i finish.

Joan