Sybase
®
Adaptive Server
™
Enterprise
Adaptive Server Enterprise
12
ID
37418-01-1200-01
1999
10
Enterprise Data Studios Publications
Anneli Meyer
Evelyn Wheeler
ID
37418-01-1200-01
Sybase
Adaptive Server Enterprise
12
!"#$%&'()*+,-
!./0$ 123456789:;<2=56>?@A
BCD$
EFGHI%&JKLIMNOP4QROPSTUVWX
(800) 685-8225
YZ[\
(617) 229-9845
$
]^K_OP`aJK3456b4/cd1Z[efOPSTUVgh$
]iKjOPkf
Sybase
lmnopqrsgh$
tuvwx#yYz{78$
Copyright © 1989-2001 by Sybase, Inc.
|}~$
Sybase, Inc.
~Uq-
Wl]^BCZ$
Sybase
Sybase
SYBASE
Adaptive Server
APT-FORMS
Certified SYBASE
Professional
Certified SYBASE Professional
Column Design
ComponentPack
Data Workbench
First Impression
InfoMaker
ObjectCycle
PowerBuilder
PowerDesigner
Powersoft
Replication Server
S-Designor
SQL Advantage
SQL Debug
SQL SMART
Transac t-SQL
Visual Components
VisualWriter
L
VQL
Sybase, Inc.
s$
Adaptable Windowing Environment
Adaptive Component Architecture
Adaptive Server Enterprise Monitor
Adaptive Warehouse
ADA Workbench
AnswerBase
Application Manager
AppModeler
APT-Build
APT-Edit
APT-Execute
APT-Library
APT-Translator
APT Workbench
Backup
Server
BayCam
Bit-Wise
ClearConnect
Client-Library
Client Services
CodeBank
Connection Manager
DataArchitect
Database Analyzer
DataExpress
Data Pipeline
DataServer
DataWindow
DB-Library
dbQueue
Developers Workbench
DirectConnect
Distribution Agent
Distribution Director
Embedded SQL
EMS
Enterprise Application Server
Enterprise Application Studio
Enterprise Client/Server
EnterpriseConnect
Enterprise Data Studio
Enterprise Manager
Enterprise SQL Server Manager
Enterprise Work Architecture
Enterprise Work Designer
Enterprise Work
Modeler
EWA
Formula One
Gateway Manager
GeoPoint
ImpactNow
InformationConnect
InstaHelp
InternetBuilder
iScript
Jaguar CTS
jConnect for JDBC
KnowledgeBase
Logical Memory Manager
MainframeConnect
Maintenance Express
MAP
MDI Access Server
MDI
Database Gateway
media.splash
MetaBridge
MetaWorks
MethodSet
MySupport
Net-Gateway
NetImpact
Net-Library
Next Generation
Learning
ObjectConnect
OmniConnect
OmniSQL Access Module
OmniSQL Toolkit
Open Client
Open ClientConnect
Open Client/Server
Open Client/Server Interfaces
Open Gateway
Open Server
Open
ServerConnect
Open Solutions
Optima++
PB-Gen
PC APT-Execute
PC
DB-Net
PC Net Library
Power++
Power AMC
PowerBuilt
PowerBuilt
with PowerBuilder
PowerDynamo
PowerJ
PowerScript
PowerSite
PowerSocket
Powersoft Portfolio
PowerStudio
Power Through Knowledge
PowerWare Desktop
PowerWare Enterprise
ProcessAnalyst
Replication
Agent
Replication Driver
Replication Server Manager
Report-Execute
Report Workbench
Resource Manager
RW-DisplayLib
RW-Library
SAFE
SDF
Secure SQL Server
Secure SQL Toolset
Security Guardian
SKILS
smart.partners
smart.parts
smart.script
SQL Code Checker
SQL Edit
SQL
Edit/TPU
SQL Modeler
SQL Remote
SQL Server
SQL Server/CFT
SQL
Server/DBM
SQL Server Manager
SQL Server SNMP SubAgent
SQL
Station
SQL Toolset
Sybase Central
Sybase Client/Server Interfaces
Sybase
Development Framework
Sybase Financial Server
Sybase Gateways
Sybase
Learning Connection
Sybase MPP
Sybase SQL Desktop
Sybase SQL
Lifecycle
Sybase SQL Workgroup
Sybase Synergy Program
Sybase Virtual
Server Architecture
Sybase User Workbench
SybaseWare
SyberAssist
SyBooks
System 10
System 11
System XI
SystemTools
Tabular Data
Stream
The Enterprise Client/Server Company
The Extensible Software
Platform
The Future Is Wide Open
The Learning Connection
The Model for
Client/Server Solutions
The Online Information Center
Translation Toolkit
Turning Imagination Into Reality
UltraLite
UNIBOM
Unilib
Uninull
Unisep
Unistring
URK Runtime Kit for UniCode
Viewer
VisualSpeller
VisualWriter
WarehouseArchitect
Warehouse Studio
Warehouse WORKS
Wa tc om
Watcom SQL
Watcom SQL Server
We b. PB
We b. SQL
WebSights
We bVi e we r
WorkGroup SQL Server
XA-Library
XA-Server
L
XP Server
Sybase, Inc.
s$
%& A]^mnLvw4kmnss$
¡ABCm¢£
DFARS 52.227-7013
H¤
(c)(1)(ii)
>? ¥¦
DOD
L
FAR 52.227-19(a)-(d)
k>? ¥¦§¨©ª«C$
Sybase, Inc., 6475 Christie Avenue, Emeryville, CA 94608.
Adaptive Server Enterprise v
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
6. Transact-SQL
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-1
alter database
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-6
alter role
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-10
alter table
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-14
begin...end
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-33
begin transaction
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-35
break
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-36
case
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-38
checkpoint
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-42
close
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-44
coalesce
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-45
commit
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-47
compute Clause
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-49
connect to...disconnect
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-58
continue
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-60
create database
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-62
create default
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-68
create existing table
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-71
create index
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-76
create plan
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-88
create procedure
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-90
create proxy_table
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-101
create role
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-103
create rule
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-106
create schema
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-110
create table
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-112
create trigger
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-136
create view
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-146
dbcc
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-153
deallocate cursor
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-161
declare
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-162
