. II .
5.1
逻辑表达式运算符 ..................................................................................................................42
5.2
逻辑表达式..............................................................................................................................43
5.2.1
[NOT] BETWEEN...AND................................................................................................43
5.2.2
集合操作符
[NOT] IN .....................................................................................................45
5.2.3
匹配符
LIKE ....................................................................................................................46
5.3
NULL的使用 ...........................................................................................................................50
5.4
条件表达式..............................................................................................................................52
5.4.1
AND.................................................................................................................................52
5.4.2
OR ...................................................................................................................................53
5.4.3
多个
AND . . . OR.............................................................................................................53
5.4.4
优先级和括号
.................................................................................................................54
5.4.5
NOT.................................................................................................................................54
练习 ................................................................................................................................................55
第六章
第六章第六章
第六章 数据转换和计算
数据转换和计算数据转换和计算
数据转换和计算 ....................................................................................................................57
6.1
数据类型..................................................................................................................................57
6.1.1
字符型数据
.....................................................................................................................57
6.1.2
二进制数据
.....................................................................................................................58
6.1.3
数字型数据
.....................................................................................................................59
6.1.4
图形数据
.........................................................................................................................60
6.2
算术运算符..............................................................................................................................61
6.3
T
ERADATA
算术函数 ................................................................................................................63
6.4
运用算术运算符计算 ..............................................................................................................63
6.5
系统变量..................................................................................................................................64
6.6
字符常量、数字常量和计算模式 ..........................................................................................65
6.7
对日期的处理..........................................................................................................................67
6.7.1
日期计算
.........................................................................................................................67
6.7.2
与日期有关的数据函 数
.................................................................................................68
6.7.3
利用
CAST
作数据转换
....................................................................................................70
练习 ................................................................................................................................................71
第七章
第七章第七章
第七章 简单的宏
简单的宏简单的宏
简单的宏 ................................................................................................................................74
7.1
宏的定义..................................................................................................................................75
7.2
宏的执行..................................................................................................................................75
7.3
宏的删除..................................................................................................................................75
