tsql.txt

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

/L20"Transact-SQL" Nocase Block Comment On = /* Block Comment Off = */ Line Comment = -- String Chars = "' File Extensions = SQL TQL
/Delimiters = %^&*()-+|\/[];"'<> ,	.
/Indent Strings = "begin" "else"
/Unindent Strings = "end" "else"
/Function String = "%create [a-zA-Z_]*"
/C1"Commands"
ABSOLUTE ACTION ADD ALTER AS ASC AT AUTHORIZATION
BACKUP BEGIN BREAK BROWSE BULK BY
CASCADE CHECK CHECKPOINT CLOSE CLUSTERED COLLATE COLUMN COMMIT COMMITTED COMPUTE CONFIRM CONNECT CONNECTION CONSTRAINT CONTAINS CONTAINSTABLE CONTINUE CONTROLROW CREATE 
CUBE CURRENT CURRENT_DATE CURRENT_TIME
DATABASE DATE DBCC DEALLOCATE DECLARE DEFAULT DELETE DENY DESC DISK DISTINCT DISTRIBUTED DOUBLE DROP DUMMY DUMP DYNAMIC
ELSE END END-EXEC ERRLVL ERROREXIT ESCAPE EXCEPT EXEC EXECUTE EXIT
FALSE FETCH FILE FILLFACTOR FIRST FLOPPY FOR FOREIGN FORWARD_ONLY FREE FREETEXT FREETEXTTABLE FROM FULL FUNCTION
GLOBAL GO GOTO GRANT GROUP
HAVING HOLDLOCK HOUR
IDENTITYCOL IDENTITY_INSERT IF IGNORE INDEX INNER INSENSITIVE INSERT INTERSECT INTO IS ISOLATION
KEY KILL
LAST LEVEL LINENO LOAD LOCAL
MINUTE MIRROREXIT MODIFY MOVE
NATIONAL NEXT NO NOCHECK NONCLUSTERED NOUNLOAD
OF OFF OFFSETS ON ONLY OPEN OPENDATASOURCE OPENQUERY OPENROWSET OPENXML OPTION ORDER OUT OUTPUT OVER
PARTIAL PERCENT PERM PERMANENT PIPE PLAN PRECISION PREPARE PRIMARY PRINT PRIOR PRIVILEGES PROC PROCEDURE PROCESSEXIT PUBLIC
RAISERROR READ READTEXT READ_ONLY RECONFIGURE RECOVERY REFERENCES RELATIVE REPEATABLE REPLICATION RESTORE RESTRICT RETURN RETURNS REVOKE ROLLBACK ROLLUP ROWGUIDCOL ROWS RULE
SAVE SCHEMA SCROLL SECOND SECTION SELECT SEQUENCE SERIALIZABLE SET SETUSER SHUTDOWN SIZE STATIC STATISTICS STATS
TABLE TAPE TEMP TEMPORARY THEN TIME TO TOP TRAN TRANSACTION TRANSLATION TRIGGER TRUE TRUNCATE TSEQUAL
UNCOMMITTED UNION UNIQUE UPDATE UPDATETEXT USE
VALUES VARYING VIEW
WAITFOR WHEN WHERE WHILE WITH WORK WRITETEXT

/C2"Data types"
BIGINT BINARY BIT
CHAR CURSOR CHARACTER
DATETIME DEC DECIMAL
FLOAT
IMAGE INT INTEGER
MONEY
NCHAR NTEXT NUMERIC NVARCHAR
REAL
SMALLDATETIME SMALLINT SMALLMONEY SQL_VARIANT SYSNAME
TEXT TIMESTAMP TINYINT
UNIQUEIDENTIFIER 
VARBINARY VARCHAR

/C3"Operators"
%
&
(
)
*
+
,
-
.
// /
<
=
>
ALL AND ANY
BETWEEN
CROSS
EXISTS
IN
JOIN
LIKE
NOT NULL
OR OUTER
SOME
^
|
~

