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

常用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 = select * from data table where field name between value 1 and 2 (2) updating data records: SQL = update data table set field name = field value where conditional expression SQL = update data table set field 1 = value 1, field 2 = value 2... field n = value n where condition expression (3) delete data records: SQL = delete from data table where condition expression SQL = delete from data table (delete any records from the data table) (4) adding data records: SQL = insert into data table (field 1, field 2, field 3...) values (value 1, value 2, value 3...) SQL = insert into target data table select * from source data table (add the record of the source data table to the target table) (5) data recording statistics function: The AVG (field name) yields a table bar average COUNT (* | field name) statistics on the number of data rows or data rows with values in a column MAX (field name) takes the maximum value of a table bar MIN (field name) takes the minimum value of a table column SUM (the field name) adds the value of the data column How to refer to the above functions: SQL = select sum (field name) as alias from the data table where condition expression Set the rs = conn. Excute (SQL) Use the rs ( alias ) to obtain the systems value, and the other functions apply the same. (5) the establishment and deletion of data tables: The CREATE TABLE data TABLE name (field 1 type 1 (length