SQL程序员参考手册

译者序

作者简介

致谢

引言

第一部分 数据类型

Bfile

Binary

Bit

Blob

Byte

Character

Clob

Counter

Currency

Date

Datetime

Dbclob

Decimal

Double Precision

Float

Graphic

Guid

Identity

Image

Integer

Interval

Logn

Logn Raw

Logn Varchar

Logn Vargraphic

Longbinary

Memo

Money

Mlslabel

Nchar

Nclob

Number

Numeric

Nvarchar

Raw

Real

SErial

Short

Shortdatetime

Single

Smaldatetime

Smallint

Smallmoney

Text

Time

Timestampo

Tinyint

Varbit

Varbinary

Varchar

Vargraphic

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

+

-

*

/

=

<

<=

>

>=

<>

()

%found

%isopen

%rowcount

%rowtype

%type

||

Abs

Acos

And

Ascii

Asin

Atan

Atan2

Avg

Between

Bit_length

Blob

Case

Cast

Ceiling

Char

Chr

Character_Length

Clob

Coalesce

Collchar

Concat

@@Connections

Convert

Cos

Cosh

Cot

Count

@@Cpu_busy

Current Data

Current_date

Current Degree

current Explain Mode

Current Explain Snapshot

Currnet Function Path

Current Node

Current Query Optimizartion

Currnet Server

Current Time

Currnet_Time

Current Timstamp

Current Timezone

Current_User

@@Cursor_rows

Date

@@Datefirst

Day

Dayname

Dayofweek

Dayofyear

Days

Dbaniwarn

Dbapicode

Dbblobbuf

Dbclob

Dbdate

Dbdelimiter

Dbedit

Dblang

Dbmoney

Dbnls

Dbpath

Dbspacetemp

Dbtime

@@Dbts

Dbupspace

Decimal

Dergress

Delimident

Difference

Digits

Double

@@Error

Envent_mon_state

Exists

Exp

Extract

Fet_buf_size

@@Fetch_status

Float

Floor

Generate_unique

Graphic

Hex

Hextoraw

Hour

@@Identity

@@Idle

In

IHformixconretry

Informixcontime

Informixdir

Informixstacksize

Informixserver

Insert

Intger

@@Io_busy

Julian_day

Lang

@@Langid

@@Language

Lc_collate

Lc_ctype

Lc_monetary

Lc_numeric

Lc_time

Lcase

Left

Length

Like

Locate

Log

Log10

Log_varchar

Logn_vargraphic

Lower

Ltrim

Max

@@Max_connections

@@Max_precision

Microsecond

@@Microsoftversion

Midnight_seconds

Min

Minute

Mod

Month

Monthname

@@Nestlevel

Nodef\dac

Nodenumber

Not

Null

Nulif

Octet_Length

Onconfig

Or

@@Pack_received

@@Pack_sent

@@Packet_srrors

Partition

path

Pi

Position

Posstr

Power

@@Procid

Quarter

Radians

Raise_error

Rand

Real

@@Remserver

Repeat

Replace

Right

Round

@@Rowcount

Rtim

Second

@@SErvername

Session_use

Sign

Sin

Sinh

Smallint

Soundex

Space

@@Spid

Sqrt

Substr

Substring

Sum

System_user

Table_name

Table_schema

Tan

Tanh

@@Textsize

Time

Tjimestamp

Timestamp_iso

Timestampdiff

@@Timeticks

To_char

To_date

To_multi_byte

To_number

To_single_byte

Translate

Translate

Trim

@@Total_errors

@@Total_read

@@Total_write

@@Trancount

Truncate

Ucase

Upper

User

Value

Varchar

Vargraphic

@@Version

Week

Yewr

第三部分 语句

Alter Bufferpool

Alter Cluster

Alter Database

Alter Function

Alter Index

Alter Nodegroup

Alter Procedure

Alter Table

Alter Tablespace

Alter Trigger

Alter View

Begin Declare SEction

Begin Work

Call

Close

Comment On

Commit

Connect

Create Bufferpool

Create Cluster

Create Controlfile

Create Database

Create Default

Create Distinct Type

Create Event Monitor

Create Function

Create Index

Create Nodegroup

Create Procedure

Create Rule

Create Schema

Create Synonym

Create Table

Create Tablespace

Create Trigger

Create View

Create Cursor

Delete

Describe

Disconnect

Drop Bufferpool

Drop Cluster

Drop Database

Drop Default

Drop Distinct Type

Drop Event Monitor

Drop Function

Drop Index

Drop Nodegroup

Drop Package

Drop Procedure

Drop Rule

Drop Schema

Drop Synonym

Drop Table

Drop Tablespace

Drop Trigger

Drop View

End Declare Section

Execute

Execute Procedure

Fetch

Flush

Free

Free Locator

Grant

Include

Info

Insert

Lord Form

Lock Table

Open

Output

Prepare

Put

Raiserror

Recover

Release

Rename Column

Rename Database

Renmae Table

Revoke

Rollback

Select

Set Connection

Setuser

Shutdown

Signal Sqlstate

STart Violations Table

Stop Violation Table

Truncate Table

Unlock Table

Update

Update Statistics

Use

Values

Whenever

附录 创建例子数据库