正在阅读：ASP连接11种数据库语法总结ASP连接11种数据库语法总结

Insert into table(field1,field2,....) Values (value1,value2,....)

insert into book (bookno,author,bookname) values (’CF001’,’cancer’,’Cancer无组件上传程序’)

strno=request.form("bookno")
strau=request.form("author")
strname=request.form("bookname")
strsql="insert into book (bookno,author,bookname) values (’"&strno&"’,’"&strau&"’,’"&strname&"’)"

rs.addnew
rs("field1").value=value1
rs("field2").value=value2
...
rs.update

update table set field1=value1,field2=value2,...where fieldx=valuex

update book set author=’babycrazy’ where bookno=’CF001’

strno=request.form("bookno")
strau=request.form("author")
strsql="update book set author=’"&strau&"’ where bookno=’"&strno"’"