SQL程序员参考手册PDF电子书下载

译者序 1

作者简介 1

致谢 1

引言 1

第一部分 数据类型 1

Bfile 1

Binary 1

Bit 1

Blob 2

Character 3

Byte 3

Clob 4

Counter 5

Currency 5

Date 5

Datetime 6

Dbclob 6

Decimal 7

Double Precision 8

Float 9

Guid 10

Identity 10

Graphic 10

Image 11

Integer 11

Interval 12

Long 12

Long Raw 13

Long Varchar 13

Long Vargraphic 13

Longbinary 14

Memo 14

Nchar 15

Mlslabel 15

Money 15

Nclob 16

Number 16

Numeric 17

Nvarchar 18

Raw 19

Real 19

Serial 20

Short 20

Shortdatetime 21

Single 21

Smallint 22

Smalldatetime 22

Text 23

Smallmoney 23

Time 24

Timestamp 24

Tinyint 24

Varbit 25

Varbinary 25

Varchar 26

Vargraphic 27

* 28

/ 28

+ 28

- 28

第二部分 操作符、函数和变量 28

= 29

< 29

<= 29

> 30

>= 30

<> 30

0.000000ound 31

316sopen 31

() 31

%rowcount 32

%rowtype 32

%type 32

‖ 32

Abs 33

Acos 33

And 33

Ascii 33

Avg 34

Atan2 34

Atan 34

Asin 34

Between 36

Bit_length 37

Blob 38

Case 38

Cast 39

Ceiling 40

Char 40

Chr 41

Character_length 41

Concat 42

Collchar 42

Coalesce 42

Clob 42

@@Connections 43

Convert 43

Cos 43

Cosh 43

Cot 44

Count 44

@@Cpu_busy 45

Current Explain Snapshot 46

Current Explain Mode 46

Current Degree 46

Current_date 46

Current Date 46

Current Function Path 47

Current Node 47

Current Qucry Optimization 47

Current Server 48

Current Time 48

Current _time 48

Current Timestamp 48

Current_timestamp 48

Date 49

@@Curosr_rows 49

Current_user 49

Current Timezone 49

@@Datefirst 50

Day 50

Dayname 50

Dayofweek 51

Dayofyear 51

Days 51

Dbblobbuf 52

Dbdate 52

Dbclob 52

Dbapicofe 52

Dbansiwarn 52

Dbdelimiter 53

Dbedit 53

Dblang 54

Dbmoney 54

Dbnls 54

Dbpath 54

Dbspacetemp 55

Dbtime 55

Degrees 56

Decimal 56

Dbupspace 56

@@Dbts 56

Dlimident 57

Difference 57

Digits 57

Double 57

@@Error 58

Event_mon_state 58

Exists 58

Fet_buf_size 59

@@Fetch_status 59

Extract 59

Exp 59

Float 60

Floor 60

Generate_unique 61

Graphic 61

Hex 61

Hextoraw 62

Hour 62

@@Identity 62

@@Idle 62

In 62

Informixcontime 63

Informixconretry 63

Informixdir 64

Informixserver 64

Informixstacksize 64

Informixserver 64

Insert 64

Integer 65

@@Io_busy 65

Julian_day 65

Lc_collate 66

@@Language 66

@@Langid 66

Lang 66

Lc_ctype 67

Lc_monetary 67

Lc_numeric 68

Lc_time 68

Lcase 68

Left 69

Length 70

Like 70

Locate 71

Log10 72

Long_varchar 72

Log 72

Long_vargraphic 73

Lower 73

Ltrim 73

Max 73

@@Max_connections 74

@@Max_precision 74

Microsecond 74

@@Microsoftversion 74

Min 75

Minute 75

Midnight_seconds 75

Mod 76

Month 76

Monthname 76

@@Nestlevel 76

Nodefdac 77

Nodenumber 77

Not 77

Null 77

Nullif 78

Octet_length 78

@@Packet_errors 79

@@Pack_sent 79

Or 79

Onconfig 79

@@Pack_received 79

Partition 80

Path 80

Pi 80

Position 80

Posstr 80

Quarter 81

Radians 81

@@Procid 81

Power 81

Raise_error 82

Rand 82

Real 82

@@Remserver 83

Repeat 83

Replace 83

Right 84

Round 84

@@Rowcount 84

Rtrim 84

Sign 85

Session_user 85

Second 85

@@Servername 85

Sin 86

Sinh 86

Smallint 86

Soundex 86

Space 87

@@Spid 88

Sqrt 88

Substr 88

Substring 88

Sum 89

System_user 90

Table_name 90

Table_schema 91

Tan 91

Tanh 91

@@Textsize 91

Time 92

Timestamp 92

Timestamp_iso 92

Timestampdiff 93

@@Timeticks 93

To_char 94

To_date 96

To_multi_byte 99

To_number 99

To_single_byte 99

Translate 99

Translate 99

Trim 100

@@Total_errors 100

@@Total_read 100

@@Total_write 100

Ucase 101

Upper 101

@@Trancount 101

Truncate 101

User 102

Value 102

Varchar 102

Vargraphic 102

@@Version 103

Week 103

Year 103

Alter Cluster 104

Alter Bufferpool 104

第三部分 语句 104

Alter Database 106

Alter Function 109

Alter Index 109

Alter Nodegroup 113

Alter Procedure 113

Alter Table 114

Alter Tablespace 123

Alter Trigger 126

Call 127

Begin Declare Section 127

Alter View 127

Close 128

Comment On 128

Commit 130

Connect 130

Create Bufferpool 131

Create Cluster 132

Create Controlfile 133

Create Database 134

Create Default 137

Create Distinct Type 137

Create Event Monitor 138

Create Function 139

Create Index 143

Create Nodegroup 147

Create Procedure 147

Create Rule 151

Create Schema 151

Create Synonym 152

Create Table 153

Create Tablespace 160

Create Trigger 164

Create View 167

Create Cursor 168

Delete 168

Describe 169

Disconnect 169

Drop Bufferpool 169

Drop Cluster 169

Drop Database 170

Drop Default 170

Drop Distinct Type 170

Drop Event Monitor 170

Drop Index 171

Drop Nodegroup 171

Drop Function 171

Drop? 172

Drop Rule 172

Drop Schema 172

Drop Synonym 172

Drop Table 172

Drop Tablespace 173

Drop Trigger 173

Drop View 173

End Declare Section 173

Execute Procedure 174

Execute 174

Fetch 175

Flush 176

Free 176

Free Locator 176

Grant 176

Include 178

Info 179

Insert 179

Lord Form 180

Lock Table 181

Open 181

Prepare 182

Output 182

Put 183

Raiserror 183

Recover 184

Release 184

Rename Column 185

Rename Database 185

Rename Table 185

Revoke 185

Rollback 187

Select 188

Setuser 195

Set Connection 195

Singal Sqlstate 196

Start Violations Table 196

Stop Violation Table 197

Truncate Table 197

Unlock Table 197

Update 197

Update Statistics 199

Use 200

Values 200

Whenever 201

附录 创建例子数据库 202