tsql.txt

UltraEdit中几百种语法高亮度显示

sp_MSflush_access_cache sp_MSflush_command sp_MSforeach_worker sp_MSforeachdb sp_MSforeachtable sp_MSgen_sync_tran_procs sp_MSgenreplnickname sp_MSgentablenickname 
sp_MSget_col_position sp_MSget_colinfo sp_MSget_oledbinfo sp_MSget_publisher_rpc sp_MSget_qualifed_name sp_MSget_synctran_commands sp_MSget_type sp_MSgetalertinfo 
sp_MSgetchangecount sp_MSgetconflictinsertproc sp_MSgetlastrecgen sp_MSgetlastsentgen sp_MSgetonerow sp_MSgetreplicainfo sp_MSgetreplnick sp_MSgetrowmetadata sp_MSguidtostr 
sp_MShelp_distdb sp_MShelp_replication_status sp_MShelpcolumns sp_MShelpfulltextindex sp_MShelpindex sp_MShelpmergearticles sp_MShelpobjectpublications sp_MShelptype 
sp_MSIfExistsRemoteLogin sp_MSindexcolfrombin sp_MSindexspace sp_MSinit_replication_perfmon sp_MSinsertcontents sp_MSinsertdeleteconflict sp_MSinsertgenhistory 
sp_MSinsertschemachange sp_MSis_col_replicated sp_MSis_pk_col sp_MSkilldb sp_MSload_replication_status sp_MSlocktable sp_MSloginmappings sp_MSmakearticleprocs 
sp_MSmakeconflictinsertproc sp_MSmakeexpandproc sp_MSmakegeneration sp_MSmakeinsertproc sp_MSmakejoinfilter sp_MSmakeselectproc sp_MSmakesystableviews sp_MSmaketempinsertproc 
sp_MSmakeupdateproc sp_MSmakeviewproc sp_MSmaptype sp_MSmark_proc_norepl sp_MSmatchkey sp_MSmergepublishdb sp_MSmergesubscribedb sp_MSobjectprivs sp_MSpad_command 
sp_MSproxiedmetadata sp_MSpublicationcleanup sp_MSpublicationview sp_MSpublishdb sp_MSrefcnt sp_MSregistersubscription sp_MSreinit_failed_subscriptions sp_MSrepl_addrolemember 
sp_MSrepl_dbrole sp_MSrepl_droprolemember sp_MSrepl_encrypt sp_MSrepl_linkedservers_rowset sp_MSrepl_startup sp_MSreplcheck_connection sp_MSreplcheck_publish 
sp_MSreplcheck_pull sp_MSreplcheck_subscribe sp_MSreplicationcompatlevel sp_MSreplrole sp_MSreplsup_table_has_pk sp_MSscript_beginproc sp_MSscript_begintrig1 
sp_MSscript_begintrig2 sp_MSscript_delete_statement sp_MSscript_dri sp_MSscript_endproc sp_MSscript_endtrig sp_MSscript_insert_statement sp_MSscript_multirow_trigger 
sp_MSscript_params sp_MSscript_security sp_MSscript_singlerow_trigger sp_MSscript_sync_del_proc sp_MSscript_sync_del_trig sp_MSscript_sync_ins_proc sp_MSscript_sync_ins_trig 
sp_MSscript_sync_upd_proc sp_MSscript_sync_upd_trig sp_MSscript_trigger_assignment sp_MSscript_trigger_exec_rpc sp_MSscript_trigger_fetch_statement 
sp_MSscript_trigger_update_checks sp_MSscript_trigger_updates sp_MSscript_trigger_variables sp_MSscript_update_statement sp_MSscript_where_clause sp_MSscriptdatabase 
sp_MSscriptdb_worker sp_MSsetaccesslist sp_MSsetalertinfo sp_MSsetartprocs sp_MSsetbit sp_MSsetconflictscript sp_MSsetconflicttable sp_MSsetfilteredstatus 
sp_MSsetfilterparent sp_MSsetlastrecgen sp_MSsetlastsentgen sp_MSsetreplicainfo sp_MSsetreplicastatus sp_MSsetrowmetadata sp_MSsettopology sp_MSsetupbelongs 
sp_MSSQLDMO70_version sp_MSSQLOLE_version sp_MSSQLOLE65_version sp_MSsubscribedb sp_MSsubscriptions sp_MSsubscriptionvalidated sp_MSsubsetpublication 
sp_MStable_has_unique_index sp_MStable_not_modifiable sp_MStablechecks sp_MStablekeys sp_MStablenamefromnick sp_MStablenickname sp_MStablerefs sp_MStablespace 
sp_MStestbit sp_MStextcolstatus sp_MSunc_to_drive sp_MSuniquecolname sp_MSuniquename sp_MSuniqueobjectname sp_MSuniquetempname sp_MSunmarkreplinfo 
sp_MSunregistersubscription sp_MSupdate_agenttype_default sp_MSupdate_replication_status sp_MSupdatecontents sp_MSupdategenhistory sp_MSupdateschemachange 
sp_MSupdatesysmergearticles sp_msupg_createcatalogcomputedcols sp_msupg_dosystabcatalogupgrades sp_msupg_dropcatalogcomputedcols sp_msupg_recreatecatalogfaketables 
sp_msupg_recreatesystemviews sp_msupg_removesystemcomputedcolumns sp_msupg_upgradecatalog sp_MSuplineageversion sp_MSvalidatearticle sp_OACreate sp_OADestroy 
sp_OAGetErrorInfo sp_OAGetProperty sp_OAMethod sp_OASetProperty sp_OAStop sp_objectfilegroup sp_oledbinfo sp_password sp_pkeys sp_prepare sp_primary_keys_rowset 
sp_primarykeys sp_probe_xact sp_procedure_params_rowset sp_procedures_rowset sp_processinfo sp_processmail sp_procoption sp_provider_types_rowset sp_publication_validation 
sp_publishdb sp_recompile sp_refreshsubscriptions sp_refreshview sp_reinitmergepullsubscription sp_reinitmergesubscription sp_reinitpullsubscription sp_reinitsubscription 
sp_remoteoption sp_remove_tempdb_file sp_remove_xact sp_removedbreplication sp_removesrvreplication sp_rename sp_renamedb sp_replcmds sp_replcounters sp_repldone sp_replflush 
sp_replica sp_replication_agent_checkup sp_replicationdboption sp_replicationoption sp_replincrementlsn sp_replpostcmd sp_replsetoriginator sp_replshowcmds sp_replsync 
sp_repltrans sp_replupdateschema sp_reset_connection sp_revoke_publication_access sp_revokedbaccess sp_revokelogin sp_runwebtask sp_scan_xact sp_schemata_rowset 
sp_script_synctran_commands sp_scriptdelproc sp_scriptinsproc sp_scriptmappedupdproc sp_scriptpkwhereclause sp_scriptupdateparams sp_scriptupdproc sp_sdidebug 
sp_sem_start_mail sp_server_info sp_serveroption sp_setapprole sp_setnetname sp_spaceused sp_special_columns sp_sproc_columns sp_sqlexec sp_sqlregister sp_srvrolepermission 
sp_start_xact sp_stat_xact sp_statistics sp_statistics_rowset sp_stored_procedures sp_subscribe sp_subscription_cleanup sp_subscriptioncleanup sp_table_privileges 
sp_table_privileges_ex sp_table_privileges_rowset sp_table_validation sp_tableoption sp_tables sp_tables_ex sp_tables_info_rowset sp_tables_rowset sp_tempdbspace 
sp_unbindefault sp_unbindrule sp_unmakestartup sp_unprepare sp_unsubscribe sp_updatestats 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_validatelogins sp_validlang sp_validname sp_who sp_who2 
spt_committab spt_datatype_info spt_datatype_info_ext spt_fallback_db spt_fallback_dev spt_fallback_usg spt_monitor spt_provider_types spt_server_info spt_values 
xp_availablemedia xp_check_query_results xp_cleanupwebtask xp_cmdshell xp_deletemail xp_dirtree xp_displayparamstmt xp_dropwebtask xp_dsninfo xp_enum_activescriptengines 
xp_enum_oledb_providers xp_enumcodepages xp_enumdsn xp_enumerrorlogs xp_enumgroups xp_eventlog xp_execresultset xp_fileexist xp_findnextmsg xp_fixeddrives 
xp_get_mapi_default_profile xp_get_mapi_profiles xp_get_tape_devices xp_getfiledetails xp_getnetname xp_grantlogin xp_initcolvs xp_intersectbitmaps xp_load_dummy_handlers 
xp_logevent xp_loginconfig xp_logininfo xp_makewebtask xp_mergexpusage xp_msver xp_msx_enlist xp_ntsec_enumdomains xp_ntsec_enumgroups xp_ntsec_enumusers xp_oledbinfo 
xp_param_dump xp_perfend xp_perfmonitor xp_perfsample xp_perfstart xp_printstatements xp_proxiedmetadata xp_qv xp_readerrorlog xp_readmail xp_regaddmultistring xp_regdeletekey 
xp_regdeletevalue xp_regenumvalues xp_regread xp_regremovemultistring xp_regwrite xp_revokelogin xp_runwebtask xp_sendmail xp_servicecontrol xp_showcolv xp_showlineage 
xp_snmp_getstate xp_snmp_raisetrap xp_sprintf xp_sqlagent_enum_jobs xp_sqlagent_is_starting xp_sqlage

