AccessSQL语句的添加（国外英文资料）.doc

AccessSQL语句的添加（国外英文资料） Add, delete, and modify the ASP Access SQL statement Limaokkk @2006-0940 SQL statements are added, deleted, modified SQL statements to add, delete, modify, although there are a lot of kinds of methods, but in the process of using or not enough to use, I dont know whether there is a master set more flexible usage contribution out? Add, delete, and modify the db.execute (Sql) command to perform the operation ╔ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- ╗ The data recording is filtered ╚ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- ╝ Note: the use of single and double quotes may be incorrect (there is no measurement) Sql = Select Distinct field name From the data table The Distinct function, which queries the records that are not repeated in the data inventory table Sql = Select Count () From the data table where field name 1 # 1800 # and field name 1 # 1900 # The count function, querying how many records in the library table, field name 1 means the same field Ex. : Select count (id) as idnum from news Response. Write rs (idnum) SQL = select from data table where field name between value 1 and value 2 Sql = select from data table where field name between # 2003-8-10 # and # 2003-8-12 # Look for all records in 2003-8-2003-8-12 for 2003-8for the date class value, regardless of the points. Select from tb_name where datetime between # 2003-8-10 # and # 2003-8-12 # The data format in the field is: 2003-8-10 195508, and the records of 2003-8-2003-8-12 are detected by SQL, regardless of the points. 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] Fuzzy query Sql = select top 10 from the data table where field name order by field name [desc] Find the first 10 records in the database Sql = select top n form data table order by newid () The method of randomly retrieving a number of records in a database Top n, n is the nu