Entry

What is the best method to use for adding new records to a database? Should I use an SQL statement or an ADO?

May 20th, 2000 06:20
unknown unknown, Vijay Kumar, Kevin D

Pros and cons to both. ADO is easier from a programmer's standpoint, but 
it requires more processing power on the part of the computer that is 
hosting the web site (providing your DB server is on a different 
computer). Also, depending on how your DB server is configured, ADO 
might be a bit slower. ADO is also MS specific (ie if you need ever to 
use a different web server than IIS, forget about it).

SQL is universal, and if you use SQL server or Oracle DB servers running 
on a machine separate from your web server, it might be a bit faster.

If you want to use SQL:

INSERT INTO[tablename](columnname1,
coloumnname2)VALUES(1, 2)