首先编写一段代码,存为.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 ;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