Auto Create SQL from Table

[joan_fl]

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

Thanks in advance!

Joan

[Bonker Gudd]

I might be able to help, what database are you using?

[joan_fl]

I would like it in Access now, but I could see myself wanting to use the same tool with SQL-Server.

[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.

[joan_fl]

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.

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

[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...

[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.

[joan_fl]

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