SybaseIQ15.1引用手册（SQL和Option）资源-CSDN文库

4星 · 超过85%的资源需积分: 3 193 浏览量 2009-09-02 15:56:50 上传评论收藏 6MB PDF 举报

资源推荐

资源详情

资源评论

Reference: Statements and Options

Sybase

15.1

Contents

Reference: Statements and Options iii

About This Book ........................................................................................................................... xi

CHAPTER 1 SQL Statements .............................................................................. 1

Using the SQL statement reference................................................. 1

Common elements in SQL syntax............................................. 1

Syntax conventions ................................................................... 3

Statement applicability indicators.............................................. 4

ALLOCATE DESCRIPTOR statement [ESQL]................................. 4

ALTER DATABASE statement......................................................... 6

ALTER DBSPACE statement........................................................... 9

ALTER DOMAIN statement............................................................ 13

ALTER EVENT statement.............................................................. 14

ALTER FUNCTION statement ....................................................... 16

ALTER INDEX statement............................................................... 17

ALTER LOGIN POLICY statement................................................. 19

ALTER PROCEDURE statement................................................... 20

ALTER SERVER statement ........................................................... 20

ALTER SERVICE statement .......................................................... 23

ALTER TABLE statement .............................................................. 25

ALTER USER statement................................................................ 37

ALTER VIEW statement................................................................. 38

BACKUP statement........................................................................ 41

BEGIN … END statement .............................................................. 47

BEGIN PARALLEL IQ … END PARALLEL IQ statement .............. 50

BEGIN TRANSACTION statement................................................. 51

CALL statement ............................................................................. 55

CASE statement............................................................................. 57

CHECKPOINT statement............................................................... 58

CLEAR statement [DBISQL] .......................................................... 59

CLOSE statement [ESQL] [SP]...................................................... 59

COMMENT statement.................................................................... 61

COMMIT statement........................................................................ 62

CONFIGURE statement [DBISQL]................................................. 64

CONNECT statement [ESQL] [DBISQL]........................................ 65

Contents

Sybase IQ

CREATE DATABASE statement.................................................... 68

CREATE DBSPACE statement...................................................... 81

CREATE DOMAIN statement ........................................................ 84

CREATE EVENT statement........................................................... 86

CREATE EXISTING TABLE statement.......................................... 93

CREATE EXTERNLOGIN statement ............................................. 96

CREATE FUNCTION statement .................................................... 97

CREATE INDEX statement.......................................................... 105

CREATE JOIN INDEX statement................................................. 114

CREATE LOGIN POLICY statement ........................................... 117

CREATE MESSAGE statement [T-SQL] ..................................... 119

CREATE PROCEDURE statement.............................................. 120

CREATE PROCEDURE statement [T-SQL] ................................ 127

CREATE SCHEMA statement ..................................................... 129

CREATE SERVER statement...................................................... 130

CREATE SERVICE statement..................................................... 132

CREATE TABLE statement ......................................................... 135

CREATE USER statement........................................................... 151

CREATE VARIABLE statement ................................................... 153

CREATE VIEW statement............................................................ 155

DEALLOCATE DESCRIPTOR statement [ESQL] ....................... 156

Declaration section [ESQL].......................................................... 157

DECLARE statement ................................................................... 158

DECLARE CURSOR statement [ESQL] [SP] .............................. 159

DECLARE CURSOR statement [T-SQL] ..................................... 166

DECLARE LOCAL TEMPORARY TABLE statement .................. 167

DELETE statement ...................................................................... 169

DELETE (positioned) statement [ESQL] [SP] .............................. 171

DESCRIBE statement [ESQL] ..................................................... 173

DISCONNECT statement [DBISQL] ............................................ 176

DROP statement.......................................................................... 177

DROP CONNECTION statement................................................. 180

DROP DATABASE statement...................................................... 181

DROP EXTERNLOGIN statement ............................................... 182

DROP LOGIN POLICY statement................................................ 183

DROP SERVER statement .......................................................... 183

DROP SERVICE statement ......................................................... 184

DROP STATEMENT statement [ESQL]....................................... 184

DROP USER statement ............................................................... 185

DROP VARIABLE statement ....................................................... 186

EXECUTE statement [ESQL]....................................................... 186

EXECUTE statement [T-SQL]...................................................... 188

EXECUTE IMMEDIATE statement [ESQL] [SP].......................... 190

