Microsoft SQL Server 2000 Transact-SQL和技术参考手册PDF电子书下载

第1章 Transact-SQL概述 1

第2章 Transact-SQL语法规则 2

第3章 Transact-SQL中的新特性和增强的功能 7

第4章 Transact-SQL详解 12

+(加) 12

+(正) 13

+(字符串串联) 14

－(负) 17

－(减) 18

*(乘) 19

/(除) 20

%(模) 21

%(通配符——需匹配的字符) 22

(按位AND) 22

|(按位OR) 24

^(按位互斥OR) 26

~(按位NOT) 28

=(等于) 30

>(大于) 30

<(小于) 31

>=(大于或等于) 31

<=(小于或等于) 32

<>(不等于) 32

!<(不小于) 33

!=(不等于) 33

!>(不大于) 34

--(注释) 34

/*...*/(注释) 35

[^](通配符字符-无需匹配的字符) 37

[](通配符-需匹配的字符) 37

_(通配符-匹配一个字符) 38

@@CONNECTIONS 38

@@CPU_BUSY 38

@@CURSOR_ROWS 39

@@DATEFIRST 41

@@DBTS 41

@@ERROR 42

@@FETCH_STATUS 47

@@IDENTITY 48

@@IDLE 49

@@IO_BUSY 49

@@LANGID 50

@@LANGUAGE 50

@@LOCK_TIMEOUT 51

@@MAX_CONNECTIONS 52

@@MAX_PRECISION 52

@@NESTLEVEL 53

@@OPTIONS 54

@@PACK_RECEIVED 54

@@PACK_SENT 55

@@PACKET_ERRORS 55

@@PROCID 56

@@REMSERVER 56

@@ROWCOUNT 57

@@SERVERNAME 57

@@SERVICENAME 58

@@TEXTSIZE 59

@@SPID 59

@@TIMETICKS 60

@@TOTAL_ERRORS 60

@@TOTAL_READ 61

@@TOTAL_WRITE 62

@@TRANCOUNT 62

@@VERSION 63

ABS 63

ACOS 64

ALL 65

ALTER DATABASE 66

ALTER FUNCTION 78

ALTER PROCEDURE 82

ALTER TABLE 86

ALTER TRIGGER 103

ALTER VIEW 108

AND 112

ANY 112

APP_NAME 113

ASCII 113

ASIN 115

ATAN 117

ATN2 118

AVG 119

BACKUP 122

BEGIN...END 137

BEGIN DISTRIBUTED TRANSACTION 138

BEGIN TRANSACTION 140

BETWEEN 143

binary和varbinary 146

BINARY_CHECKSUM 147

bit 149

BREAK 150

BULK INSERT 150

CASE 155

CAST和CONVERT 163

CEILING 174

char和varchar 174

CHAR 175

CHARINDEX 178

CHECKPOINT 180

CHECKSUM 181

CHECKSUM_AGG 183

CLOSE 185

COALESCE 186

COLLATE 188

Windows排序规则名称 191

SQL排序规则名称 195

COLLATIONPROPERTY 200

COL_LENGTH 201

COL_NAME 202

COLUMNPROPERTY 202

COMMIT TRANSACTION 205

COMMIT WORK 207

常量 208

CONTAINS 211

CONTAINSTABLE 218

CONTINUE 222

控制流语言 222

COS 223

COT 223

COUNT 224

COUNT_BIG 226

CREATE DATABASE 227

CREATE DEFAULT 240

CREATE FUNCTION 242

CURRENT_USER 244

cursor 245

CURSOR_STATUS 246

游标 249

CREATE INDEX 252

CREATE PROCEDURE 270

CREATE RULE 287

CREATE SCHEMA 290

CREATE STATISTICS 291

CREATE TABLE 293

CREATE TRIGGER 314

CRETAE VIEW 329

CURRENT_TIMESTAMP 342

DATABASEPROPERTY 350

