【译文】如何使用Access SQL 检索记录(一)
时 间:2014-02-17 09:24:13
作 者:周芳 ID:24526 城市:上海
摘 要:如何使用Access SQL 检索记录
正 文:
来自:微软 翻译:周芳
【译文】 如何使用Access SQL 检索记录
最基本、最常用的SQL语句是Select语句。Select语句是所有SQL语句的核心组成部分,而它们通常称为Select查询。使用Select语句从数据库表中检索数据,并且返回的结果通常是由任意数量的字段(或列)组成的一组记录(或行)。你必须使用FROM子句指定表或表来选择。Select语句的基本结构是:
VBA:
Select field list
FROM table list
要查询表中的所有字段,用星号(*)。例如,以下语句是从客户表中查询所有的字段和记录。
VBA:
Select *
FROM tblCustomers
限制查询检索的字段,只需使用字段名。例如:
VBA:
Select [Last Name], Phone
FROM tblCustomers
在结果集字段指定一个不同的名称,使用关键字建立该字段的别名。
VBA:
Select CustomerID AS [Customer Number]
FROM tblCustomers
【原文】 How to: Retrieve Records Using Access SQL
The most basic and most often used SQL statement is the Select statement. Select statements are the workhorses of all SQL statements, and they are commonly referred to as select queries. You use the Select statement to retrieve data from the database tables, and the results are usually returned in a set of records (or rows) made up of any number of fields (or columns). You must use the FROM clause to designate which table or tables to select from. The basic structure of a Select statement is:
VBA:
Select field list
FROM table list
To select all fields from a table, use an asterisk (*). For example, the following statement selects all the fields and all the records from the Customers table.
VBA:
Select *
FROM tblCustomers
To limit the fields retrieved by the query, simply use the field names instead. For example.
VBA:
Select [Last Name], Phone
FROM tblCustomers
To designate a different name for a field in the result set, use the AS keyword to establish an alias for that field.
VBA:
Select CustomerID AS [Customer Number]
FROM tblCustomers
Access软件网QQ交流群 (群号:54525238) Access源码网店
常见问答:
技术分类:
源码示例
- 【源码QQ群号19834647...(12.17)
- 【Access选项卡示例】Ac...(09.09)
- 【Access源码示例】按输入...(09.02)
- 【Access日期区间段查询】...(08.29)
- 【Access日期区间段查询】...(08.27)
- Access怎样才能实现日期时...(08.21)
- 【Access定时打开查询】A...(08.19)
- Access生成固定数量的记录...(08.13)
- Access怎样才能实现日期时...(08.12)
- Access利用导航窗体控件对...(08.03)
学习心得
最新文章
- Access表中的字段名、字段标题...(09.19)
- Access快速开发平台--更改“...(09.18)
- 【中秋及国庆优惠】Access培训...(09.15)
- Access如何将日期型的数值转换...(09.14)
- 英文输入法输入数据中存在单引号引起...(09.11)
- 【Access选项卡示例】Acce...(09.09)
- 让Access光标停留在指定的控件...(09.07)
- 关于Access查询条件里使用通配...(09.06)
- Access报表偷懒制作法--Ac...(09.05)
- Access快速开发平台--窗体数...(09.04)