Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (中文) » 上下文相关帮助 » SQL 语言链接

 

SQL 语法帮助

下面的列表提供指向 SQL Anywhere 文档内关于以下主题的链接:SQL Anywhere 用户可用的 SQL 语言元素、SQL 语句、数据类型及函数。

SQL 数据类型

字符数据类型

数字数据类型

Money 数据类型

位数组数据类型

日期和时间数据类型

二进制数据类型

数据类型转换

Java 和 SQL 数据类型转换

SQL 函数

函数类型

SQL 函数

SQL 语言元素

关键字

标识符

字符串

常量

运算符

表达式

搜索条件

特殊值

变量

注释

NULL 值

SQL 语句

使用 SQL 语句参考

ALLOCATE DESCRIPTOR 语句 [ESQL]

ALTER DATABASE 语句

ALTER DBSPACE 语句

ALTER DOMAIN 语句

ALTER EVENT 语句

ALTER EXTERNAL ENVIRONMENT 语句

ALTER FUNCTION 语句

ALTER INDEX 语句

ALTER LOGIN POLICY 语句

ALTER MATERIALIZED VIEW 语句

ALTER PROCEDURE 语句

ALTER PUBLICATION 语句 [MobiLink] [SQL Remote]

ALTER REMOTE MESSAGE TYPE 语句 [SQL Remote]

ALTER SERVER 语句

ALTER SERVICE 语句

ALTER STATISTICS 语句

ALTER SYNCHRONIZATION PROFILE 语句 [MobiLink]

ALTER SYNCHRONIZATION SUBSCRIPTION 语句 [MobiLink]

ALTER SYNCHRONIZATION USER 语句 [MobiLink]

ALTER TABLE 语句

ALTER TEXT CONFIGURATION 语句

ALTER TEXT INDEX 语句

ALTER TRIGGER 语句

ALTER VIEW 语句

ATTACH TRACING 语句

BACKUP 语句

BEGIN 语句

BEGIN SNAPSHOT 语句

BEGIN TRANSACTION 语句 [T-SQL]

BREAK 语句 [T-SQL]

CALL 语句

CASE 语句

CHECKPOINT 语句

CLEAR 语句 [Interactive SQL]

CLOSE 语句 [ESQL] [SP]

COMMENT 语句

COMMIT 语句

CONFIGURE 语句 [Interactive SQL]

CONNECT 语句 [ESQL] [Interactive SQL]

CONTINUE 语句 [T-SQL]

CREATE DATABASE 语句

CREATE DBSPACE 语句

CREATE DECRYPTED DATABASE 语句

CREATE DECRYPTED FILE 语句

CREATE DOMAIN 语句

CREATE ENCRYPTED DATABASE 语句

CREATE ENCRYPTED FILE 语句

CREATE EVENT 语句

CREATE EXISTING TABLE 语句

CREATE EXTERNLOGIN 语句

CREATE FUNCTION 语句(Web 服务)

CREATE INDEX 语句

CREATE LOCAL TEMPORARY TABLE 语句

CREATE LOGIN POLICY 语句

CREATE MATERIALIZED VIEW 语句

CREATE MESSAGE 语句 [T-SQL]

CREATE PROCEDURE 语句

CREATE PROCEDURE 语句 [T-SQL]

CREATE PROCEDURE 语句(外部过程)

CREATE PROCEDURE 语句(Web 服务)

CREATE PROCEDURE 语句 [T-SQL]

CREATE PUBLICATION 语句 [MobiLink] [SQL Remote]

CREATE REMOTE MESSAGE TYPE 语句 [SQL Remote]

CREATE SCHEMA 语句

CREATE SERVER 语句

CREATE SERVICE 语句

CREATE STATISTICS 语句

CREATE SUBSCRIPTION 语句 [SQL Remote]

CREATE SYNCHRONIZATION PROFILE 语句 [MobiLink]

CREATE SYNCHRONIZATION SUBSCRIPTION 语句 [MobiLink]

CREATE SYNCHRONIZATION USER 语句 [MobiLink]

CREATE TABLE 语句

CREATE TEXT CONFIGURATION 语句

CREATE TEXT INDEX 语句

CREATE TRIGGER 语句

CREATE TRIGGER 语句 [T-SQL]

CREATE VARIABLE 语句

CREATE USER 语句

CREATE VIEW 语句

DEALLOCATE 语句

DEALLOCATE DESCRIPTOR 语句 [ESQL]

声明部分 [ESQL]

DECLARE 语句

