Microsoft SQL Server 2000 Transact-SQL和技術(shù)參考手冊

第1章 Transact-SQL概述
第2章 Transact-SQL語法規(guī)則
第3章 Transact-SQL中的新特性和增強(qiáng)的功能
第4章 Transact-SQL詳解
+（加）
+（正）
+（字符串串聯(lián)）
-（負(fù)）
-（減）
*（乘）
/（除）
%（模）
%（通配符——需匹配的字符）
&（按位AND）
|（按位OR）
^（按位互斥OR）
~（按位NOT）
=（等于）
>（大于）
<（小于）
>=（大于或等于）
<=（小于或等于）
<>（不等于）
！<（不小于）
！=（不等于）
！>（不大于）
--（注釋）
/*...*/（注釋）
[]（通配符-需匹配的字符）
[^]（通配符字符-無需匹配的字符）
-（通配符-匹配一個字符）
@@CONNECTIONS
@@CPU_BUSY
@@CURSOR_ROWS
@@DATEFIRST
@@DBTS
@@ERROR
@@FETCH_STATUS
@@IDENTITY
@@IDLE
@@IO_BUSY
@@LANGID
@@LANGUAGE
@@LOCK_TIMEOUT
@@MAX_CONNECTIONS
@@MAX_PRECISION
@@NESTLEVEL
@@OPTIONS
@@PACK_RECEIVED
@@PACK_SENT
@@PACKET_ERRORS
@@PROCID
@@REMSERVER
@@ROWCOUNT
@@SERVERNAME
@@SERVICENAME
@@SPID
@@TEXTSIZE
@@TIMETICKS
@@TOTAL_ERRORS
@@TOTAL_READ
@@TOTAL_WRITE
@@TRANCOUNT
@@VERSION
ABS
ACOS
ALL
ALTER DATABASE
ALTER FUNCTION
ALTER PROCEDURE
ALTER TABLE
ALTER TRIGGER
ALTER VIEW
AND
ANY
APP_NAME
ASCII
ASIN
ATAN
ATN2
AVG
BACKUP
BEGIN...END
BEGIN DISTRIBUTED TRANSACTION
BEGIN TRANSACTION
BETWEEN
binary和varbinary
BINARY_CHECKSUM
bit
BREAK
BULKINSERT
CASE
CAST和CONVERT
CEILING
char和varchar
CHAR
CHARINDEX
CHECKPOINT
CHECKSUM
CHECKSUM_AGG
CLOSE
COALESCE
COLLATE
Windows排序規(guī)則名稱
SQL排序規(guī)則名稱
COLLATIONPROPERTY
COL_LENGTH
COL_NAME
COLUMNPROPERTY
COMMIT TRANSACTION
COMMIT WORK
常量
CONTAINS
CONTAINSTABLE
CONTINUE
控制流語言
COS
COT
COUNT
COUNT_BIG
CREATE DATABASE
CREATE DEFAULT
CREATE FUNCTION
CREATE INDEX
CREATE PROCEDURE
CREATE RULE
CREATE SCHEMA
CREATE STATISTICS
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
CURRENT_TIMESTAMP
CURRENT_USER
cursor
CURSOR_STATUS
游標(biāo)
DATABASEPROPERTY
DATABASEPROPERTYEX
數(shù)據(jù)類型
數(shù)據(jù)類型的優(yōu)先順序
排序規(guī)則的優(yōu)先順序
精度、小數(shù)位數(shù)和長度
數(shù)據(jù)類型同義詞
DATALENGTH
DATEADD
DATEDIFF
DATENAME
DATEPART
datetime和smalldatetime
DAY
DB_ID
DB_NAME
DBCC
DBCC CHECKALLOC
DBCC CHECKCATALOG
DBCC CHECKCONSTRAINTS
DBCC CHECKDB
DBCC CHECKFILEGROUP
DBCC CHECKIDENT
DBCC CHECKTABLE
DBCC CLEANTABLE
DBCC CONCURRENCYVIOLATION
DBCC DBREPAIR
DBCC DBREINDEX
DBCC dllname（FREE）
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE
DBCC HELP
DBCC INDEXDEFRAG
DBCC INPUTBUFFER
DBCC NEWALLOC
DBCC OPENTRAN
DBCC OUTPUTBUFFER
DBCC PINTABLE
DBCC PROCCACHE
DBCC ROWLOCK
DBCC SHOWCONTIG
DBCC SHOW_STATISTICS
DBCC SHRINKDATABASE
DBCC SHRINKFILE
DBCC SQLPERF
DBCC TRACEOFF
DBCC TRACEON
DBCC TRACESTATUS
DBCC UNPINTABLE
DBCC UPDATEUSAGE
DBCC USEROPTIONS
DEALLOCATE
decimal和numeric
DECLARE@local_variable
DECLARE CURSOR
DEGREES
DELETE
DENY
DIFFERENCE
DROP DATABASE
DROP DEFAULT
DROP FUNCTION
DROP INDEX
DROP PROCEDURE
DROP RULE
DROP STATISTICS
DROP TABLE
DROP TRIGGER
DROP VIEW
DUMP
ELSE（IF...ELSE）
END（BEGIN...END）
EXECUTE
EXISTS
EXP
表達(dá)式
FETCH
FILE_ID
FILE_NAME
FILEGROUP_ID
FILEGROUP_NAME
FILEGROUPPROPERTY
FILEPROPERTY
float和real
FLOOR
fn_helpcollations
fn_listextendedproperty
fn_servershareddrives
fn_trace_geteventinfo
fn_trace_getfilterinfo
fn_trace_getinfo
fn_trace_gettable
fn_virtualfilestats
fn_virtualservernodes
FORMATMESSAGE
FREETEXTTABLE
FROM
FULLTEXTCATALOGPROPERTY
FULLTEXTSERVICEPROPERTY
函數(shù)
聚合函數(shù)
配置函數(shù)
游標(biāo)函數(shù)
日期和時間函數(shù)
數(shù)學(xué)函數(shù)
元數(shù)據(jù)函數(shù)
行集函數(shù)
安全函數(shù)
字符串函數(shù)
系統(tǒng)函數(shù)
系統(tǒng)統(tǒng)計函數(shù)
文本和圖像函數(shù)
GETANSINULL
GETDATE
GETUTCDATE
GO
GOTO
GRANT
GROUP BY
GROUPING
HAS_DBACCESS
HAVING
HOST_ID
HOST_NAME
IDENT_CURRENT
IDENT_INCR
IDENT_SEED
IDENTITY（屬性）
IDENTITY（函數(shù)）
IF...ELSE
image
IN
INDEXKEY_PROPERTY
INDEXPROPERTY
INDEX_COL
信息架構(gòu)視圖
CHECK_CONSTRAINTS
COLUMN_DOMAIN_USAGE
COLUMN_PRIVILEGES
COLUMNS
CONSTRAINT_COLUMN_USAGE
CONSTRAINT_TABLE_USAGE
DOMAIN_CONSTRAINTS
DOMAINS
KEY_COLUMN_USAGE
PARAMETERS
REFERENTIAL_CONSTRAINTS
ROUTINES
ROUTINE_COLUMNS
SCHEMATA
TABLE_CONSTRAINTS
TABLE_PRIVILEGES
TABLES
VIEW_COLUMN_USAGE
VIEW_TABLE_USAGE
VIEWS
INSERT
int、bigint、smallint和tinyint
IS_MEMBER
IS_SRVROLEMEMBER
ISDATE
IS[NOT]NULL
ISNULL
ISNUMERIC
KILL
LEFT
LEN
LIKE
LOAD
LOG
LOG10
LOWER
LTRIM
MAX
MIN
money和smallmoney
MONTH
NCHAR
nchar和nvarchar
NEWID
Northwind示例數(shù)據(jù)庫
Categories
Customers
CustomerCustomerDemo
CustomerDemographics
Employees
EmployeeTerritories
Order Details
Orders
Products
Region
Shippers
Suppliers
Territories
NOT
ntext、text和image
NULLIF
numeric
OBJECT_ID
OBJECT_NAME
OBJECTPROPERTY
OPEN
OPENDATASOURCE
OPENQUERY
OPENROWSET
OPENXML
運算符
OR
ORDER BY
PARSENAME
PATINDEX
PERMISSIONS
PI
POWER
Predicate
PRINT
pubs示例數(shù)據(jù)庫
authors
discounts
employee
jobs
pub_info
publishers
roysched
sales
stores
titleauthor
titles
QUOTENAME
RADIANS
RAISERROR
RAND
READTEXT
real
RECONFIGURE
REPLACE
REPLICATE
保留關(guān)鍵字
RESTORE
RESTORE FILELISTONLY
RESTORE HEADERONLY
RESTORE LABELONLY
RESTORE VERIFYONLY
RETURN
REVERSE
REVOK
RIGHT
ROLLBACK TRANSACTION
ROLLBACK WORK
ROUND
ROWCOUNT_BIG
RTRIM
SAVE TRANSACTION
SCOPE_IDENTITY
搜索條件
SELECT@local_variable
SELECT
SELECT示例
SERVERPRO PERTY
SESSION_USER
SESSIONPROPERTY
SET@local_variable
SET
SET ANSI_DEFAULTS
SET ANSI_NULL_DFLT_OFF
SET ANSI_NULL_DFLT_ON
SET ANSI_NULLS
SET ANSI_PADDING
SET ANSI_WARNINGS
SET ARITHABORT
SET ARITHIGNORE
SET CONCAT_NULL_YIELDS_NULL
SET CONTEXT_INFO
SET CURSOR_CLOSE_ON_COMMIT
SET DATEFIRST
SET DATEFORMAT
SET DEADLOCK_PRIORITY
SET DISABLE_DEF_CNST_CHK
SET FIPS_FLAGGER
SET FMTONLY
SET FORCEPLAN
SET IDENTITY_INSERT
SET IMPLICIT_TRANSACTIONS
SET LANGUAGE
SET LOCK_TIMEOUT
SET NOCOUNT
SET NOEXEC
SET NUMERIC_ROUNDABORT
SET OFFSETS
SET PARSEONLY
SET QUERY_GOVERNOR_COST_LIMIT
SET QUOTED_IDENTIFIER
SET REMOTE_PROC_TRANSACTIONS
SET ROWCOUNT
SET SHOWPLAN_ALL
SET SHOWPLAN_TEXT
SET STATISTICS IO
SET STATISTICS PROFILE
SET STATISTICS TIME
SET TEXTSIZE
SET TRANSACTION ISOLATION LEVEL
SET XACT_ABORT
SETUSER
SHUTDOWN
SIGN
SIN
smalldatetime
smallint
smallmoney
SOME|ANY
SOUNDEX
SPACE
sql_variant
SQL_VARIANT_PROPERTY
SQUARE
SQRT
STATS_DATE
STDEV
STDEVP
STR
STUFF
SUBSTRING
SUM
SUSER_ID
SUSER_NAME
SUSER_SID
SUSER_SNAME
系統(tǒng)存儲過程
對象層次結(jié)構(gòu)語法
sp_ActiveDirectory_Obj
sp_ActiveDirectory_SCP
sp_add_alert
sp_addalias
sp_addapprole
sp_add_data_file_recover_suspect_db
sp_addextendedproc
sp_addextendedproperty
sp_addgroup
sp_add_category
sp_add_job
sp_add_jobschedule
sp_add_jobserver
sp_add_jobstep
sp_addlinkedserver
sp_addlinkedsrvlogin
sp_add_log_file_recover_suspect_db
sp_addlogin
sp_add_log_shipping_database
sp_add_log_shipping_plan
sp_add_shipping_plan_database
sp_add_log_shipping_primary
sp_add_log_shipping_secondary
sp_add_maintenance_plan
sp_add_maintenance_plan_db
sp_add_maintenance_plan_job
sp_addmessage
sp_add_notification
sp_add_operator
sp_addremotelogin
sp_addrole
sp_addrolemember
sp_addserver
sp_addsrvrolemember
sp_addtask
sp_addtype
sp_add_targetservergroup
sp_addumpdevice
sp_add_targetsvrgrp_member
sp_adduser
sp_altermessage
sp_apply_job_to_targets
sp_approlepassword
sp_attach_db
sp_attach_single_file_db
sp_autostats
sp_bundefault
sp_bindrule
sp_bundsession
sp_can_tlog_be_applied
sp_catalogs
sp_certify_removable
sp_change_monitor_role
sp_change_primary_role
sp_change_secondary_role
sp_changeS_users_login
sp_changedbowner
sp_changegroup
sp_changeobjectowner
sp_column_privileges
sp_column_privileges_ex
sp_columns
sp_columns_ex
sp_configure
sp_create_log_shipping_monitor_account
sp_create_removable
sp_createstats
sp_cursor_list
sp_cycle_errorlog
sp_databases
sp_datatype_info
sp_dbcmptlevel
sp_dbfixedrolepermission
sp_dboption
sp_dbremove
sp_defaultdb
sp_defaultlanguage
sp_define_log_shipping_monitor
sp_delete_alert
sp_delete_backuphistory
sp_delete_category
sp_delete_database_backuphisory
sp_delete_job
sp_delete_jobschedule
sp_delete_jobserver
sp_delete_jobstep
sp_delete_log_shipping_database
sp_delete_log_shipping_monitor_info
sp_delete_log_shipping_plan
sp_delete_log_shipping_plan_database
sp_delete_log_shipping_primary
sp_delete_log_shipping_secondary
sp_delete_maintenance_plan
sp_delete_maintenance_plan_db
sp_delete_maintenance_plan_job
sp_delete_notification
sp_delete_operator
sp_delete_targetserver
sp_delete_targetservergroup
sp_delete_targetsvrgrp_member
sp_denylogin
sp_depends
sp_describe_cursor
sp_describe_cursor_columns
sp_describe_cursor_tables
sp_detach_db
sp_dropalias
sp_dropapprole
sp_dropdevice
sp_dropextendedproc
sp_dropextendedproperty
sp_dropgroup
sp_droplinkedsrvlogin
sp_droplogin
sp_dropmessage
sp_dropremotelogin
sp_droprole
sp_droprolemember
sp_droptask
sp_droptype
sp_dropuser
sp_dropwebtask
sp_enumcodepages
sp_executesql
sp_fkeys
sp_foreignkeys
sp_fulltext_catalog
sp_fulltext_column
sp_fulltext_database
sp_fulltext_service
sp_fulltext_table
sp_getapplock
sp_getbindtoken
sp_get_log_shipping_monitor_info
sp_grantdbaccess
sp_grantlogin
sp_help
sp_help_alert
sp_help_category
sp_helpconstraint
sp_helpdb
sp_helpdbfixedrole
sp_helpdevice
sp_help_downloadlist
sp_helpextendedproc
sp_helpfile
sp_helpfilegroup
sp_help_fulltext_catalogs
sp_help_fulltext_catalogs_cursor
sp_helpfulltext_columns
sp_help_fulltext_columns_cursor
sp_help_fulltext_tables
sp_help_fulltext_tables_cursor
sp_helpgroup
sp_helphistory
sp_help_job
sp_help_jobhistory
sp_help_jobschedule
sp_help_jobserver
sp_help_jobstep
sp_helpindex
sp_helpanguage
sp_helplinkedsrvlogin
sp_helplogins
sp_help_maintenance_plan
sp_help_notification
sp_helpntgroup
sp_help_operator
sp_helpremotelogin
sp_helprole
sp_helprolemember
sp_helprotect
sp_helpserver
sp_helpsort
sp_helpsrvrole
sp_helpsrvrolemember
sp_helpstats
sp_help_targetserver
sp_help_targetservergroup
sp_helptask
sp_helptext
sp_helptrigger
sp_helpuser
sp_indexes
sp_indexoption
sp_invalidate_textptr
sp_linkedservers
sp_lock
sp_makewebtask
sp_manage_jobs_by_login
sp_monitor
sp_MShasdbaccess
sp_msx_defect
sp_msx_enlist
sp_OACreate
sp_OADestroy
sp_OAGetErrorInfo
sp_OAGetProperty
sp_OAMethod
sp_OASetProperty
sp_OAStop
sp_password
sp_pkeys
sp_primarykeys
sp_post_msx_operation
sp_processmail
sp_procoption
sp_purgehistory
sp_purge_jobhistory
sp_reassigntask
sp_recompile
sp_refreshview
sp_releaseapplock
sp_remoteoption
sp_remove_job_from_targets
sp_remove_log_shipping_monitor
sp_rename
sp_renamedb
sp_resetstatus
sp_resolve_logins
sp_resync_targetserver
sp_revokedbaccess
sp_revokelogin
sp_runwebtask
sp_server_info
sp_serveroption
sp_setapprole
sp_setnetname
sp_settriggerorder
sp_scriptsubconflicttable
sp_spaceused
sp_special_columns
sp_sproc_columns
sp_srvrolepermission
sp_start_job
sp_statistics
sp_stop_job
sp_stored_procedures
sp_tableoption
sp_table_privileges
sp_table_privileges_ex
sp_tables
sp_tables_ex
sp_trace_create
sp_trace_generateevent
sp_trace_setevent
sp_trace_setfilter
sp_trace_setstatus
sp_unbindefault
sp_unbindrule
sp_update_alert
sp_update_category
sp_updateexxtendedproperty
sp_update_job
sp_update_jobschedule
sp_update_jobstep
sp_update_log_shipping_monitor_info
sp_update_log_shipping_plan
sp_update_log_shipping_plan_database
sp_update_notification
sp_update_operator
sp_updatestats
sp_update_targetservergroup
sp_updatetask
sp_validname
sp_validatelogins
sp_who
sp_xml_preparedocument
sp_xml_removedocument
復(fù)制存儲過程
xp_cmdshell
xp_deletemail
xp_enumgroups
xp_findnextmsg
xp_grantlogin
xp_logevent
xp_loginconfig
xp_logininfo
xp_msver
xp_readmail
xp_revokelogin
xp_sendmail
xp_sprintf
xp_sqlagent_proxy_account
xp_sqlmaint
xp_sscanf
xp_startmail
xp_stopmail
系統(tǒng)表
backupfile
backupmediafamily
backupmediaset
backupset
logmarkhistory
log_shipping_databases
log_shipping_monitor
log_shipping_plan_databases
log_shipping_plan_history
log_shipping_plans
log_shipping_primaries
log_shipping_secondaries
MSagent_parameters
MSagent_profiles
MSarticles
MSdistribution_agents
MSdistribution_history
MSdistributiondbs
MSdistributor
MSdynamicsnapshotjobs
MSdynamicsnapshotviews
MSlogreader_agents
MSlogreader_history
MSmerge_agents
MSmerge_altsyncpartners
MSmerge_contents
MSmerge_delete_conflicts
MSmerge_errorlineage
MSmerge_genhistory
MSmerge_history
MSmerge_replinfo
MSmerge_subscriptions
MSmerge_tombstone
MSpub_identity_range
MSpublication_access
MSpublications
MSpublisher_databases
MSqreader_agents
MSqreader_history
MSrepl_backup_lsns
MSrepl_commands
MSrepl_errors
MSrepl_identity_range
MSrepl_originators
MSrepl_transactions
MSrepl_version
MSreplication_objects
MSreplication_options
MSreplication_queue
MSreplication_subscriptions
MSsnamshot_agents
MSsnapshot_history
MSsubscriber_info
MSsubscriber_schedule
MSsubscription_agents
MSsubscription_articles
MSsubscription_properties
MSsubscriptions
MSsub_identity_range
MSsync_states
restorefile
restorefilegroup
restorehistory
sysalerts
sysaltfiles
sysarticles
sysarticleupdates
syscacheobjects
syscategories
syscharsets
syscolumns
syscomments
sysconfigures
sysconstraints
syscurconfigs
sysdatabases
sysdbmaintplan_databases
sysdbmaintplan_history
sysdbmaintplan_jobs
sysdbmaintplans
sysedpends
sysedvices
sysdownloadlist
sysfiles
sysfilegroups
sysforeignkeys
sysfulltextcatalogs
sysindexes
sysindexkeys
sysjobhistory
sysjobschedules
sysjobs
sysjobservers
sysjobs
sysjobservers
sysjobsteps
syslanguages
syslockinfo
syslogins
sysmembers
sysmergepublications
sysmergeschemaarticles
sysmergeschemachange
sysmergesubscriptions
sysmergesubsetfilters
sysmessages
sysnotifications
sysobjects
sysoledbusers
sysopentapes
sysoperators
sysperfinfo
syspermissions
sysprocesses
sysprotects
syspublications
sysreferences
sysremotelogins
sysreplicationalerts
sysschemaarticls
sysservers
syssubscriptions
systargetservergroupmembers
systaOrgetservergroups
systargetservers
systaskids
systypes
sysusers
SYSTEM_USER
table
TAN
text
TEXTPTR
TEXTVALID
timestamp
tinyint
跟蹤標(biāo)記
事務(wù)
TRIGGER_NESTLEVEL
TRUNCATE TABLE
TYPEPROPERTY
UNICODE
UNION
uniqueidentifier
UPDATE
UPDATE STATISTICS
UPDATETEXT
UPPER
USE
USER
USER_ID
USER_NAME
VAR
varbinary
varchar
VARP
WAITFOR
WHERE
WHILE
WRITETEXT
YEAR