图书介绍

SQL程序员参考手册pdf电子书版本下载

SQL程序员参考手册
  • (美)(W.S.弗里兹)Wayne S.Freeze著;刘丹等译 著
  • 出版社: 北京:中国水利水电出版社
  • ISBN:7508400151
  • 出版时间:1999
  • 标注页数:209页
  • 文件大小:8MB
  • 文件页数:228页
  • 主题词:

PDF下载


点此进入-本书在线PDF格式电子书下载【推荐-云解压-方便快捷】直接下载PDF格式图书。移动端-PC端通用
种子下载[BT下载速度快] 温馨提示:(请使用BT下载软件FDM进行下载)软件下载地址页 直链下载[便捷但速度慢]   [在线试读本书]   [在线获取解压码]

下载说明

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

下载的文件为RAR压缩包。需要使用解压软件进行解压得到PDF格式图书。

建议使用BT下载工具Free Download Manager进行下载,简称FDM(免费,没有广告,支持多平台)。本站资源全部打包为BT种子。所以需要使用专业的BT下载软件进行下载。如 BitComet qBittorrent uTorrent等BT下载工具。迅雷目前由于本站不是热门资源。不推荐使用!后期资源热门了。安装了迅雷也可以迅雷进行下载!

(文件页数 要大于 标注页数,上中下等多册电子书除外)

注意:本站所有压缩包均有解压码: 点击下载压缩包解压工具

图书目录

译者序 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

精品推荐