Ultraedit的SQL Server语法着色模板

为为Ultraedit添加SQL Server语法着色,

添加方法,将有颜色标注部分的文字复制到Ultraedit安装文件夹的wordfile.txt文档末尾,可以修改文字中的红色部分(20)为你想添加的语言编号

更多的语法着色文件可以从下列地址下载:

http://www.ultraedit.com/downloads/additional.html

/L20"SQL Server 2000" 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"
action add all alter and any as asc authorization avg
backup begin between break browse bulk by
cascade case check checkpoint close clustered coalesce collate column commit committed compute confirm constraint contains containstable continue controlrow convert count
create cross current current_date current_time current_timestamp current_user cursor
database dbcc deallocate declare default delete deny desc disable disk distinct distributed double drop dummy dump
else enable end errlvl errorexit escape except exec execute exists exit
fetch file fillfactor floppy for foreign forward_only freetext freetexttable from full function
go goto grant group
having holdlock
identity identity_insert identitycol if in index inner insert intersect into is isolation
join
key kill
left level like lineno load
mirrorexit move
national no nocheck nonclustered not nounload null nullif
of off offsets on once only open opendatasource openquery openrowset option or order outer over
percent perm permanent pipe plan precision prepare primary print privileges proc procedure processexit public
raiserror read readtext read_only reconfigure recovery references repeatable replication restore restrict return returns revoke right rollback rowcount rowguidcol rule
save schema select serializable session_user set setuser shutdown some statistics stats system_user
table tape temp temporary textsize then to top tran transaction trigger truncate tsequal
uncommitted union unique update updatetext use user
values varying view
waitfor when where while with work writetext

/C2"Data types"
bigint binary bit
char 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"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