DECLARE CURSOR 语句 [ESQL] [SP]

DECLARE CURSOR 语句 [T-SQL]

DECLARE LOCAL TEMPORARY TABLE 语句

DELETE 语句

DELETE(定位)语句 [ESQL] [SP]

DESCRIBE 语句 [ESQL]

DESCRIBE 语句 [Interactive SQL]

DETACH TRACING 语句

DISCONNECT 语句 [ESQL] [Interactive SQL]

DROP CONNECTION 语句

DROP DATABASE 语句

DROP DATATYPE 语句

DROP DBSPACE 语句

DROP DOMAIN 语句

DROP EVENT 语句

DROP EXTERNLOGIN 语句

DROP FUNCTION 语句

DROP INDEX 语句

DROP LOGIN POLICY 语句

DROP MATERIALIZED VIEW 语句

DROP MESSAGE 语句

DROP PROCEDURE 语句

DROP PUBLICATION 语句 [MobiLink] [SQL Remote]

DROP REMOTE MESSAGE TYPE 语句 [SQL Remote]

DROP SERVER 语句

DROP SERVICE 语句

DROP STATEMENT 语句 [ESQL]

DROP STATISTICS 语句

DROP SUBSCRIPTION 语句 [SQL Remote]

DROP SYNCHRONIZATION PROFILE 语句 [MobiLink]

DROP SYNCHRONIZATION SUBSCRIPTION 语句 [MobiLink]

DROP SYNCHRONIZATION USER 语句 [MobiLink]

DROP TABLE 语句

DROP TEXT CONFIGURATION 语句

DROP TEXT INDEX 语句

DROP TRIGGER 语句

DROP USER 语句

DROP VARIABLE 语句

DROP VIEW 语句

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 语句 [MobiLink] [SQL Remote]

GROUP BY 子句

HELP 语句 [Interactive SQL]

IF 语句

IF 语句 [T-SQL]

INCLUDE 语句 [ESQL]

INPUT 语句 [Interactive SQL]

INSERT 语句

INSTALL EXTERNAL OBJECT 语句

INSTALL JAVA 语句

INTERSECT 子句

LEAVE 语句

LOAD STATISTICS 语句

LOAD TABLE 语句

LOCK TABLE 语句

LOOP 语句

MERGE 语句

MESSAGE 语句

OPEN 语句 [ESQL] [SP]

OUTPUT 语句 [Interactive SQL]

PARAMETERS 语句 [Interactive SQL]

PASSTHROUGH 语句 [SQL Remote]

PREPARE 语句 [ESQL]

PREPARE TO COMMIT 语句

PRINT 语句 [T-SQL]

PUT 语句 [ESQL]

RAISERROR 语句

READ 语句 [Interactive SQL]

READTEXT 语句 [T-SQL]

REFRESH MATERIALIZED VIEW 语句

REFRESH TEXT INDEX 语句

REFRESH TRACING LEVEL 语句

RELEASE SAVEPOINT 语句

REMOTE RESET 语句 [SQL Remote]

REMOVE EXTERNAL OBJECT 语句

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 语句 [T-SQL]

ROLLBACK TRIGGER 语句

SAVE TRANSACTION 语句 [T-SQL]

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 语句

START ENGINE 语句 [Interactive SQL]

START EXTERNAL ENVIRONMENT 语句

START JAVA 语句

START LOGGING 语句 [Interactive SQL]

START SUBSCRIPTION 语句 [SQL Remote]

START SYNCHRONIZATION DELETE 语句 [MobiLink]

STOP DATABASE 语句

STOP ENGINE 语句

STOP EXTERNAL ENVIRONMENT 语句

STOP JAVA 语句

STOP LOGGING 语句 [Interactive SQL]

STOP SUBSCRIPTION 语句 [SQL Remote]

STOP SYNCHRONIZATION DELETE 语句 [MobiLink]

SYNCHRONIZE SUBSCRIPTION 语句 [SQL Remote]

SYSTEM 语句 [Interactive SQL]

TRIGGER EVENT 语句

TRUNCATE 语句

TRUNCATE TEXT INDEX 语句

UNION 子句

UNLOAD 语句

UPDATE 语句

UPDATE(定位)语句 [ESQL] [SP]

UPDATE 语句 [SQL Remote]

VALIDATE 语句

WAITFOR 语句

WHENEVER 语句 [ESQL]

WHILE 语句 [T-SQL]

WINDOW 子句

WRITETEXT 语句 [T-SQL]