Transact-SQL 概述
Transact-SQL 语法规则
Transact-SQL 中的新特性和增强的功能
!> (不大于)
!< (不小于)
!=(不等于)
% (通配符 -- 需匹配的字符)
%(模)
&(按位 AND)
>(大于)
>=(大于或等于)
<>(不等于)
<(小于)
<=(小于或等于)
-(负)
-(减)
--(注释)
*(乘)
/(除)
/*...*/(注释)
@@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
[ ](通配符 -- 需匹配的字符)
[^](通配符字符 -- 无需匹配的字符)
^(按位互斥 OR)
_(通配符 -- 匹配一个字符)
|(按位 OR)
~(按位 NOT)
+(加)
+(正)
+(字符串串联)
=(等于)
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 DISTRIBUTED TRANSACTION
BEGIN TRANSACTION
BEGIN...END
BETWEEN
binary 和 varbinary
BINARY_CHECKSUM
bit
BREAK
BULK INSERT
CASE
CAST 和 CONVERT
CEILING
CHAR
char 和 varchar
CHARINDEX
CHECKPOINT
CHECKSUM
CHECKSUM_AGG
CLOSE
COALESCE
COL_LENGTH
COL_NAME
COLLATE
SQL 排序规则名称
Windows 排序规则名称
COLLATIONPROPERTY
COLUMNPROPERTY
COMMIT TRANSACTION
COMMIT WORK
COMPUTE 子句
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
DATABASEPROPERTY
DATABASEPROPERTYEX
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 DBREINDEX
DBCC DBREPAIR
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 SHOW_STATISTICS
DBCC SHOWCONTIG
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
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
FOR 子句
FORMATMESSAGE
FREETEXT
FREETEXTTABLE
FROM
FROM 子句
FULLTEXTCATALOGPROPERTY
FULLTEXTSERVICEPROPERTY
GETANSINULL
GETDATE
GETUTCDATE
GO
GOTO
GRANT
GROUP BY
GROUPING
HAS_DBACCESS
HAVING
HAVING 子句
HOST_ID
HOST_NAME
IDENT_CURRENT
IDENT_INCR
IDENT_SEED
IDENTITY(函数)
IDENTITY(属性)
IF...ELSE
image
IN
INDEX_COL
INDEXKEY_PROPERTY
INDEXPROPERTY
INSERT
int、bigint、smallint 和 tinyint
IS [NOT] NULL
IS_MEMBER
IS_SRVROLEMEMBER
ISDATE
ISNULL
ISNUMERIC
KILL
LEFT
LEN
LIKE
LOAD
LOG
LOG10
LOWER
LTRIM
MAX
MIN
money 和 smallmoney
MONTH
NCHAR
nchar 和 nvarchar
NEWID
Northwind 示例数据库
Categories
CustomerCustomerDemo
CustomerDemographics
Customers
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
OPTION 子句
OR
ORDER BY
ORDER BY 子句
PARSENAME
PATINDEX
PERMISSIONS
PI
POWER
Predicate
PRINT
pubs 示例数据库
authors
discounts
employee
jobs
pub_info
publishers
roysched
sales
stores
titleauthor
titles
QUOTENAME
RADIANS
RAISERROR
RAND
READTEXT
real
RECONFIGURE
REPLACE
REPLICATE
RESTORE
RESTORE FILELISTONLY
RESTORE HEADERONLY
RESTORE LABELONLY
RESTORE VERIFYONLY
RETURN
REVERSE
REVOKE
RIGHT
ROLLBACK TRANSACTION
ROLLBACK WORK
ROUND
ROWCOUNT_BIG
RTRIM
SAVE TRANSACTION
SCOPE_IDENTITY
SELECT
SELECT 示例
SELECT @local_variable
SELECT 子句
SERVERPROPERTY
SESSION_USER
SESSIONPROPERTY
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
SET @local_variable
SETUSER
SHUTDOWN
SIGN
SIN
smalldatetime
smallint
smallmoney
SOME | ANY
SOUNDEX
SPACE
sql_variant
SQL_VARIANT_PROPERTY
SQRT
SQUARE
STATS_DATE
STDEV
STDEVP
STR
STUFF
SUBSTRING
SUM
SUSER_ID
SUSER_NAME
SUSER_SID
SUSER_SNAME
SYSTEM_USER
table
TAN
text
TEXTPTR
TEXTVALID
timestamp
tinyint
TRIGGER_NESTLEVEL
TRUNCATE TABLE
TYPEPROPERTY
UNICODE
UNION
UNION 运算符
uniqueidentifier
UPDATE
UPDATE STATISTICS
UPDATETEXT
UPPER
USE
USER
USER_ID
USER_NAME
VAR
varbinary
varchar
VARP
WAITFOR
WHERE
WHERE 子句
WHILE
WRITETEXT
YEAR
保留关键字
表达式
常量
跟踪标记
函数
安全函数
聚合函数
配置函数
日期和时间函数
数学函数
文本和图像函数
系统函数
系统统计函数
行集函数
游标函数
元数据函数
字符串函数
控制流语言
事务
数据类型
精度、小数位数和长度
排序规则的优先顺序
数据类型的优先顺序
数据类型同义词
搜索条件
系统表
backupfile
backupmediafamily
backupmediaset
backupset
log_shipping_databases
log_shipping_monitor
log_shipping_plan_databases
log_shipping_plan_history
log_shipping_plans
log_shipping_primaries
log_shipping_secondaries
logmarkhistory
MSagent_parameters
MSagent_profiles
MSarticles
MSdistpublishers
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
MSsnapshot_agents
MSsnapshot_history
MSsub_identity_range
MSsubscriber_info
MSsubscriber_schedule
MSsubscription_agents
MSsubscription_articles
MSsubscription_properties
MSsubscriptions
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
sysdepends
sysdevices
sysdownloadlist
sysfilegroups
sysfiles
sysforeignkeys
sysfulltextcatalogs
sysindexes
sysindexkeys
sysjobhistory
sysjobs
sysjobschedules
sysjobservers
sysjobsteps
syslanguages
syslockinfo
syslogins
sysmembers
sysmergearticles
sysmergepublications
sysmergeschemaarticles
sysmergeschemachange
sysmergesubscriptions
sysmergesubsetfilters
sysmessages
sysnotifications
sysobjects
sysoledbusers
sysopentapes
sysoperators
sysperfinfo
syspermissions
sysprocesses
sysprotects
syspublications
sysreferences
sysremotelogins
sysreplicationalerts
sysschemaarticles
syssubscriptions
systargetservergroupmembers
systargetservergroups
systargetservers
systaskids
systypes
sysusers
系统存储过程
sp_ActiveDirectory_Obj
sp_ActiveDirectory_SCP
sp_add_alert
sp_add_category
sp_add_data_file_recover_suspect_db
sp_add_job
sp_add_jobschedule
sp_add_jobserver
sp_add_jobstep
sp_add_log_file_recover_suspect_db
sp_add_log_shipping_database
sp_add_log_shipping_plan
sp_add_log_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