DATABASEPROPERTYEX 353

数据类型 358

数据类型的优先顺序 361

排序规则的优先顺序 362

精度、小数位数和长度 368

数据类型同义词 369

DATALENGTH 370

DATEADD 371

DATEDIFF 373

DATENAME 375

DATEPART 376

datetime和smalldatetime 379

DAY 380

DB_ID 381

DB_NAME 382

DBCC 383

DBCC CHECKALLOC 385

DBCC CHECKCATALOG 390

DBCC CHECKCONSTRAINTS 391

DBCC CHECKDB 394

DBCC CHECKFILEGROUP 398

DBCC CHECKIDENT 403

DBCC CHECKTABLE 406

DBCC CLEANTABLE 410

DBCC CONCURRENCYVIOLATION 411

DBCC DBREPAIR 414

DBCC DBREINDEX 414

DBCC dllname(FREE) 416

DBCC DROPCLEANBUFFERS 416

DBCC FREEPROCCACHE 417

DBCC HELP 417

DBCC INDEXDEFRAG 418

DBCC INPUTBUFFER 420

DBCC OPENTRAN 421

DBCC NEWALLOC 421

DBCC OUTPUTBUFFER 423

DBCC PINTABLE 424

DBCC PROCCACHE 425

DBCC ROWLOCK 426

DBCC SHOWCONTIG 426

DBCC SHOW_STATISTICS 435

DBCC SHRINKDATABASE 438

DBCC SHRINKFILE 441

DBCC SQLPERF 444

DBCC TRACEOFF 445

DBCC TRACEON 446

DBCC TRACESTATUS 446

DBCC UNPINTABLE 447

DBCC UPDATEUSAGE 448

DBCC USEROPTIONS 450

DEALLOCATE 451

decimal和numeric 454

DECLARE@local_variable 455

DECLARE CURSOR 460

DEGREES 468

DELETE 469

DENY 478

DIFFERENCE 482

DROP DATABASE 483

DROP DEFAULT 484

DROP FUNCTION 486

DROP INDEX 487

DROP PROCEDURE 488

DROP RULE 489

DROP STATISTICS 490

DROP TABLE 492

DROP TRIGGER 493

DROP VIEW 494

DUMP 495

ELSE(IF...ELSE) 496

END(BEGIN...END) 498

EXECUTE 500

EXISTS 508

EXP 513

表达式 514

FETCH 517

FILE_NAME 525

FILE_ID 525

FILEGROUP_ID 526

FILEGROUP_NAME 526

FILEGROUPPROPERTY 527

FILEPROPERTY 528

float和real 529

FLOOR 530

fn_helpcollations 530

fn_listextendedproperty 531

fn_servershareddrives 534

fn_trace_geteventinfo 535

fn_trace_getfilterinfo 536

fn_trace_getinfo 537

fn_trace_gettable 538

fn_virtualfilestats 539

fn_virtualservernodes 540

FORMATMESSAGE 540

FREETEXT 541

FREETEXTTABLE 543

FROM 544

FULLTEXTCATALOGPROPERTY 564

FULLTEXTSERVICEPROPERTY 565

函数 566

聚合函数 568

配置函数 569

游标函数 569

数学函数 570

日期和时间函数 570

元数据函数 571

行集函数 572

安全函数 572

字符串函数 573

系统函数 573

系统统计函数 575

文本和图像函数 575

GETANSINULL 576

GETDATE 577

GETUTCDATE 578

GO 578

GOTO 580

GRANT 582

GROUPING 590

GROUP BY 590

HAS_DBACCESS 591

HAVING 592

HOST_ID 592

HOST_NAME 593

IDENT_CURRENT 593

IDENT_INCR 596

IDENT_SEED 597

IDENTITY(属性) 598

IDENTITY(函数) 602

IF...ELSE 604

image 606

IN 607

INDEXKEY_PROPERTY 611

INDEXPROPERTY 612