EXIT statement [DBISQL] ............................................................ 192

Contents

Reference: Statements and Options v

FETCH statement [ESQL] [SP].................................................... 193

FOR statement............................................................................. 197

FORWARD TO statement............................................................ 199

FROM clause ............................................................................... 200

GET DESCRIPTOR statement [ESQL]........................................ 205

GOTO statement [T-SQL] ............................................................ 205

GRANT statement........................................................................ 206

IF statement ................................................................................. 212

IF statement [T-SQL].................................................................... 213

INCLUDE statement [ESQL] ........................................................ 215

INSERT statement ....................................................................... 216

INSTALL JAVA statement............................................................ 224

IQ UTILITIES statement............................................................... 227

LEAVE statement......................................................................... 229

LOAD TABLE statement .............................................................. 230

LOCK TABLE statement .............................................................. 252

LOOP statement .......................................................................... 255

MESSAGE statement................................................................... 257

OPEN statement [ESQL] [SP]...................................................... 260

OUTPUT statement [DBISQL] ..................................................... 263

PARAMETERS statement [DBISQL] ........................................... 267

PREPARE statement [ESQL]....................................................... 268

PRINT statement [T-SQL] ............................................................ 270

PUT statement [ESQL]................................................................. 272

RAISERROR statement [T-SQL] ................................................. 274

READ statement [DBISQL] .......................................................... 275

RELEASE SAVEPOINT statement .............................................. 276

REMOVE statement..................................................................... 277

RESIGNAL statement .................................................................. 278

RESTORE statement................................................................... 279

RESUME statement..................................................................... 284

RETURN statement ..................................................................... 286

REVOKE statement ..................................................................... 287

ROLLBACK statement ................................................................. 289

ROLLBACK TO SAVEPOINT statement...................................... 290

SAVEPOINT statement................................................................ 291

SELECT statement ...................................................................... 291

SET statement [ESQL]................................................................. 301

SET statement [T-SQL]................................................................ 303

SET CONNECTION statement [DBISQL] [ESQL] ....................... 306

SET DESCRIPTOR statement [ESQL] ........................................ 307

SET OPTION statement............................................................... 307

SET OPTION statement [DBISQL] .............................................. 310

SET SQLCA statement [ESQL].................................................... 311

剩余507页未读，继续阅读

评论收藏

内容反馈

davidie

2015-11-30

学习的好助手，参考手册比较全

啤酒大灰狼

粉丝: 0
资源: 32

Sybase IQ 15.1 引用手册（SQL和Option）

最新资源

Sybase IQ 15.1 引用手册（SQL和Option）

Sybase IQ 15.1引用手册（Bulding Blocks,Tables,and Procedures）

Sybase IQ 15.1性能调优手册

Sybase IQ 15.1 性能调优手册中文版

Sybase IQ 15.1 系统管理手册中文版（包含上下册）

Sybase IQ 15.1 系统管理手册（下）

SybaseIQ_15.1_中文安装配置指南

Sybase IQ 15.1实用程序指南

Sybase IQ 15.1系统管理手册（上）

Sybase Powerdesigner15.1简要使用手册中文

SybaseIQ_15.1_中文简介.pdf

SybaseIQ_15.1_中文快速入门.pdf

SybaseIQ_15.1Multiplex_中文指南.pdf

SybaseIQ_15.1_中文用户定义函数指南.pdf

sybase iq 15 64位 window 和linux 安装教程java 链接sybaseiq 分享

SybaseIQ_15.1_中文系统管理指南第二卷.pdf

SybaseIQ安装配置手册

SybaseIQ_15.1_中文大对象管理.pdf

Sybase IQ 15.4中文手册（系统介绍）

SQL SyBase IQ

Qt 5实现串口调试助手 （源工程文件、0积分下载）

【SystemVerilog】路科验证V2学习笔记（全600页）.pdf

AutoSAR标准协议4.2.2

光伏-储能并网系统仿真.rar

NPPJSONViewer.zip

GD32替换STM32注意事项.pdf

XCP协议的规范文档

VS2015安装证书，JavaScript_ProjectSystem.msi，JavaScript_LanguageService.msi

CANoe通过CAPL脚本实现自动测试

蓝牙BLE协议中文版.pdf

最新资源

Qt 5实现串口调试助手（源工程文件、0积分下载）