| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Reference Manual Volumes 1 - 4 (Online Only) |
![[-]](/dwicons/i_colpse.gif)
| Chapter 7 Commands |
Chapter 7
This volume describes commands, clauses, and other elements used to construct a Transact-SQL statement.
| Overview |
|
| alter database |
| Description |
| Syntax |
| Parameters |
| Examples |
![[+]](/dwicons/i_expand.gif)
| Usage |
| Standards |
| Permissions |
| See also |
|
| alter role |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| alter table |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| begin...end |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| begin transaction |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| break |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| case |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| checkpoint |
| Description |
| Syntax |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| close |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| coalesce |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| commit |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| compute clause |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| See also |
|
| connect to...disconnect |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| continue |
| Description |
| Syntax |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| create database |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| create default |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| create existing table |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| create function (SQLJ) |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| create index |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| create plan |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| create procedure |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| create procedure (SQLJ) |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| create proxy_table |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| create role |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| create rule |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| create schema |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| create table |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| create trigger |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| create view |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| dbcc |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| deallocate cursor |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| declare |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| declare cursor |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| delete |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| delete statistics |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| disk init |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| disk mirror |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| disk refit |
| Description |
| Syntax |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| disk reinit |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| disk remirror |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| disk unmirror |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| drop database |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| drop default |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| drop function (SQLJ) |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| drop index |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| drop procedure |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| drop role |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| drop rule |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| drop table |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| drop trigger |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| drop view |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| dump database |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| dump transaction |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| execute |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| fetch |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| goto label |
| Description |
| Syntax |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| grant |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| group by and having clauses |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| See also |
|
| if...else |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| insert |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| kill |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| load database |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| load transaction |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| lock table |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| nullif |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| online database |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| open |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| order by clause |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| See also |
|
| prepare transaction |
| Description |
| Syntax |
| Usage |
| Standards |
| See also |
|
|
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| quiesce database |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Permissions |
| See also |
|
| raiserror |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| readtext |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| reconfigure |
| Description |
| Syntax |
| Usage |
| Standards |
| Permissions |
| See also |
|
| remove java |
| Description |
| Syntax |
| Parameters |
|
| Usage |
| Permissions |
| See also |
|
| reorg |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| return |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| revoke |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| rollback |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| rollback trigger |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| save transaction |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| select |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| set |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| setuser |
| Description |
| Syntax |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| shutdown |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| truncate table |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| union operator |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| See also |
|
| update |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| update all statistics |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| update partition statistics |
| Description |
| Syntax |
| Parameters |
| Usage |
| Standards |
| Permissions |
| See also |
|
| update statistics |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| use |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| waitfor |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| where clause |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| See also |
|
| while |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| writetext |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
|