INDEX_COL 614

信息架构视图 617

CHECK_CONSTRAINTS 619

COLUMN_DOMAIN_USAGE 620

COLUMN_PRIVILEGES 620

COLUMNS 621

CONSTRAINT_COLUMN_USAGE 623

CONSTRAINT_TABLE_USAGE 624

DOMAIN_CONSTRAINTS 624

DOMAINS 625

KEY_COLUMN_USAGE 627

PARAMETERS 627

REFERENTIAL_CONSTRAINTS 629

ROUTINES 631

ROUTINE_COLUMNS 635

SCHEMATA 637

TABLE_CONSTRAINTS 637

TABLE_PRIVILEGES 638

TABLES 639

VIEW_COLUMN_USAGE 639

VIEW_TABLE_USAGE 640

VIEWS 640

INSERT 641

int、bigint、smallint和tinyint 652

IS_MEMBER 653

IS_SRVROLEMEMBER 654

ISDATE 656

IS[NOT]NULL 657

ISNULL 659

ISNUMERIC 661

KILL 663

LEFT 666

LEN 668

LIKE 668

LOAD 677

LOG 678

LOG10 678

LOWER 679

LTRIM 681

MAX 682

MIN 683

money和smallmoney 684

MONTH 685

NCHAR 686

nchar和nvarchar 690

NEWID 691

Northwind示例数据库 694

Categories 694

Customers 694

CustomerCustomerDemo 695

CustomerDemographics 695

Employees 695

EmployeeTerritories 696

Order Details 696

Orders 697

Region 697

Products 698

Territories 699

Shippers 699

Suppliers 699

NOT 700

ntext、text和image 701

NULLIF 702

numeric 704

OBJECT_ID 704

OBJECT_NAME 705

OBJECTPROPERTY 706

OPEN 716

OPENDATASOURCE 718

OPENQUERY 720

OPENROWSET 721

OPENXML 725

运算符 733

OR 739

ORDER BY 740

PARSENAME 741

PATINDEX 743

PERMISSIONS 745

PI 748

POWER 748

Predicate 750

PRINT 750

pubs示例数据库 751

authors 752

discounts 754

employee 755

jobs 758

pub_info 759

publishers 760

roysched 761

sales 764

stores 765

titleauthor 766

titles 767

QUOTENAME 771

RADIANS 772

RAISERROR 774

RAND 779

READTEXT 780

RECONFIGURE 782

real 782

REPLACE 783

REPLICATE 784

保留关键字 788

RESTORE 795

RESTORE FILELISTONLY 811

RESTORE HEADERONLY 814

RESTORE LABELONLY 820

RESTORE VERIFYONLY 823

RETURN 826

REVERSE 829

REVOK 831

RIGHT 835

ROLLBACK TRANSACTION 837

ROLLBACK WORK 839

ROUND 840

ROWCOUNT_BIG 842

RTRIM 842

SAVE TRANSACTION 843

SCOPE_IDENTITY 846

搜索条件 849

SELECT@local_variable 854

SELECT 856

SELECT示列 857

SERVERPROPERTY 907

SESSION_USER 910

SESSIONPROPERTY 913

SET@local_variable 914

SET 920

SET ANSI_DEFAULTS 924

SET ANSI_NULL_DFLT_OFF 926

SET ANSI_NULL_DFLT_ON 929

SET ANSI_NULLS 933

SET ANSI_PADDING 936

SET ANSI_WARNINGS 939

SET ARITHABORT 943

SET ARITHIGNORE 946

SET CONCAT_NULL_YIELDS_NULL 948

SET CONTEXT_INFO 948

SET CURSOR_CLOSE_ON_COMMIT 949

SET DATEFIRST 952

SET DATEFORMAT 954

SET DISABLE_DEF_CNST_CHK 955

SET DEADLOCK_PRIORITY 955

SET FIPS_FLAGGER 956

SET FMTONLY 957

