This topic is locked

SQL Statements in ASP

7/18/2008 10:38:47 AM
ASPRunnerPro General questions
M
mccreelake author

Hey Everyone out there:
I am a fairly novice code, although I do edit some of the code generated by the ASPRunner software to fit my needs. I am really trying to migrate my database away from MS Access and toward ASP because I have a migration to SQL server planned.
Anyway, one of the things I can figure out how to do is convert the "T_SQL" statements in Access (INSERT, DELETE queries, etc.) to something I can use in ASP. Can anyone point in the right direction as to how to use ASP Runner to do this or some code that would help. I would really appreciate it.
Basically, what I need to do is INSERT lots records from "TABLE A" and "assign them" to a master record in "TABLE B"
Thanks for help in advance!

Sergey Kornilov admin 7/22/2008

You can use the same SQL statements in ASP. No conversion is required in most cases.