Results 1 to 8 of 8

Thread: Auto Create SQL from Table

  1. May 15th, 2002, 11:13 AM #1
    joan_fl
    Guest

    Auto Create SQL from Table

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

    Thanks in advance!

    Joan
    Reply With Quote Reply With Quote
  2. May 15th, 2002, 11:27 AM #2
    Bonker Gudd
    Bonker Gudd is offline
    Fanatic Member Bonker Gudd's Avatar
    Join Date
    Mar 2000
    Location
    Saturn
    Posts
    748
    I might be able to help, what database are you using?
    Reply With Quote Reply With Quote
  3. May 15th, 2002, 11:31 AM #3
    joan_fl
    Guest
    I would like it in Access now, but I could see myself wanting to use the same tool with SQL-Server.
    Reply With Quote Reply With Quote
  4. May 15th, 2002, 11:37 AM #4
    Bonker Gudd
    Bonker Gudd is offline
    Fanatic Member Bonker Gudd's Avatar
    Join Date
    Mar 2000
    Location
    Saturn
    Posts
    748
    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.
    Reply With Quote Reply With Quote
  6. May 15th, 2002, 11:42 AM #5
    joan_fl
    Guest
    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
    Reply With Quote Reply With Quote
  7. May 15th, 2002, 12:20 PM #6
    Bonker Gudd
    Bonker Gudd is offline
    Fanatic Member Bonker Gudd's Avatar
    Join Date
    Mar 2000
    Location
    Saturn
    Posts
    748
    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...
    Reply With Quote Reply With Quote
  8. May 15th, 2002, 12:28 PM #7
    JoshT
    JoshT is offline
    Black Cat JoshT's Avatar
    Join Date
    Nov 2000
    Location
    WNY, USA
    Posts
    4,032
    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.
    Josh
    Get these: Mozilla Opera OpenBSD
    I have books for sale: "MCSD in a Nutshell" and "VB Distributed Exam Cram" - PM me for details. Will also trade for a decent ATX Pentium 2 MB/CPU/RAM combo.
    Reply With Quote Reply With Quote
  9. May 15th, 2002, 12:37 PM #8
    joan_fl
    Guest
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width