/C5"Functions"
@@CONNECTIONS @@CPU_BUSY @@CURSOR_ROWS @@DATEFIRST @@DBTS @@ERROR @@FETCH_STATUS @@IDENTITY @@IDLE @@IO_BUSY @@LANGID @@LANGUAGE @@LOCK_TIMEOUT @@MAX_CONNECTIONS 
@@MAX_PRECISION @@NESTLEVEL @@OPTIONS @@PACKET_ERRORS @@PACK_RECEIVED @@PACK_SENT @@PROCID @@REMSERVER @@ROWCOUNT @@ROWCOUNT @@SERVERNAME @@SERVICENAME @@SPID @@TEXTSIZE 
@@TIMETICKS @@TOTAL_ERRORS @@TOTAL_READ @@TOTAL_WRITE @@TRANCOUNT @@TRANCOUNT @@VERSION
ABS ACOS APP_NAME ASCII ASIN ATAN ATN2 AVG
BINARY_CHECKSUM
CASE CAST CEILING CHARINDEX CHECKSUM CHECKSUM_AGG COALESCE COLLATIONPROPERTY COLUMNPROPERTY COL_LENGTH COL_NAME CONVERT COS COT COUNT COUNT_BIG CURRENT_TIMESTAMP 
CURRENT_USER CURSOR_STATUS
DATABASEPROPERTY DATABASEPROPERTYEX DATALENGTH DATENAME DAY DB_ID DB_NAME DEGREES DIFFERENCE
EXP
FILEGROUPPROPERTY FILEGROUP_ID FILEGROUP_NAME FILEPROPERTY FILE_ID FILE_NAME FLOOR FORMATMESSAGE FULLTEXTCATALOGPROPERTY FULLTEXTSERVICEPROPERTY
fn_helpcollations fn_listextendedproperty fn_servershareddrives fn_trace_geteventinfo fn_trace_getfilterinfo fn_trace_getinfo fn_trace_gettable fn_virtualfilestats
fn_virtualfilestats
GETANSINULL GETDATE GROUPING
HAS_DBACCESS HOST_ID HOST_NAME
IDENTITY IDENT_CURRENT IDENT_INCR IDENT_SEED INDEXKEY_PROPERTY INDEXPROPERTY INDEX_COL ISDATE ISNULL ISNUMERIC IS_MEMBER IS_SRVROLEMEMBER
LEFT LEN LOG LOG10 LOWER LTRIM
MAX MIN MONTH
NEWID NULLIF
OBJECTPROPERTY OBJECT_ID OBJECT_NAME
PARSENAME PATINDEX PERMISSIONS PI POWER
QUOTENAME
RADIANS RAND REPLACE REPLICATE REVERSE RIGHT ROUND ROWCOUNT_BIG RTRIM
SCOPE_IDENTITY SERVERPROPERTY SESSIONPROPERTY SESSION_USER SIGN SIN SOUNDEX SPACE SQL_VARIANT_PROPERTY SQRT SQUARE STATS_DATE STDEV STDEVP STR STUFF SUBSTRING SUM SUSER_SID 
SUSER_SNAME SYSTEM_USER
TAN TEXTPTR TEXTVALID TYPEPROPERTY
UNICODE UPPER USER USER_ID USER_NAME
VAR VARP
YEAR

