SQL Anywhere Studio 帮助

SQL 语言链接

SQL 语法帮助

下面的列表提供指向 Adaptive Server Anywhere 文档中有关以下主题的链接：可供 Adaptive Server Anywhere 用户使用的 SQL 语言元素、SQL 语句、数据类型和函数。

字符数据类型

Numeric 数据类型

货币数据类型

BIT 数据类型

日期和时间数据类型

二进制数据类型

域

数据类型转换

千年虫问题

函数类型

按字母顺序排列的函数列表

关键字

标识符

字符串

运算符

表达式

搜索条件

特殊值

变量

注释

NULL 值

使用 SQL 语句参考

ALLOCATE DESCRIPTOR 语句 [ESQL]

ALTER DATABASE 语句

ALTER DBSPACE 语句

ALTER DOMAIN 语句

ALTER EVENT 语句

ALTER FUNCTION 语句

ALTER INDEX 语句

ALTER PROCEDURE 语句

ALTER PUBLICATION 语句

ALTER REMOTE MESSAGE TYPE 语句 [SQL Remote]

ALTER SERVER 语句

ALTER SERVICE 语句

ALTER SYNCHRONIZATION SUBSCRIPTION 语句 [MobiLink]

ALTER SYNCHRONIZATION USER 语句 [MobiLink]

ALTER TABLE 语句

ALTER TRIGGER 语句

ALTER VIEW 语句

ALTER WRITEFILE 语句（不建议使用）

BACKUP 语句

BEGIN 语句

BEGIN TRANSACTION 语句

CALL 语句

CASE 语句

CHECKPOINT 语句

CLEAR 语句 [Interactive SQL]

CLOSE 语句 [ESQL] [SP]

COMMENT 语句

COMMIT 语句

CONFIGURE 语句 [Interactive SQL]

CONNECT 语句 [ESQL] [Interactive SQL]

CREATE COMPRESSED DATABASE 语句（不建议使用）

CREATE DATABASE 语句

CREATE DBSPACE 语句

CREATE DECRYPTED FILE 语句

CREATE DOMAIN 语句

CREATE ENCRYPTED FILE 语句

CREATE EVENT 语句

CREATE EXISTING TABLE 语句

CREATE EXTERNLOGIN 语句

CREATE FUNCTION 语句

CREATE INDEX 语句

CREATE MESSAGE 语句 [T-SQL]

CREATE PROCEDURE 语句

CREATE PROCEDURE 语句 [T-SQL]

CREATE PUBLICATION 语句

CREATE REMOTE MESSAGE TYPE 语句 [SQL Remote]

CREATE SCHEMA 语句

CREATE SERVER 语句

CREATE SERVICE 语句

CREATE STATISTICS 语句

CREATE SUBSCRIPTION 语句 [SQL Remote]

CREATE SYNCHRONIZATION SUBSCRIPTION 语句 [MobiLink]

CREATE SYNCHRONIZATION USER 语句 [MobiLink]

CREATE TABLE 语句

CREATE TRIGGER 语句

CREATE TRIGGER 语句 [SQL Remote]

CREATE TRIGGER 语句 [T-SQL]

CREATE VARIABLE 语句

CREATE VIEW 语句

CREATE WRITEFILE 语句（不建议使用）

DEALLOCATE 语句

DEALLOCATE DESCRIPTOR 语句 [ESQL]

声明部分 [ESQL]

DECLARE 语句

DECLARE CURSOR 语句 [ESQL] [SP]

DECLARE CURSOR 语句 [T-SQL]

DECLARE LOCAL TEMPORARY TABLE 语句

DELETE 语句

DELETE（定位）语句 [ESQL] [SP]

DESCRIBE 语句 [ESQL]

DISCONNECT 语句 [ESQL] [Interactive SQL]

DROP 语句

DROP DATABASE 语句

DROP CONNECTION 语句

DROP EXTERNLOGIN 语句

DROP PUBLICATION 语句

DROP REMOTE MESSAGE TYPE 语句 [SQL Remote]

DROP SERVER 语句

DROP SERVICE 语句

DROP STATEMENT 语句 [ESQL]

DROP STATISTICS 语句

DROP SUBSCRIPTION 语句 [SQL Remote]

DROP SYNCHRONIZATION SUBSCRIPTION 语句 [MobiLink]

DROP SYNCHRONIZATION USER 语句 [MobiLink]

DROP VARIABLE 语句