SET FORCEPLAN 957

SET IDENTITY_INSERT 959

SET IMPLICIT_TRANSACTIONS 961

SET LANGUAGE 964

SET LOCK_TIMEOUT 964

SET NOCOUNT 965

SET NOEXEC 966

SET NUMERIC_ROUNDABORT 968

SET OFFSETS 971

SET PARSEONLY 972

SET QUERY_GOVERNOR_COST_LIMIT 972

SET QUOTED_IDENTIFIER 973

SET REMOTE_PROC_TRANSACTIONS 977

SET ROWCOUNT 978

SET SHOWPLAN_ALL 980

SET SHOWPLAN_TEXT 983

SET STATISTICS IO 986

SET STATISTICS PROFILE 987

SET STATISTICS TIME 988

SET TEXTSIZE 988

SET TRANSACTION ISOLATION LEVE 989

SET XACT_ABORT 990

SETUSER 992

SHUTDOWN 994

SIGN 995

smalldatetime 997

SIN 997

smallint 998

smallmoney 998

SOME|ANY 998

SOUNDEX 999

SPACE 1000

sql_variant 1002

SQL_VARIANT_PROPERTY 1004

SQUARE 1007

SQRT 1007

STATS_DATE 1009

STDEV 1011

STDEVP 1011

STR 1012

STUFF 1014

SUBSTRING 1015

SUM 1020

SUSER_ID 1023

SUSER_NAME 1024

SUSER_SID 1025

SUSER_SNAME 1026

系统存储过程 1028

对象层次结构语法 1038

sp_ActiveDirectory_Obj 1040

sp_ActiveDirectory_SCP 1042

sp_add_alert 1043

sp_addalias 1047

sp_addapprole 1048

sp_add_data_file_recover_suspect_db 1050

sp_addextendedproc 1052

sp_addextendedproperty 1053

sp_addgroup 1055

sp_add_category 1055

sp_add_job 1056

sp_add_jobschedule 1060

sp_add_jobserver 1064

sp_addjobstep 1065

sp_addlinkedserver 1071

sp_addlinkedsrvlogin 1083

sp_add_log_file_recover_suspect_db 1086

sp_addlogin 1088

sp_add_log_shipping_database 1092

sp_add_log_shipping_plan 1092

sp_add_log_shipping_plan_database 1094

sp_add_log_shipping_primary 1096

sp_add_log_shipping_secondary 1098

sp_add_maintenance_plan 1100

sp_add_maintenance_plan_db 1101

sp_add_maintenance_plan_job 1101

sp_addmessage 1102

sp_add_notification 1104

sp_add_operator 1105

sp_addremotelogin 1109

sp_addrole 1110

sp_addrolemember 1111

sp_addserver 1113

sp_addsrvrolemember 1114

sp_addtype 1116

sp_addtask 1116

sp_add_targetservergroup 1119

sp_addumpdevice 1119

sp_add_targetsvrgrp_member 1122

sp_adduser 1123

sp_altermessage 1124

sp_apply_job_to_targets 1126

sp_approlepassword 1127

sp_attach_db 1128

sp_attach_single_file_db 1129

sp_autostats 1130

sp_bindefault 1131

sp_bindrule 1134

sp_bindsession 1136

sp_can_tlog_be_applied 1137

sp_catalogs 1138

sp_certify_removable 1139

sp_change_monitor_role 1140

sp_change_primary_role 1141

sp_change_secondary_role 1143

sp_changeS_users_login 1145

sp_changedbowner 1147

sp_changegroup 1148

sp_changeobjectowner 1149

sp_column_privileges 1150

sp_colunm_privileges_ex 1152

sp_columns 1155

sp_columns_ex 1157

sp_configure 1161

sp_create_log_shipping_monitor_account 1163

sp_create_removable 1163

sp_createstats 1165

sp_cursor_list 1167

sp_cycle_errorlog 1171

sp_databases 1171