/C6"Information Schema Views"
CHECK_CONSTRAINTS COLUMN_DOMAIN_USAGE COLUMN_PRIVILEGES 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

/C7"System Tables"
MSagent_parameters MSagent_profiles MSarticles MSdistpublishers MSdistribution_agents MSdistribution_history MSdistributiondbs MSdistributor MSlogreader_agents 
MSlogreader_history MSmerge_agents MSmerge_contents MSmerge_delete_conflicts MSmerge_genhistory MSmerge_history MSmerge_replinfo MSmerge_subscriptions MSmerge_tombstone 
MSpublication_access MSrepl_commands MSrepl_errors MSrepl_originators MSrepl_transactions MSrepl_version MSreplication_objects MSreplication_subscriptions 
MSsnapshot_agents MSsnapshot_history MSsubscriber_info MSsubscriber_schedule MSsubscription_properties MSsubscriptions Mspublications Mspublisher_databases
backupfile backupmediafamily backupmediaset backupset
restorefile restorefilegroup restorehistory
sysalerts sysaltfiles sysarticles sysarticleupdates syscacheobjects syscategories syscharsets syscolumns syscomments sysconfigures sysconstraints syscurconfigs 
sysdatabases sysdepends sysdevices sysdownloadlist sysfilegroups sysfiles sysforeignkeys sysfulltextcatalogs sysindexes sysindexkeys sysjobhistory sysjobs sysjobschedules 
sysjobservers sysjobsteps syslanguages syslockinfo syslogins sysmembers sysmergearticles sysmergepublications sysmergeschemachange sysmergesubscriptions 
sysmergesubsetfilters sysmessages sysnotifications sysobjects sysoledbusers sysoperators sysperfinfo syspermissions sysprocesses sysprotects syspublications 
sysreferences sysremotelogins sysreplicationalerts sysservers syssubscriptions systargetservergroupmembers systargetservergroups systargetservers systaskids 
systypes sysusers

