T-SQL Wordfile

T-SQL Wordfile

5
NewbieNewbie
5

    Jun 29, 2005#1

    /L12"T-SQL" T-SQL_LANG Line Comment = -- Block Comment On = /* Block Comment Off = */ File Extensions = SQL
    /Delimiters = ~!@%^&*()-+=|\/{}[]:;"'<> , .?
    /Function String = "%[ ^t]++[ps][a-z]+ [a-z0-9]+ ^(*(*)^)*{$"
    /C1
    ABSOLUTE ACTION ADA ADD ALL ALLOCATE ALTER AND ANY ARE AS ASC ASSERTION AT AUTHORIZATION AVG
    BACKUP BEGIN BETWEEN BIT BIT_LENGTH BOTH BREAK BROWSE BULK BY
    CASCADE CASCADED CASE CAST CATALOG CHAR CHARACTERCHARACTER_LENGTH CHAR_LENGTH CHECK CHECKPOINT CLOSE CLUSTERED COALESCE COLLATE COLLATION COLUMN COMMIT COMMITTED COMPUTE CONFIRM CONNECT CONNECTION CONSTRAINT CONSTRAINTS CONTAINS CONTAINSTABLE CONTINUE CONTROLROW CONVERT CORRESPONDING COUNT CREATE CROSS CURRENT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR
    DATABASE DATE DAY DBCC DEALLOCATE DEALLOCATE DEC DECIMAL DECLARE DEFAULT DEFERRABLE DEFERRED DELETE DENY DESC DESCRIBE DESCRIPTOR DIAGNOSTICS DISCONNECT DISK DISTINCT DISTRIBUTED DOMAIN DOUBLE DROP DUMMY DUMP
    ELSE END END-EXEC ERRLVL ERROREXIT ESCAPE EXCEPT EXCEPTION EXEC EXECUTE EXISTS EXIT EXTERNAL EXTRACT
    FALSE FETCH FILE FILLFACTOR FIRST FLOAT FLOPPY FOR FOREIGN FORTRAN FOUND FREETEXT FREETEXTTABLE FROM FULL
    GET GLOBAL GO GOTO GRANT GROUP
    HAVING HOLDLOCK HOUR
    IDENTITY IDENTITYCOL IDENTITY_INSERT IF IMMEDIATE IN INCLUDE INDEX INDICATOR INITIALLY INNER INPUT INSENSITIVE INSERT INT INTEGER INTERSECT INTERVAL INTO IS ISOLATION
    JOIN
    KEY KILL
    LANGUAGE LAST LEADING LEFT LEVEL LIKE LINENO LOAD LOCAL LOWER
    MATCH MAX MIN MINUTE MIRROREXIT MODULE MONTH
    NAMES NATIONAL NATURAL NCHAR NEXT NO NOCHECK NONCLUSTERED NONE NOT NULL NULLIF NUMERIC
    OCTET_LENGTH
    OF OFF OFFSETS ON ONCE ONLY OPEN OPENDATASOURCE OPENQUERY OPENROWSET OPTION OR ORDER OUTER OUTPUT OVER OVERLAPS
    PAD PARTIAL PASCAL PERCENT PERM PERMANENT PIPE PLAN POSITION PRECISION PREPARE PRESERVE PRIMARY PRINT PRIOR PRIVILEGES PROC PROCEDURE PROCESSEXIT PUBLIC
    RAISERROR READ READTEXT REAL RECONFIGURE REFERENCES RELATIVE REPEATABLE REPLICATION RESTORE RESTRICT RETURN REVOKE RIGHT ROLLBACK ROWCOUNT ROWGUIDCOL ROWS RULE
    SAVE SCHEMA SCROLL SECOND SECTION SELECT SERIALIZABLE SESSION SESSION_USER SET SETUSER SHUTDOWN SIZE SMALLINT SOME SOME SPACE SQL SQLCA SQLCODE SQLERROR SQLSTATE SQLWARNING STATISTICS SUBSTRING SUM SYSTEM_USER
    TABLE TAPE TEMP TEMPORARY TEXTSIZE THEN TIME TIMESTAMP TIMEZONE_HOUR TIMEZONE_MINUTE TO TOP TRAILING TRAN TRANSACTION TRANSLATE TRANSLATION TRIGGER TRIM TRUE TRUNCATE TSEQUAL
    UNCOMMITTED UNION UNIQUE UNKNOWN UPDATE UPDATETEXT UPPER USAGE USE USER USING
    VALUE VALUES VARCHAR VARYING VIEW
    WAITFOR WHEN WHENEVER WHERE WHILE WITH WORK WRITE WRITETEXT
    YEAR
    ZONE

    1
    NewbieNewbie
    1

      Nov 10, 2005#2

      Hello Leo,
      thank you for this great thing :D .

      I have one question:
      In our T-SQL Files we often have to handle with strings such like 'this is a string'.

      With the enhancement of the wordfile with your posting, strings are highlighted with the color light-grey.

      How can I change the T-SQL part in the wordfile that strings are highlighted in the color e.g. green? What can I do?
      I don't want to change the color of strings for all of the other languages.

      Thanx, Bernhard

      344
      MasterMaster
      344

        Nov 10, 2005#3

        Hi Bernhard,

        The color settings ARE all Language specific.
        Just go to Syntax-coloring AND SELECT your language.
        Choose "strings" and set your color. Thats it.
        You even can set a background color just for strings in TSQL.

        Use String Chars = "' (a normal hyphen and a double one)
        in Languaege config file if strings can start with ' or "

        rds Bego
        Normally using all newest english version incl. each hotfix. Win 10 64 bit