sp_datatype_info 1172

sp_dbcmptlevel 1175

sp_dbfixedrolepermission 1180

sp_dboption 1182

sp_dbremove 1186

sp_defaultdb 1186

sp_defaultlanguage 1187

sp_define_log_shipping_monitor 1189

sp_delete_backuphistory 1190

sp_delete_alert 1190

sp_delete_category 1191

sp_delete_database_backuphistory 1192

sp_delete_job 1192

sp_delete_jobschedule 1193

sp_delete_jobserver 1194

sp_delete_jobstep 1195

sp_delete_log_shipping_database 1196

sp_delete_log_shipping_monitor_info 1197

sp_delete_log_shipping_plan 1197

sp_delete_log_shipping_plan_database 1198

sp_delete_log_shipping_primary 1199

sp_delete_maintenance_plan 1200

sp_delete_log_shipping_secondary 1200

sp_delete_maintenance_plan_db 1201

sp_delete_maintenance_plan_job 1202

sp_delete_notification 1202

sp_delete_operator 1203

sp_delete_targetserver 1204

sp_delete_targetservergroup 1204

sp_delete_targetsvrgrp_member 1205

sp_denylogin 1205

sp_depends 1207

sp_describe_cursor 1208

sp_describe_cursor_columns 1212

sp_describe_cursor_tables 1216

sp_detach_db 1220

sp_dropalias 1221

sp_dropdevice 1222

sp_dmpapprole 1222

sp_dropextendedproc 1223

sp_dropextendedproperty 1224

sp_dropgroup 1225

sp_droplinkedsrvlogin 1227

sp_droplogin 1228

sp_dropmessage 1229

sp_dropremotelogin 1230

sp_droprole 1232

sp_droprolemember 1233

sp_dropserver 1234

sp_dropsrvrolemember 1235

sp_droptype 1236

sp_droptask 1236

sp_dropuser 1237

sp_dropwebtask 1238

sp_enumcodepages 1239

sp_executesql 1240

sp_fkeys 1245

sp_foreignkeys 1248

sp_fulltext_catalog 1251

sp_fulltext_column 1254

sp_fulltext_database 1257

sp_fulltext_service 1258

sp_fulltext_table 1259

sp_getapplock 1263

sp_getbindtoken 1266

sp_get_log_shipping_monitor_info 1268

sp_grantdbaccess 1271

sp_grantlogin 1273

sp_help 1274

sp_help_alert 1278

sp_help_category 1281

sp_helpconstraint 1283

sp_helpdb 1284

sp_helpdbfixedrole 1286

sp_helpdevice 1287

sp_help_downloadlist 1289

sp_helpextendedproc 1292

sp_helpfile 1293

sp_help_fulltext_catalogs 1294

sp_helpfilegroup 1294

sp_help_fulltext_catalogs_cursor 1296

sp_help_fulltext_columns 1297

sp_help_fulltext_columns_cursor 1299

sp_help_fulltext_tables 1301

sp_help_fulltext_tables_cursor 1302

sp_helpgroup 1304

sp_helphistory 1305

sp_help_job 1305

sp_help_jobhistory 1314

sp_help_jobschedule 1318

sp_help_jobserver 1320

sp_help_jobstep 1322

sp_helpindex 1325

sp_helplanguage 1326

sp_helplinkedsrvlogin 1327

sp_helplogins 1329

sp_help_maintenance_plan 1331

sp_help_notification 1333

sp_helpntgroup 1336

sp_help_operator 1337

sp_helpremotelogin 1339

sp_helprole 1341

sp_helprolemember 1341

sp_helprotect 1342

sp_helpserver 1346

sp_helpsort 1348

sp_helpsrvrole 1348

sp_helpsrvrolemember 1350

sp_helpstats 1351

sp_help_targetserver 1352

sp_help_targetservergroup 1353

sp_helptask 1354

sp_helptext 1355

