• 让Editplus支持sql语法高亮显示 sql.stx


    平时比较喜欢用editplus编辑器,用它来写JAVA程序,HTML程序和JSP程序,都很方便,但是最近我处于习惯用editplus来编写SQL存储过程的时候,就觉得很不舒服,主要是它不认SQL关键字,后来我发现这个问题其实是可以解决的。

          首先就是要自己编写一段代码,存为.stx 文件(例如sql.stx),然后在editplus的菜单栏Tools-> Configure User Tools->Files->Setting &syntax,点add按钮,在 description栏位填上sql,file Extensions栏位也填上sql,如果有多个扩展名,之间用“;”隔开(例如:sql; db2),然后在syntax file栏位填上sql.stx文件所在的路径,

    我的是在D:\tools\editplus\SQL.stx,这样就可以了。

    下面是我的sql.stx文件源码:

    #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


  • 相关阅读:
    BZOJ 2006 [NOI2010]超级钢琴
    标准打印一棵树
    COJ 0288 路径(2015升级版)
    批判树套树。。。。。。。。
    BestCoder Round #49
    蓝牙通信中读取固定长度数组的解决
    5月5日的规划
    必须要改变这样的生活
    五一结束
    五一来临
  • 原文地址:https://www.cnblogs.com/zhouwenwu/p/2429676.html
Copyright © 2020-2023  润新知