让Editplus支持sql语法高亮显示

来源：互联网发布：网络通信工程师编辑：程序博客网时间：2024/05/01 07:13

首先编写一段代码，存为.stx 文件（例如sql.stx），然后在editplus的菜单栏Tools-> Preferences->Files->Setting &syntax，,点add按钮，如下图：

在弹出框中填写上SQL，如下图：

再点击Advanced按钮，在弹出框的file Extensions栏位也填上SQL,如果有多个扩展名，之间用“；”隔开（例如：sql; db2），如下图：

然后在syntax file栏位填上sql.stx文件所在的路径，如下图：

下面是我的sql.stx文件源码（转载：http://hi.baidu.com/wriwgqzuyvfpvwe/item/c0cc27d67299d616d80e445b）：

#TITLE=SQL; SQL syntax file written by KK.#DELIMITER=,(){}[]-+*%/="'~!&|<>?:;.#QUOTATION1='#QUOTATION2="#LINECOMMENT=--#COMMENTON=/*#COMMENTOFF=*/#SPECIAL_STX=SQL#KEYWORD=SQL Tags;VARsql_variantdatetimesmalldatetimefloatrealdecimalmoneysmallmoneybigintintsmallinttinyintbitntexttextimageintegertimestampuniqueidentifiernvarcharncharvarcharcharCHARACTERvarbinarybinary#KEYWORD=Reserved wordsADDALLALTERANDANYASASCAUTHORIZATIONAVGBACKUPBEGINBETWEENBREAKBROWSEBULKBYCASCADECASECHECKCHECKPOINTCLOSECLUSTEREDCOALESCECOLUMNCOMMITCOMMENTCOMMITTEDCOMPUTECONFIRMCONNECTCONSTRAINTCONTAINSCONTAINSTABLECONTINUECONTROLROWCONVERTCOUNTCREATECROSSCURRENTCURRENT_DATECURRENT_TIMECURRENT_TIMESTAMPCURRENT_USERCURSORDATABASEDBCCDEALLOCATEDECLAREDEFAULT DELETEDENYDESCDISKDISTINCTDISTRIBUTEDDOUBLEDROPDUMMYDUMPELSEENDERRLVLERROREXITESCAPEEXCEPTEXECEXECUTEEXISTSEXITFETCHFILEFILLFACTORFLOPPYFORFOREIGNFREETEXTFREETEXTTABLEFROMFULLGOTOGRANTGROUPHAVINGHOLDLOCKIDENTITYIDENTITY_INSERTIDENTITYCOLIFININDEXINNERINSERTINTERSECTINTOISISOLATIONJOINKEYKILLLEFTLEVELLIKELINENOLOADMAXMINMIRROREXITNATIONALNOCHECKNONCLUSTEREDNOTNULLNULLIFOFOFFOFFSETSONONCEONLYOPENOPENDATASOURCEOPENQUERYOPENROWSETOPTIONORORDEROUTEROVERPERCENTPERMPERMANENTPIPEPLANPRECISIONPREPAREPRIMARYPRINTPRIVILEGESPROCPROCEDUREPROCESSEXITPUBLICRAISERRORREADREADTEXTRECONFIGUREREFERENCESREPEATABLEREPLICATIONRESTORERESTRICTRETURNREVOKERIGHTROLLBACKROWCOUNTROWGUIDCOLRULESAVESCHEMASELECTSERIALIZABLESESSION_USERSETSETUSERSHUTDOWNSOMESTATISTICSSUBSTRSUMSYSTEM_USERTABLETAPETEMPTEMPORARYTEXTSIZETHENTIMESTAMPTOTOPTRANTRANSACTIONTRIGGERTRUNCATETSEQUALUNCOMMITTEDUNIONUNIQUEUPDATEUPDATETEXTUSEUSERUSINGVALUESVARYINGVIEWWAITFORWHENWHEREWHILEWITHWORKWRITETEXT

1 0