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
显示全部