sp_helptrigger 1356

sp_helpuser 1357

sp_indexes 1359

sp_indexoption 1362

sp_invalidate_textptr 1363

sp_linkedservers 1364

sp_lock 1365

sp_makewebtask 1367

sp_manage_jobs_by_login 1399

sp_monitor 1400

sp_MShasdbaccess 1401

sp_msx_defect 1402

sp_msx_enlist 1402

sp_OACreate 1403

sp_OADestroy 1406

sp_OAGetErrorInfo 1407

sp_OAGetProperty 1410

sp_OAMethod 1413

sp_OASetProperty 1416

sp_OAStop 1417

sp_password 1418

sp_pkeys 1419

sp_primarykeys 1421

sp_post_msx_operation 1422

sp_processmail 1424

sp_procoption 1426

sp_purgehistory 1427

sp_purge_jobhistory 1427

sp_reassigntask 1428

sp_recompile 1429

sp_refreshview 1429

sp_releaseapplock 1430

sp_remoteoption 1431

sp_remove_job_from_targets 1433

sp_remove_log_shipping_monitor 1434

sp_rename 1434

sp_renamedb 1436

sp_resolve_logins 1437

sp_resetstatus 1437

sp_resync_targetserver 1438

sp_revokedbaccess 1439

sp_revokelogin 1440

sp_runwebtask 1441

sp_server_info 1442

sp_serveroption 1446

sp_setapprole 1449

sp_setnetname 1451

sp_settriggerorder 1452

sp_scriptsubconflicttable 1454

sp_spaceused 1455

sp_special_columns 1457

sp_sproc_columns 1459

sp_srvrolepermission 1463

sp_start_job 1464

sp_statistics 1465

sp_stop_job 1468

sp_stored_procedures 1469

sp_tableoption 1471

sp_table_privileges 1474

sp_table_privileges_ex 1476

sp_tables 1479

sp_tables_ex 1480

sp_trace_create 1482

sp_trace_generateevent 1485

sp_trace_setevent 1486

sp_trace_setfilter 1496

sp_trace_setstatus 1498

sp_unbindefault 1500

sp_unbindrule 1501

sp_update_alert 1503

sp_update_category 1507

sp_updateextendedproperty 1508

sp_update_job 1510

sp_update_jobschedule 1513

sp_update_jobstep 1517

sp_update_log_shipping_monitor_info 1521

sp_update_log_shipping_plan 1524

sp_update_log_shipping_plan_database 1526

sp_update_notification 1527

sp_update_operator 1528

sp_updatestats 1532

sp_update_targetservergroup 1532

sp_updatetask 1533

sp_validname 1533

sp_validatelogins 1534

sp_who 1535

sp_xml_preparedocument 1538

sp_xml_removedocument 1542

复制存储过程 1542

xp_cmdshell 1808

xp_deletemail 1811

xp_enumgroups 1812

xp_findnextmsg 1813

xp_grantlogin 1814

xp_logevent 1815

xp_loginconfig 1816

xp_logininfo 1818

xp_msver 1820

xp_readmail 1823

xp_revokelogin 1828

xp_sendmail 1828

xp_sprintf 1833

xp_sqlagent_proxy_account 1834

xp_sqlmaint 1837

xp_sscanf 1838

xp_startmail 1839

xp_stopmail 1841

系统表 1841

backupfile 1844

backupmediafamily 1845

backupmediaset 1846

backupset 1847

logmarkhistory 1850

log_shipping_databases 1850

log_shipping_monitor 1851

log_shipping_plan_databases 1851

log_shipping_plan_history 1852

log_shipping_plans 1853

log_shipping_primaries 1853

log_shipping_secondaries 1854

MSagent_parameters 1856

MSagent_profiles 1856

MSarticles 1857

MSdistribution_agents 1858

MSdistpublishers 1858

MSdistribution_history 1860

MSdistributiondbs 1861

MSdistributor 1862

