常用sql语句 指针 记录集对象等信息（国外英文资料）.docVIP

常用sql语句 指针 记录集对象等信息（国外英文资料） ASP and Access database connection: ASP and SQL database connection: Establish a record set object: Set rs = server.createobject ( adodb.recordset ) Open SQL statement, conn, 3, 2 SQL common command usage: (1) data recording screening: SQL = select * from data table where field name = field value order by field name [desc] SQL = select * from data table where field name like % order by field name [desc] SQL = select top 10 * from data table where field name order by field name [desc] SQL = select * from data table where field name in (value 1, value 2, value 3) SQL