Automate Writing Basic SQL Statements * SAVES LOTS OF TIME*

The code creates SQL Statements on the fly. You don't have to sit and go thru that huge database creating a page long SQL statement. This little asp page allows you to select the DSN and the table name and it will generate the UPDATE / INSERT and DELETE statements for you. The other great thing this does is creat those request.querystring and request.form statements that you need to add if you are going to pass data from page to page. It does a trim on all fields and a replace for apostrophes, so the database does not throw an error. THE UPDATE AND DELETE REQUIRE YOU AD A WHERE CLAUSE. YOU WILL SEE THE TEXT WHERE CONDITION AFTER THEM. You can try it online at: http://www.biondocom.com/psc/dynamicsql/