EXCEPT 操作

EXECUTE 语句 [ESQL]

EXECUTE 语句 [T-SQL]

EXECUTE IMMEDIATE 语句 [SP]

EXIT 语句 [Interactive SQL]

EXPLAIN 语句 [ESQL]

FETCH 语句 [ESQL] [SP]

FOR 语句

FORWARD TO 语句

FROM 子句

GET DATA 语句 [ESQL]

GET DESCRIPTOR 语句 [ESQL]

GET OPTION 语句 [ESQL]

GOTO 语句 [T-SQL]

GRANT 语句

GRANT CONSOLIDATE 语句 [SQL Remote]

GRANT PUBLISH 语句 [SQL Remote]

GRANT REMOTE 语句 [SQL Remote]

GRANT REMOTE DBA 语句 [SQL Remote]

GROUP BY 子句

HELP 语句 [Interactive SQL]

IF 语句

IF 语句 [T-SQL]

INCLUDE 语句 [ESQL]

INPUT 语句 [Interactive SQL]

INSERT 语句

INSTALL JAVA 语句

INTERSECT 操作

LEAVE 语句

LOAD STATISTICS 语句

LOAD TABLE 语句

LOCK TABLE 语句

LOOP 语句

MESSAGE 语句

OPEN 语句 [ESQL] [SP]

OUTPUT 语句 [Interactive SQL]

PARAMETERS 语句 [Interactive SQL]

PASSTHROUGH 语句 [SQL Remote]

PREPARE 语句 [ESQL]

PREPARE TO COMMIT 语句

PRINT 语句 [T-SQL]

PUT 语句 [ESQL]

RAISERROR 语句 [T-SQL]

READ 语句 [Interactive SQL]

READTEXT 语句 [T-SQL]

RELEASE SAVEPOINT 语句

REMOTE RESET 语句 [SQL Remote]

REMOVE JAVA 语句

REORGANIZE TABLE 语句

RESIGNAL 语句

RESTORE DATABASE 语句

RESUME 语句

RETURN 语句

REVOKE 语句

REVOKE CONSOLIDATE 语句 [SQL Remote]

REVOKE PUBLISH 语句 [SQL Remote]

REVOKE REMOTE 语句 [SQL Remote]

REVOKE REMOTE DBA 语句 [SQL Remote]

ROLLBACK 语句

ROLLBACK TO SAVEPOINT 语句

ROLLBACK TRANSACTION 语句

ROLLBACK TRIGGER 语句

SAVE TRANSACTION 语句

SAVEPOINT 语句

SELECT 语句

SET 语句

SET 语句 [T-SQL]

SET CONNECTION 语句 [Interactive SQL] [ESQL]

SET DESCRIPTOR 语句 [ESQL]

SET OPTION 语句

SET OPTION 语句 [Interactive SQL]

SET REMOTE OPTION 语句 [SQL Remote]

SET SQLCA 语句 [ESQL]

SETUSER 语句

SIGNAL 语句

START DATABASE 语句 [Interactive SQL]

START ENGINE 语句 [Interactive SQL]

START JAVA 语句

START LOGGING 语句 [Interactive SQL]

START SUBSCRIPTION 语句 [SQL Remote]

START SYNCHRONIZATION DELETE 语句 [MobiLink]

STOP DATABASE 语句

STOP ENGINE 语句

STOP JAVA 语句

STOP LOGGING 语句 [Interactive SQL]

STOP SUBSCRIPTION 语句 [SQL Remote]

STOP SYNCHRONIZATION DELETE 语句 [MobiLink]

SYNCHRONIZE SUBSCRIPTION 语句 [SQL Remote]

SYSTEM 语句 [Interactive SQL]

TRIGGER EVENT 语句

TRUNCATE TABLE 语句

UNION 操作

UNLOAD 语句

UNLOAD TABLE 语句

UPDATE 语句

UPDATE（定位）语句 [ESQL] [SP]

UPDATE 语句 [SQL Remote]

VALIDATE CHECKSUM 语句

VALIDATE INDEX 语句

VALIDATE TABLE 语句

WAITFOR 语句

WHENEVER 语句 [ESQL]

WHILE 语句 [T-SQL]

WRITETEXT 语句 [T-SQL]

SQL Anywhere Studio 9.0.2
版权所有 © 1989–2005 Sybase, Inc. 部分版权所有 © 2001–2005 iAnywhere Solutions, Inc. 保留所有权利。