/C8"DBCC & SET Statements"
ANSI_DEFAULTS ANSI_NULLS ANSI_NULL_DFLT_OFF ANSI_NULL_DFLT_ON ANSI_PADDING ANSI_WARNINGS ARITHABORT ARITHIGNORE
CHECKALLOC CHECKCATALOG CHECKCONSTRAINTS CHECKDB CHECKFILEGROUP CHECKIDENT CHECKTABLE CONCAT_NULL_YIELDS_NULL CURSOR_CLOSE_ON_COMMIT
DATEFIRST DATEFORMAT DBREINDEX DBREPAIR DEADLOCK_PRIORITY DISABLE_DEF_CNST_CHK
FIPS_FLAGGER FMTONLY FORCEPLAN
IDENTITY_INSERT IMPLICIT_TRANSACTIONS INDEXDEFRAG INPUTBUFFER
LANGUAGE LOCK_TIMEOUT
NEWALLOC NOCOUNT NOEXEC NUMERIC_ROUNDABORT
OFFSETS OPENTRAN OUTPUTBUFFER
PARSEONLY PINTABLE PROCCACHE
QUERY_GOVERNOR_COST_LIMIT QUOTED_IDENTIFIER
REMOTE_PROC_TRANSACTIONS ROWCOUNT ROWLOCK 
SHOWCONTIG SHOWPLAN_ALL SHOWPLAN_TEXT SHOW_STATISTICS SHRINKDATABASE SHRINKFILE SQLPERF STATISTICS_IO STATISTICS_PROFILE STATISTICS_TIME
TEXTSIZE TRACEOFF TRACEON TRACESTATUS TRANSACTION_ISOLATION_LEVEL
UNPINTABLE UPDATEUSAGE USEROPTIONS
XACT_ABORT