?????????????????????????

????1. ASP??Access??????????
<%@ language=VBscript%>
<%
dim conn??mdbfile
mdbfile=server.mappath("?????????.mdb")
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver
(*.mdb)};uid=admin;pwd=?????????;dbq="&mdbfile
%>
????2. ASP??SQL??????????
<%@ language=VBscript%>
<%
dim conn
set conn=server.createobject("ADODB.connection")
con.open "PROVIDER=SQLOLEDB;DATA
SOURCE=SQL???????????IP???;UID=sa;PWD=?????????;DATABASE=?????????
%>
?????????????????
????set rs=server.createobject("adodb.recordset")
????rs.open SQL???conn??3??2
????3. SQL??????????÷?????
????(1) ??????????
sql="select * from ????? where ?????=???? order by ????? [desc]"
sql="select * from ????? where ????? like '%????%' order by ????? [desc]"
sql="select top 10 * from ????? where ????? order by ????? [desc]"
sql="select * from ????? where ????? in ('?1'??'?2'??'?3')"
sql="select * from ????? where ????? between ?1 and ?2"
????(2) ????????????
sql="update ????? set ?????=???? where ????????"
sql="update ????? set ???1=?1?????2=?2 …… ???n=?n where ????????"
????(3) ???????????
sql="delete from ????? where ????????"
sql="delete from ?????" (??????????м?????)
????(4) ???????????
sql="insert into ????? (???1?????2?????3 …) values (?1???2???3 …)"
sql="insert into ???????? select * from ??????" (???????????????????????)