sql2000.txt

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

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_sqlagent_monitor xp_sqlagent_notify xp_sqlinventory xp_sqlmaint xp_sqlregister 
xp_sqltrace xp_sscanf xp_startmail xp_stopmail xp_subdirs xp_terminate_process xp_test_mapi_profile xp_trace_addnewqueue xp_trace_deletequeuedefinition xp_trace_destroyqueue 
xp_trace_enumqueuedefname xp_trace_enumqueuehandles xp_trace_eventclassrequired xp_trace_flushqueryhistory xp_trace_generate_event xp_trace_getappfilter 
xp_trace_getconnectionidfilter xp_trace_getcpufilter xp_trace_getdbidfilter xp_trace_getdurationfilter xp_trace_geteventfilter xp_trace_geteventnames xp_trace_getevents 
xp_trace_gethostfilter xp_trace_gethpidfilter xp_trace_getindidfilter xp_trace_getntdmfilter xp_trace_getntnmfilter xp_trace_getobjidfilter xp_trace_getqueueautostart 
xp_trace_getqueuecreateinfo xp_trace_getqueuedestination xp_trace_getqueueproperties xp_trace_getreadfilter xp_trace_getserverfilter xp_trace_getseverityfilter 
xp_trace_getspidfilter xp_trace_gettextfilter xp_trace_getuserfilter xp_trace_getwritefilter xp_trace_loadqueuedefinition xp_trace_opentracefile xp_trace_pausequeue 
xp_trace_restartqueue xp_trace_savequeuedefinition xp_trace_setappfilter xp_trace_setconnectionidfilter xp_trace_setcpufilter xp_trace_setdbidfilter xp_trace_setdurationfilter 
xp_trace_seteventclassrequired xp_trace_seteventfilter xp_trace_sethostfilter xp_trace_sethpidfilter xp_trace_setindidfilter xp_trace_setntdmfilter xp_trace_setntnmfilter 
xp_trace_setobjidfilter xp_trace_setqueryhistory xp_trace_setqueueautostart xp_trace_setqueuecreateinfo xp_trace_setqueuedestination xp_trace_setreadfilter 
xp_trace_setserverfilter xp_trace_setseverityfilter xp_trace_setspidfilter xp_trace_settextfilter xp_trace_setuserfilter xp_trace_setwritefilter xp_trace_startconsumer 
xp_trace_toeventlogconsumer xp_trace_tofileconsumer xp_unc_to_drive xp_unload_dummy_handlers xp_updatecolvbm xp_updatelineage xp_varbintohexstr xp_writesqlinfo
/C4"Operators" (Gray)
ALL AND ANY
BETWEEN
LIKE
EXISTS
JOIN
NOT
NULL
OR
OUTER
SOME
! !=
%
(
)
+
-
< <=
=
> >=
// /
|
[
]
/C5"Functions" (Cyan)
@@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 @@SERVERNAME @@SERVICENAME
@@SPID @@TEXTSIZE @@TIMETICKS @@TOTAL_ERRORS @@TOTAL_READ @@TOTAL_WRITE @@TRANCOUNT @@VERSION 
ABS ACOS APP_NAME ASCII ASIN ATAN ATN2 AVG
CASE CAST CEILING CHARINDEX COALESCE COLLATIONPROPERTY COLUMNPROPERTY COL_LENGTH COL_NAME CONVERT COS COT CURRENT_TIMESTAMP CURRENT_USER CURSOR_STATUS
DATABASEPROPERTY DATABASEPROPERTYEX DATALENGTH DATEADD DATEDIFF DATENAME DATEPART 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 GETUTCDATE
HAS_DBACCESS HOST_ID HOST_NAME
IDENT_CURRENT IDENT_INCR IDENT_SEED INDEXKEY_PROPERTY INDEXPROPERTY INDEX_COL ISDATE ISNULL ISNUMERIC IS_MEMBER IS_SRVROLEMEMBER
LEFT LEN LOG LOG10 LOWER LTRIM
MONTH 
NEWID NULLIF
OBJECTPROPERTY OBJECT_ID OBJECT_NAME
PARSENAME PATINDEX 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 
STR STUFF SUBSTRING SUM SUSER_SID SUSER_SNAME SYSTEM_USER
TAN TEXTPTR TEXTVALID TYPEPROPERTY
UNICODE UPPER USER USER_ID USER_NAME
YEAR
/C6"System Objects" (Green)
sysallocations sysalternates sysaltfiles syscacheobjects syscharsets syscolumns syscomments sysconfigures sysconstraints syscurconfigs syscursorcolumns syscursorrefs 
syscursors syscursortables sysdatabases sysdepends sysdevices sysfilegroups sysfiles sysfiles1 sysforeignkeys sysfulltextcatalogs sysindexes sysindexkeys syslanguages 
syslockinfo syslocks syslogins sysmembers sysmessages sysobjects sysoledbusers sysperfinfo syspermissions sysprocesses sysprotects sysreferences SYSREMOTE_CATALOGS 
SYSREMOTE_COLUMN_PRIVILEGES SYSREMOTE_COLUMNS SYSREMOTE_FOREIGN_KEYS SYSREMOTE_INDEXES SYSREMOTE_PRIMARY_KEYS SYSREMOTE_PROVIDER_TYPES SYSREMOTE_SCHEMATA SYSREMOTE_STATISTICS 
SYSREMOTE_TABLE_PRIVILEGES SYSREMOTE_TABLES SYSREMOTE_VIEWS sysremotelogins syssegments sysservers systypes sysusers sysxlogins