/L20"Transact SQL" Nocase Line Comment = -- Block Comment On = /* Block Comment Off = */ File Extensions = SQL
/C1 RESERVED WORDS
ABSOLUTE ACTION ALLOCATE ARE ASSERTION AT AUTHORIZATION
BOTH
CASCADE CASCADED CAST CATALOG CHAR_LENGTH CHARACTER CHARACTER_LENGTH COLLATE COLLATION COLUMN CONNECT CONNECTION CONSTRAINTS CORRESPONDING
DATE DAY DEFERRABLE DEFERRED DESCRIBE DESCRIPTOR DIAGNOSTICS DISCONNECT DOMAIN
END_EXEC ESCAPE EXCEPTION EXPIREDATE EXTERNAL EXTRACT
FALSE FILE FIRST FULL
GET GLOBAL
HOUR
IMMEDIATE INITIALLY INNER INPUT INTERVAL
JOIN
LAST LEADING LEFT LOCAL
MATCH MINUTE MONTH
NAMES NATIONAL NATURAL NCHAR NEXT NO
OCTET_LENGTH OUTER OUTPUT OVERLAPS
PAD PARTIAL POSITION PRESERVE PRIOR PRIVILEGES
RELATIVE RESTRICT RETAINDAYS RIGHT ROWS
SCHEMA SECOND SESSION SIZE SPACE SQLSTATE
TIME TIMEZONE_HOUR TIMEZONE_MINUTE TRAILING TRANSLATE TRANSLATION TRUE
UNKNOWN USAGE USING
VALUE VOLUME
WORK WRITE
YEAR
ZONE
/C2 KEYWORDS
ADD ALL ALTER AND ANY AS ASC AVG
BEGIN BETWEEN BREAK BROWSE BULK BY
CASE CHECK CHECKPOINT CLOSE CLUSTERED COALESCE COMMIT COMMITTED COMPUTE CONFIRM CONSTRAINT CONTINUE CONTROLROW CONVERT COUNT CREATE CURRENT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR
DATABASE DBCC DEALLOCATE DECLARE DEFAULT DELETE DESC DISK DISTINCT DOUBLE DROP DUMMY DUMP
ELSE END ERRLVL ERROREXIT EXCEPT EXEC EXECUTE EXISTS EXIT
FETCH FILLFACTOR FLOPPY FOR FOREIGN FROM
GOTO GRANT GROUP
HAVING HOLDLOCK
IDENTITY IDENTITY_INSERT IDENTITYCOL IF IN INDEX INSENSITIVE INSERT INTERSECT INTO IS ISOLATION
KEY KILL
LEVEL LIKE LINENO LOAD
MAX MIN MIRROREXIT
NOCHECK NONCLUSTERED NOT NULL NULLIF
OF OFF OFFSETS ON ONCE  ONLY OPEN OPTION OR ORDER OVER 
PERM PERMANENT PIPE PLAN PRECISION PREPARE PRIMARY PRINT PROC PROCEDURE PROCESSEXIT PUBLIC
RAISERROR READ RECONFIGURE REFERENCES REPEATABLE REPLICATION RETURN REVOKE ROLLBACK ROWCOUNT RULE
SAVE SCROLL SELECT SERIALIZABLE SESSION_USER SET SETUSER SHUTDOWN SOME STATISTICS SUM SYSTEM_USER
TABLE TAPE TEMP TEMPORARY TEXTSIZE THEN TO TRAN TRANSACTION TRIGGER TRUNCATE TSEQUAL
UNCOMMITTED UNION UNIQUE UPDATE UPDATETEXT USE USER
VALUES VARYING VIEW
WAITFOR WHEN WHERE WHILE WITH WRITETEXT
/C3 BUILT-IN STORED PROCEDURES
sp_column_privileges sp_special_columns sp_columns sp_sproc_columns sp_databases sp_statistics sp_datatype_info sp_stored_procedures sp_fkeys sp_table_privileges sp_pkeys sp_tables sp_server_info
sp_addpublisher sp_dropsubscriber sp_addsubscriber sp_helpdistributor sp_changesubscriber sp_helpserver sp_dboption sp_helpsubscriberinfo sp_droppublisher sp_replsync sp_addarticle sp_helparticle sp_addpublication sp_helparticlecolumns sp_articlecolumn sp_helppublication sp_changearticle sp_helppublicationsync sp_changepublication sp_helpreplicationdb sp_droparticle sp_replflush sp_droppublication sp_replstatus sp_enumfullsubscribers sp_addsubscription sp_helpsubscription sp_changesubscription sp_subscribe sp_changesubstatus sp_unsubscribe sp_dropsubscription sp_helpreplicationdb sp_distcounters sp_replica sp_replcleanup sp_replsync sp_MSkill_job sp_repldone sp_replcmds sp_repltrans sp_replcounters sp_addtask sp_helptask sp_droptask sp_addalert sp_helpalert sp_addnotification sp_helpnotification sp_addoperator sp_helpoperator sp_dropalert sp_updatealert sp_dropnotification sp_updatenotification sp_dropoperator sp_updateoperator sp_addtask sp_helptask sp_droptask sp_purgehistory sp_helphistory sp_updatetask
sp_MSSQLOLE65_version sp_MSSQLOLE_version sp_MS_upd_sysobj_category sp_MSdbuserprofile sp_MSdependencies sp_MSenumsubsystems sp_MSfilterclause sp_MSforeach_worker sp_MSforeachdb sp_MSforeachtable sp_MSgetalertinfo sp_MSgetexecinfo sp_MShelpcolumns sp_MShelpindex sp_MShelptype sp_MSindexspace sp_MSkilldb sp_MSloginmappings sp_MSmatchkey sp_MSobjectprivs sp_MSsetalertinfo sp_MSsetexecinfo sp_MSsettopology sp_MSsubscriptions sp_MStablechecks sp_MStablekeys sp_MStablerefs sp_MStablespace sp_MSuninstall_publishing sp_MSuniquename sp_TDGEN_CURSOR1 sp_TD_table_summary sp_TDaccess_server_drives sp_TDblocks sp_TDcheck_indexes sp_TDcheck_rowcount sp_TDdb_locks sp_TDdbsizes_data sp_TDdbsizes_log sp_TDdbsizes_total sp_TDdefault_db_audit sp_TDdevspace sp_TDdroplogin sp_TDformat_commas sp_TDget_logins sp_TDgetdbsizes sp_TDhelpdb sp_TDhelplogin sp_TDmirrorlogin sp_TDpassword_change sp_TDrunthis sp_TDspaceused sp_TDtable_sizes sp_TDupdate_stats sp_a_count_bits_on sp_abort_xact sp_add_app_user sp_addalias sp_addarticle sp_addextendedproc sp_addgroup sp_addlanguage sp_addlogin sp_addmessage sp_addpublication sp_addpublisher sp_addremotelogin sp_addsegment sp_addserver sp_addsubscriber sp_addsubscription sp_addtype sp_addumpdevice sp_adduser sp_altermessage sp_articlecolumn sp_articlefilter sp_articletextcol sp_articleview sp_bindefault sp_bindrule sp_blockcnt sp_certify_removable sp_change_users_login sp_changearticle sp_changedbowner sp_changegroup sp_changepublication sp_changesubscriber sp_changesubscription sp_changesubstatus sp_check_objects sp_check_removable sp_checknames sp_chklangparam sp_coalesce_fragments sp_column_privileges sp_columns sp_commit_xact sp_commonkey sp_configure sp_create_distribution_tables sp_create_removable sp_databases sp_datatype_info sp_db_locks sp_db_upgrade sp_db_upgrade1 sp_db_upgrade2 sp_db_upgrade3 sp_dbinstall sp_dboption sp_dbremove sp_ddopen sp_defaultdb sp_defaultlanguage sp_depends sp_devcreate sp_devoption sp_diskdefault sp_distcounters sp_dropalias sp_droparticle sp_dropdevice sp_dropextendedproc sp_dropgroup sp_dropkey sp_droplanguage sp_droplogin sp_dropmessage sp_droppublication sp_droppublisher sp_dropremotelogin sp_dropsegment sp_dropserver sp_dropsubscriber sp_dropsubscription sp_droptype sp_dropuser sp_dropwebtask sp_dsninfo sp_dtdba_checkfull sp_dtdba_constraint sp_dtdba_createsql sp_dtdba_freedevice sp_dtdba_getobj sp_dtdba_getobjectpermissions sp_dtdba_gettabkey sp_dtdba_gettabper sp_dtdba_getuserpermissions sp_dtdba_helpcolumn sp_dtdba_helpcolumn2 sp_dtdba_indexkeys sp_dtdba_userprotects sp_enumdsn sp_enumfullsubscribers sp_exec sp_extendsegment sp_fallback_MS_enroll_db sp_fallback_MS_enroll_dev sp_fallback_MS_enroll_usg sp_fallback_MS_sel_fb_svr sp_fallback_MS_verify_ri sp_fallback_activate_svr sp_fallback_deactivate_svr sp_fallback_deactivate_svr_db sp_fallback_enroll_svr_db sp_fallback_help sp_fallback_help_db_dev sp_fallback_permanent_svr sp_fallback_upd_dev_drive sp_fallback_withdraw_svr_db sp_fixindex sp_fkeys sp_foreignkey sp_get_volume_label sp_hcchangesubstatus1 sp_hcchangesubstatus2 sp_help sp_help_revdatabase sp_helparticle sp_helparticlecolumns sp_helpconstraint sp_helpdb sp_helpdevice sp_helpdistributor sp_helpextendedproc sp_helpgroup sp_helpindex sp_helpjoins sp_helpkey sp_helplanguage sp_helplog sp_helplogins sp_helppublication sp_helppublicationsync sp_helpremotelogin sp_helpreplicationdb sp_helprotect sp_helpsegment sp_helpserver sp_helpsort sp_helpsql sp_helpstartup sp_helpsubscriberinfo sp_helpsubscription sp_helptext sp_helpuser sp_kill sp_lock sp_lock2 sp_lockinfo sp_logdevice sp_lookup sp_makestartup sp_makewebtask sp_markreport sp_monitor sp_namecrack sp_namecrack_qi sp_objcheck sp_objectsegment sp_password sp_pkeys sp_placeobject sp_primarykey sp_probe_xact sp_processinfo sp_processmail sp_publishdb sp_recompile sp_remoteoption sp_remove_xact sp_rename sp_renamedb sp_replica sp_runwebtask sp_scan_xact
sp_schedulersignal sp_server_info sp_serveroption sp_setlangalias sp_setnetname sp_spaceused sp_special_columns sp_sproc_columns sp_sqlexec sp_sqlregister sp_start_xact sp_stat_xact sp_statistics sp_stored_procedures sp_subscribe sp_sysbackuphistory_limiter sp_table_privileges sp_tableoption sp_tables sp_tempdbspace sp_textcolstatus sp_unbindefault sp_unbindrule sp_unmakestartup sp_unsubscribe sp_user_counter1 sp_user_counter10 sp_user_counter2 sp_user_counter3 sp_user_counter4 sp_user_counter5 sp_user_counter6 sp_user_counter7 sp_user_counter8 sp_user_counter9 sp_userdefcounters sp_validlang sp_validname
sp_who sp_who2
xp_enumgroups xp_logininfo xp_grantlogin xp_revokelogin xp_loginconfig xp_deletemail xp_sendmail xp_findnextmsg xp_startmail xp_readmail xp_stopmail xp_cmdshell xp_sprintf xp_logevent xp_sscanf xp_msver
/C4 GLOBAL VARIABLES
CONNECTIONS CPU_BUSY CURSOR_ROWS
DATEFIRST DBTS
ERROR
FETCH_STATUS
IDLE IO_BUSY
LANGID LANGUAGE
MAX_CONNECTIONS MAX_PRECISION MICROSOFTVERSION
NESTLEVEL
PACK_RECEIVED PACK_SENT PACKET_ERRORS PROCID
REMSERVER
SERVERNAME SERVICENAME SPID
TIMETICKS TOTAL_ERRORS TOTAL_READ TOTAL_WRITE TRANCOUNT
VERSION
/C5 BUILT-IN FUNCTIONS
ABS ACOS ASCII ASIN ATAN ATN2 
COL_NAME CHARINDEX CHAR COT COS CEILING COL_LENGTH
DB_NAME DB_ID DATALENGTH DIFFERENCE DATEADD DATENAME  DATEDIFF DATEPART DEGREES
EXP
FLOOR
GETANSINULL GETDATE
HOST_ID HOST_NAME
ISNULL INDEX_COL IDENT_SEED IDENT_INCR
LOWER LTRIM LOG LOG10
OBJECT_ID OBJECT_NAME
PATINDEX POWER PI
RTRIM REVERSE REPLICATE RADIANS RAND ROUND
SUSER_NAME SUSER_ID STATS_DATE SUBSTRING STUFF STR SOUNDEX SIGN SIN SQRT
TEXTVALID TEXTPTR TAN
USER_NAME USER_ID UPPER
/C6 DATA TYPES
BINARY BIT
DATETIME DECIMAL
FLOAT
IMAGE INT
MONEY
NTEXT NUMERIC NVARCHAR
REAL
SMALLDATETIME SMALLMONEY
TEXT TIMESTAMP TINYINT
UNIQUEIDENTIFIER
VARBINARY VARCHAR