让Editplus支持sql语法高亮显示

版权声明:作者:jiankunking 出处:http://blog.csdn.net/jiankunking 本文版权归作者和CSDN共同拥有,欢迎转载。但未经作者允许必须保留此段声明,且在文章页面明显位置给出原文连接。 https://blog.csdn.net/xunzaosiyecao/article/details/30030163

        首先编写一段代码,存为.stx 文件(比如sql.stx),然后在editplus的菜单条Tools-> Preferences->Files->Setting &syntax,,点addbutton,例如以下图:


        在弹出框中填写上SQL,例如以下图:


       再点击Advancedbutton,在弹出框的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 ;VAR sql_variant datetime smalldatetime float real decimal money smallmoney bigint int smallint tinyint bit ntext text image integer timestamp uniqueidentifier nvarchar nchar varchar char CHARACTER varbinary binary #KEYWORD=Reserved words ADD ALL ALTER AND ANY AS ASC AUTHORIZATION AVG BACKUP BEGIN BETWEEN BREAK BROWSE BULK BY CASCADE CASE CHECK CHECKPOINT CLOSE CLUSTERED COALESCE COLUMN COMMIT COMMENT COMMITTED COMPUTE CONFIRM CONNECT 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 DISK DISTINCT DISTRIBUTED DOUBLE DROP DUMMY DUMP ELSE END ERRLVL ERROREXIT ESCAPE EXCEPT EXEC EXECUTE EXISTS EXIT FETCH FILE FILLFACTOR FLOPPY FOR FOREIGN FREETEXT FREETEXTTABLE FROM FULL 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 MAX MIN MIRROREXIT NATIONAL NOCHECK NONCLUSTERED NOT 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 RECONFIGURE REFERENCES REPEATABLE REPLICATION RESTORE RESTRICT RETURN REVOKE RIGHT ROLLBACK ROWCOUNT ROWGUIDCOL RULE SAVE SCHEMA SELECT SERIALIZABLE SESSION_USER SET SETUSER SHUTDOWN SOME STATISTICS SUBSTR SUM SYSTEM_USER TABLE TAPE TEMP TEMPORARY TEXTSIZE THEN TIMESTAMP TO TOP TRAN TRANSACTION TRIGGER TRUNCATE TSEQUAL UNCOMMITTED UNION UNIQUE UPDATE UPDATETEXT USE USER USING VALUES VARYING VIEW WAITFOR WHEN WHERE WHILE WITH WORK WRITETEXT




【推广】 免费学中医,健康全家人
原文地址:https://www.cnblogs.com/ldxsuanfa/p/10573326.html