/C4"Stored procedures"
sp_abort_xact sp_add_agent_parameter sp_add_agent_profile sp_add_server_sortinfo sp_addalias sp_addapprole sp_addarticle sp_adddistpublisher sp_adddistributiondb 
sp_adddistributor sp_addextendedproc sp_addgroup sp_addlinkedserver sp_addlinkedsrvlogin sp_addlogin sp_addmergearticle sp_addmergefilter sp_addmergepublication 
sp_addmergepullsubscription sp_addmergepullsubscription_agent sp_addmergesubscription sp_addmessage sp_addpublication sp_addpublication_snapshot sp_addpublisher 
sp_addpullsubscription sp_addpullsubscription_agent sp_addremotelogin sp_addrole sp_addrolemember sp_addserver sp_addsrvrolemember sp_addsubscriber sp_addsubscriber_schedule 
sp_addsubscription sp_addsynctriggers sp_addtype sp_addumpdevice sp_adduser sp_altermessage sp_approlepassword sp_article_validation sp_articlecolumn sp_articlefilter 
sp_articlesynctranprocs sp_articleview sp_attach_db sp_attach_single_file_db sp_autostats sp_bindefault sp_bindrule sp_bindsession sp_blockcnt sp_catalogs sp_catalogs_rowset 
sp_certify_removable sp_change_subscription_properties sp_change_users_login sp_changearticle sp_changedbowner sp_changedistpublisher sp_changedistributiondb 
sp_changedistributor_password sp_changedistributor_property sp_changegroup sp_changemergearticle sp_changemergefilter sp_changemergepublication sp_changemergepullsubscription 
sp_changemergesubscription sp_changeobjectowner sp_changepublication sp_changesubscriber sp_changesubscriber_schedule sp_changesubscription sp_changesubstatus 
sp_check_for_sync_trigger sp_check_removable sp_check_removable_sysusers sp_check_sync_trigger sp_checknames sp_cleanupwebtask sp_column_privileges sp_column_privileges_ex 
sp_column_privileges_rowset sp_columns sp_columns_ex sp_columns_rowset sp_commit_xact sp_configure sp_create_removable sp_createorphan sp_createstats sp_cursor sp_cursor_list 
sp_cursorclose sp_cursorexecute sp_cursorfetch sp_cursoropen sp_cursoroption sp_cursorprepare sp_cursorunprepare sp_databases sp_datatype_info sp_db_upgrade sp_dbcmptlevel 
sp_dbfixedrolepermission sp_dboption sp_dbremove sp_ddopen sp_defaultdb sp_defaultlanguage sp_deletemergeconflictrow sp_denylogin sp_depends sp_describe_cursor 
sp_describe_cursor_columns sp_describe_cursor_tables sp_detach_db sp_diskdefault sp_distcounters sp_drop_agent_parameter sp_drop_agent_profile sp_dropalias sp_dropapprole 
sp_droparticle sp_dropdevice sp_dropdistpublisher sp_dropdistributiondb sp_dropdistributor sp_dropextendedproc sp_dropgroup sp_droplinkedsrvlogin sp_droplogin 
sp_dropmergearticle sp_dropmergefilter sp_dropmergepublication sp_dropmergepullsubscription sp_dropmergesubscription sp_dropmessage sp_droporphans sp_droppublication 
sp_droppublisher sp_droppullsubscription sp_dropremotelogin sp_droprole sp_droprolemember sp_dropserver sp_dropsrvrolemember sp_dropsubscriber sp_dropsubscription 
sp_droptype sp_dropuser sp_dropwebtask sp_dsninfo sp_enumcodepages sp_enumcustomresolvers sp_enumdsn sp_enumfullsubscribers sp_enumoledbdatasources sp_execute sp_executesql 
sp_fallback_MS_sel_fb_svr sp_fetchshowcmdsinput sp_fixindex sp_fkeys sp_foreign_keys_rowset sp_foreignkeys sp_fulltext_catalog sp_fulltext_column sp_fulltext_database 
sp_fulltext_getdata sp_fulltext_service sp_fulltext_table sp_generatefilters sp_get_distributor sp_getarticlepkcolbitmap sp_getbindtoken sp_GetMBCSCharLen 
sp_getmergedeletetype sp_gettypestring sp_grant_publication_access sp_grantdbaccess sp_grantlogin sp_help sp_help_agent_default sp_help_agent_parameter sp_help_agent_profile 
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_help_publication_access sp_helpallowmerge_publication sp_helparticle sp_helparticlecolumns sp_helpconstraint sp_helpdb sp_helpdbfixedrole sp_helpdevice sp_helpdistpublisher 
sp_helpdistributiondb sp_helpdistributor sp_helpdistributor_properties sp_helpextendedproc sp_helpfile sp_helpfilegroup sp_helpgroup sp_helpindex sp_helplanguage sp_helplog 
sp_helplogins sp_helpmergearticle sp_helpmergearticleconflicts sp_helpmergeconflictrows sp_helpmergedeleteconflictrows sp_helpmergefilter sp_helpmergepublication 
sp_helpmergepullsubscription sp_helpmergesubscription sp_helpntgroup sp_helppublication sp_helppublication_snapshot sp_helppublicationsync sp_helppullsubscription 
sp_helpremotelogin sp_helpreplicationdb sp_helpreplicationdboption sp_helpreplicationoption sp_helprole sp_helprolemember sp_helprotect sp_helpserver sp_helpsort sp_helpsql 
sp_helpsrvrole sp_helpsrvrolemember sp_helpstartup sp_helpsubscriber sp_helpsubscriberinfo sp_helpsubscription sp_helpsubscription_properties sp_helptext sp_helptrigger 
sp_helpuser sp_indexes sp_indexes_rowset sp_indexoption sp_isarticlecolbitset sp_IsMBCSLeadByte sp_link_publication sp_linkedservers sp_linkedservers_rowset sp_lock 
sp_lockinfo sp_logdevice sp_makestartup sp_makewebtask sp_mergedummyupdate sp_mergesubscription_cleanup sp_mergesubscriptioncleanup sp_monitor sp_MS_marksystemobject 
sp_MS_replication_installed sp_MS_upd_sysobj_category sp_MSactivate_auto_sub sp_MSadd_distributor_alerts_and_responses sp_MSadd_mergereplcommand sp_MSadd_repl_job 
sp_MSaddanonymousreplica sp_MSaddarticletocontents sp_MSaddexecarticle sp_MSaddguidcolumn sp_MSaddguidindex sp_MSaddinitialarticle sp_MSaddinitialpublication 
sp_MSaddinitialsubscription sp_MSaddlogin_implicit_ntlogin sp_MSaddmergepub_snapshot sp_MSaddmergetriggers sp_MSaddpub_snapshot sp_MSaddpubtocontents sp_MSaddupdatetrigger 
sp_MSadduser_implicit_ntlogin sp_MSarticlecleanup sp_MSarticletextcol sp_MSbelongs sp_MSchange_priority sp_MSchangearticleresolver sp_MScheck_agent_instance 
sp_MScheck_uid_owns_anything sp_MScheckatpublisher sp_MScheckexistsgeneration sp_MScheckmetadatamatch sp_MScleanup_subscription sp_MScleanuptask sp_MScontractsubsnb 
sp_MScreate_dist_tables sp_MScreate_distributor_tables sp_MScreate_mergesystables sp_MScreate_pub_tables sp_MScreate_replication_checkup_agent 
sp_MScreate_replication_status_table sp_MScreate_sub_tables sp_MScreateglobalreplica sp_MScreateretry sp_MSdbuseraccess sp_MSdbuserpriv sp_MSdeletecontents 
sp_MSdeletepushagent sp_MSdeleteretry sp_MSdelrow sp_MSdelsubrows sp_MSdependencies sp_MSdoesfilterhaveparent sp_MSdrop_6x_replication_agent 
sp_MSdrop_distributor_alerts_and_responses sp_MSdrop_mergesystables sp_MSdrop_object sp_MSdrop_pub_tables sp_MSdrop_replcom sp_MSdrop_repltran sp_MSdrop_rladmin 
sp_MSdrop_rlcore sp_MSdrop_rlrecon sp_MSdroparticleprocs sp_MSdroparticletombstones sp_MSdroparticletriggers sp_MSdropconstraints sp_MSdropmergepub_snapshot sp_MSdropretry 
sp_MSdummyupdate sp_MSenum_replication_agents sp_MSenum_replication_job sp_MSenum3rdpartypublications sp_MSenumallpublications sp_MSenumchanges sp_MSenumcolumns 
sp_MSenumdeletesmetadata sp_MSenumgenerations sp_MSenummergepublications sp_MSenumpartialchanges sp_MSenumpartialdeletes sp_MSenumpubreferences sp_MSenumreplicas 
sp_MSenumretries sp_MSenumschemachange sp_MSenumtranpublications sp_MSexists_file sp_MSexpandbelongs sp_MSexpandnotbelongs sp_MSexpandsubsnb sp_MSfilterclause