MSdynamicsnapshotjobs 1862

MSdynamicsnapshotviews 1862

MSlogreader_agents 1863

MSlogreader_history 1863

MSmerge_agents 1864

MSmerge_altsyncpartners 1865

MSmerge_contents 1865

MSmerge_delete_conflicts 1866

MSmerge_genhistory 1867

MSmerge_errorlineage 1867

MSmerge_history 1868

MSmerge_replinfo 1869

MSmerge_subscriptions 1870

MSmerge_tombstone 1870

MSpub_identity_range 1870

MSpublication_access 1871

MSpublications 1872

MSpublisher_databases 1873

MSqreader_agents 1874

MSqreader_history 1874

MSrepl_backup_lsns 1875

MSrepl_commands 1876

MSrepl_errors 1876

MSrepl_originators 1877

MSrepl_identity_range 1877

MSrepl_transactions 1878

MSrepl_version 1878

MSreplication_objects 1878

MSreplicacion_options 1879

MSreplication_queue 1879

MSreplication_subscriptions 1880

MSsnapshot_agents 1881

MSsnapshot_history 1881

MSsubscriber_info 1882

MSsubscriber_schedule 1883

MSsubscription_agents 1884

MSsubscription_articles 1886

MSsubscription_properties 1887

MSsubscriptions 1888

MSsub_identity_range 1890

MSsync_states 1890

restorefile 1890

restorefilegroup 1891

restorehistory 1891

sysalerts 1892

sysaltfiles 1894

sysarticles 1894

sysarticleupdates 1896

syscacheobjects 1896

syscategories 1898

syscharsets 1899

syscolumns 1900

syscomments 1901

sysconfigures 1902

sysconstraints 1903

syscurconfigs 1903

sysdatabases 1904

sysdbmaintplan_databases 1906

sysdbmaintplan_history 1906

sysdbmaintplan_jobs 1907

sysdbmaintplans 1907

sysdepends 1908

sysdevices 1908

sysdownloadlist 1909

sysfiles 1910

sysforeignkeys 1911

sysfilegroups 1911

sysfulltextcatalogs 1912

sysindexes 1912

sysindexkeys 1914

sysjobhistory 1914

sysjobschedules 1915

sysjobs 1917

sysjobservers 1919

sysjobsteps 1920

syslanguages 1921

syslockinfo 1923

syslogins 1926

sysmembers 1928

sysmergepublications 1931

sysmergeschemaarticles 1934

sysmergeschemachange 1935

sysmergesubscriptions 1936

sysmergesubsetfilters 1938

sysmessages 1938

sysnotifications 1939

sysobjects 1939

sysoledbusers 1941

sysopentapes 1942

sysoperators 1942

sysperfinfo 1943

syspermissions 1944

sysprocesses 1944

sysprotects 1946

syspublications 1947

sysreferences 1950

sysremotelogins 1952

sysreplicationalerts 1952

sysschemaarticles 1953

sysservers 1955

syssubscriptions 1957

systargetservergroupmembers 1958

systaOrgetservergroups 1958

systargetservers 1958

systaskids 1959

systypes 1959

sysusers 1960

SYSTEM_USER 1961

table 1964

TEXTPTR 1966

text 1966

TAN 1966

TEXTVALID 1971

timestamp 1972

tinyint 1974

跟踪标记 1974

事务 1975

TRIGGER_NESTLEVEL 1976

TRUNCATE TABLE 1977

TYPEPROPERTY 1978

UNICODE 1979

UNION 1982

uniqueidentifier 1982

UPDATE 1983

UPDATE STATISTICS 1996

UPDATETEXT 1999

UPPER 2002

USE 2004

USER 2004

USER_ID 2007

USE_NAME 2007

VAR 2009

varbinary 2009

varchar 2009

VARP 2010

WAITFOR 2010

WHERE 2012

WHILE 2012

WRITETEXT 2015

YEAR 2017