Transact-SQL Overview
 Transact-SQL Syntax Conventions
 New and Enhanced Features in Transact-SQL
 + (Add)
 + (Positive)
 + (String Concatenation)
 - (Negative)
 - (Subtract)
 * (Multiply)
 / (Divide)
 % (Modulo)
 % (Wildcard - Character(s) to Match)
 & (Bitwise AND)
 | (Bitwise OR)
 ^ (Bitwise Exclusive OR)
 ~ (Bitwise NOT)
 =(Equals)
 > (Greater Than)
 < (Less Than)
 >=(Greater Than or Equal To)
 <=(Less Than or Equal To)
 <> (Not Equal To)
 !< (Not Less Than)
 !=(Not Equal To)
 !> (Not Greater Than)
 -- (Comment)
 /*...*/ (Comment)
 [ ] (Wildcard - Character(s) to Match)
 [^] (Wildcard - Character(s) Not to Match)
 _ (Wildcard - Match One Character)
 @@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 and varbinary
 BINARY_CHECKSUM
 bit
 BREAK
 BULK INSERT
 CASE
 CAST and CONVERT
 CEILING
 char and varchar
 CHAR
 CHARINDEX
 CHECKPOINT
 CHECKSUM
 CHECKSUM_AGG
 CLOSE
 COALESCE
 COLLATE
    Windows Collation Name
    SQL Collation Name
 COLLATIONPROPERTY
 COL_LENGTH
 COL_NAME
 COLUMNPROPERTY
 COMMIT TRANSACTION
 COMMIT WORK
 Constants
 CONTAINS
 CONTAINSTABLE
 CONTINUE
 Control-of-Flow Language
 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
 Cursors
 DATABASEPROPERTY
 DATABASEPROPERTYEX
 Data Types
    Data Type Precedence
    Collation Precedence
    Precision, Scale, and Length
    Data Type Synonyms
 DATALENGTH
 DATEADD
 DATEDIFF
 DATENAME
 DATEPART
 datetime and 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 and 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
 Expressions
 FETCH
 FILE_ID
 FILE_NAME
 FILEGROUP_ID
 FILEGROUP_NAME
 FILEGROUPPROPERTY
 FILEPROPERTY
 float and 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
 FREETEXT
 FREETEXTTABLE
 FROM
 FULLTEXTCATALOGPROPERTY
 FULLTEXTSERVICEPROPERTY
 Functions
    Aggregate Functions
    Configuration Functions
    Cursor Functions
    Date and Time Functions
    Mathematical Functions
    Meta Data Functions
    Rowset Functions
    Security Functions
    String Functions
    System Functions
    System Statistical Functions
    Text and Image Functions
 GETANSINULL
 GETDATE
 GETUTCDATE
 GO
 GOTO
 GRANT
 GROUP BY
 GROUPING
 HAS_DBACCESS
 HAVING
 HOST_ID
 HOST_NAME
 IDENT_CURRENT
 IDENT_INCR
 IDENT_SEED
 IDENTITY (Property)
 IDENTITY (Function)
 IF...ELSE
 image
 IN
 INDEXKEY_PROPERTY
 INDEXPROPERTY
 INDEX_COL
 Information Schema Views
    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, and tinyint
 IS_MEMBER
 IS_SRVROLEMEMBER
 ISDATE
 IS [NOT] NULL
 ISNULL
 ISNUMERIC
 KILL
 LEFT
 LEN
 LIKE
 LOAD
 LOG
 LOG10
 LOWER
 LTRIM
 MAX
 MIN
 money and smallmoney
 MONTH
 NCHAR
 nchar and nvarchar
 NEWID
 Northwind Sample Database
    Categories
    Customers
    CustomerCustomerDemo
    CustomerDemographics
    Employees
    EmployeeTerritories
    Order Details
    Orders
    Products
    Region
    Shippers
    Suppliers
    Territories
 NOT
 ntext, text, and image
 NULLIF
 numeric
 OBJECT_ID
 OBJECT_NAME
 OBJECTPROPERTY
 OPEN
 OPENDATASOURCE
 OPENQUERY
 OPENROWSET
 OPENXML
 Operators
 OR
 ORDER BY
 PARSENAME
 PATINDEX
 PERMISSIONS
 PI
 POWER
 Predicate
 PRINT
 pubs Sample Database
    authors
    discounts
    employee
    jobs
    pub_info
    publishers
    roysched
    sales
    stores
    titleauthor
    titles
 QUOTENAME
 RADIANS
 RAISERROR
 RAND
 READTEXT
 real
 RECONFIGURE
 REPLACE
 REPLICATE
 Reserved Keywords
 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
 Search Condition
 SELECT @local_variable
 SELECT
    SELECT Examples
 SERVERPROPERTY
 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
 System Stored Procedures
    Object Hierarchy Syntax
    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_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
    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_bindefault
    sp_bindrule
    sp_bindsession
    sp_can_tlog_be_applied
    sp_catalogs
    sp_certify_removable
    sp_change_monitor_role
    sp_change_primary_role
    sp_change_secondary_role
    sp_change_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_backuphistory
    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_dropserver
    sp_dropsrvrolemember
    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_help_fulltext_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_helplanguage
    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_updateextendedproperty
    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
    Replication Stored Procedures
       sp_add_agent_parameter
       sp_add_agent_profile
       sp_addarticle
       sp_adddistpublisher
       sp_adddistributiondb
       sp_adddistributor
       sp_addmergealternatepublisher
       sp_addmergearticle
       sp_addmergefilter
       sp_addmergepublication
       sp_addmergepullsubscription
       sp_addmergepullsubscription_agent
       sp_addmergesubscription
       sp_addpublication
       sp_addpublication_snapshot
       sp_addpublisher70
       sp_addpullsubscription
       sp_addpullsubscription_agent
       sp_addscriptexec
       sp_addsubscriber
       sp_addsubscriber_schedule
       sp_addsubscription
       sp_addsynctriggers
       sp_addtabletocontents
       sp_adjustpublisheridentityrange
       sp_article_validation
       sp_articlecolumn
       sp_articlefilter
       sp_articlesynctranprocs
       sp_articleview
       sp_attachsubscription
       sp_browsesnapshotfolder
       sp_browsemergesnapshotfolder
       sp_browsereplcmds
       sp_change_agent_parameter
       sp_change_agent_profile
       sp_changearticle
       sp_changedistpublisher
       sp_changedistributiondb
       sp_changedistributor_password
       sp_changedistributor_property
       sp_changemergearticle
       sp_changemergefilter
       sp_changemergepublication
       sp_changemergepullsubscription
       sp_changemergesubscription
       sp_changepublication
       sp_changesubscriber
       sp_changesubscriber_schedule
       sp_changesubscriptiondtsinfo
       sp_changesubstatus
       sp_change_subscription_properties
       sp_check_for_sync_trigger
       sp_copymergesnapshot
       sp_copysnapshot
       sp_copysubscription
       sp_deletemergeconflictrow
       sp_disableagentoffload
       sp_drop_agent_parameter
       sp_drop_agent_profile
       sp_dropanonymouseagent
       sp_droparticle
       sp_dropdistpublisher
       sp_dropdistributiondb
       sp_dropdistributor
       sp_dropmergealternatepublisher
       sp_dropmergearticle
       sp_dropmergefilter
       sp_dropmergepublication
       sp_dropmergepullsubscription
       sp_dropmergesubscription
       sp_droppublication
       sp_droppullsubscription
       sp_dropsubscriber
       sp_dropsubscription
       sp_dsninfo
       sp_dumpparamcmd
       sp_enableagentoffload
       sp_enumcustomresolvers
       sp_enumdsn
       sp_enumfullsubscribers
       sp_expired_subscription_cleanup
       sp_generatefilters
       sp_getagentoffloadinfo
       sp_getmergedeletetype
       sp_get_distributor
       sp_getqueuedrows
       sp_getsubscriptiondtspackagename
       sp_grant_publication_access
       sp_help_agent_default
       sp_help_agent_parameter
       sp_help_agent_profile
       sp_helparticle
       sp_helparticlecolumns
       sp_helparticledts
       sp_helpdistpublisher
       sp_helpdistributiondb
       sp_helpdistributor
       sp_helpmergealternatepublisher
       sp_helpmergearticle
       sp_helpmergearticlecolumn
       sp_helpmergearticleconflicts
       sp_helpmergeconflictrows
       sp_helpmergedeleteconflictrows
       sp_helpmergefilter
       sp_helpmergepublication
       sp_helpmergepullsubscription
       sp_helpmergesubscription
       sp_helppublication
       sp_help_publication_access
       sp_helppullsubscription
       sp_helpreplfailovermode
       sp_helpreplicationdboption
       sp_helpreplicationoption
       sp_helpsubscriberinfo
       sp_helpsubscription
       sp_helpsubscription_properties
       sp_ivindexhasnullcols
       sp_link_publication
       sp_marksubscriptionvalidation
       sp_mergearticlecolumn
       sp_mergecleanupmetadata
       sp_mergedummyupdate
       sp_mergesubscription_cleanup
       sp_publication_validation
       sp_refreshsubscriptions
       sp_reinitmergepullsubscription
       sp_reinitmergesubscription
       sp_reinitpullsubscription
       sp_reinitsubscription
       sp_removedbreplication
       sp_repladdcolumn
       sp_replcmds
       sp_replcounters
       sp_repldone
       sp_repldropcolumn
       sp_replflush
       sp_replicationdboption
       sp_replication_agent_checkup
       sp_replqueuemonitor
       sp_replsetoriginator
       sp_replshowcmds
       sp_repltrans
       sp_restoredbreplication
       sp_resyncmergesubscription
       sp_revoke_publication_access
       sp_script_synctran_commands
       sp_setreplfailovermode
       sp_showrowreplicainfo
       sp_subscription_cleanup
       sp_table_validation
       sp_update_agent_profile
       sp_validatemergepublication
       sp_validatemergesubscription
       sp_vupgrade_replication
    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
 System Tables
    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
    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
    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
    sysdepends
    sysdevices
    sysdownloadlist
    sysfiles
    sysfilegroups
    sysforeignkeys
    sysfulltextcatalogs
    sysindexes
    sysindexkeys
    sysjobhistory
    sysjobschedules
    sysjobs
    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
    sysservers
    syssubscriptions
    systargetservergroupmembers
    systargetservergroups
    systargetservers
    systaskids
    systypes
    sysusers
 SYSTEM_USER
 table
 TAN
 text
 TEXTPTR
 TEXTVALID
 timestamp
 tinyint
 Trace Flags
 Transactions
 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