EditPlus cannot colorize problems that display SQL statements

Description: Today, after reinstalling the system, downloaded from the online installation of a editplus reading code, found that the SQL statement is gray, not with the color of the previous look beautiful, suddenly feel uncomfortable up. Thought under the wrong version, but changed a few, are so, online check a bit, just know missing a coloring file. So, we can manually add this SQL coloring file on it.

Workaround:

(1) We first look at what the document, played the role of the syntax highlighting.

Because my English version, open EditPlus, open Tools, Preferences, Files, Setting &syntax

Chinese words: "Tools" preferences "file" "Settings and Syntax"

(2) Creation of coloring files

In that coloring folder, create a new TXT document, open, copy and paste the following code:

#TITLE=SQL; SQL SyntaxfileWritten byKK. #DELIMITER=,(){}[]-+*%/="'~!&|<>?:;. #QUOTATION1 ='#QUOTATION2="#LINECOMMENT=--#COMMENTON=#SPECIAL_STX=Sql#keyword=SQL Tags;VARsql_variantdatetimesmalldatetimefloatRealdecimal MoneysmallmoneybigintintsmallinttinyintbitntexttextImageintegertimestampuniqueidentifiernvarcharncharvarcharCharCHARACTERvarbinarybinary#KEYWORD=Reserved WordsADD AllALTER and any asASCAUTHORIZATIONAVGBACKUPBEGINbetween BreakBROWSEBULK byCASCADE CaseCHECKCHECKPOINTCLOSECLUSTEREDCOALESCECOLUMNCOMMITCOMMENTCOMMITTEDCOMPUTECONFIRMCONNECTCONSTRAINTCONTAINScontainstableCONTINUEControlrowCONVERTCOUNTCREATE Cross Currentcurrent_dateCurrent_timeCurrent_timestampCurrent_UserCURSORDATABASEDBCCdeallocateDECLAREDEFAULTDELETEDENYDESCDISKDISTINCTDistributedDOUBLEDROPDUMMYDUMPELSEENDERRLVLErrorexitESCAPEEXCEPTEXECEXECUTEEXISTSEXITFETCHFILEFILLFACTORFloppy forFOREIGNFREETEXTfreetexttable from FullGOTOGRANTGROUP havingHOLDLOCKIDENTITYIdentity_insertIdentitycolIFinchINDEXINNERINSERTINTERSECT into isIsolationJOINKEYKILL Left Level likeLinenoLOADMAXMINMirrorexit NationalNOCHECKnonclustered notNULLNullif ofOFFOffsets onONCE onlyOPENOpenDataSourceOPENQUERYOPENROWSETOPTIONORORDEROUTER OverPERCENTPERMPERMANENTPIPEPLANPRECISIONPREPAREPRIMARYPRINTPrivilegesPROCPROCEDUREProcessExit PublicRAISERRORREADREADTEXTRECONFIGUREREFERENCESRepeatableREPLICATIONRESTORERESTRICTRETURNREVOKE RightROLLBACKROWCOUNTROWGUIDCOLRULESAVESCHEMASELECTSERIALIZABLESession_userSETSETUSERSHUTDOWNSOMESTATISTICSSUBSTRSUMSystem_userTABLETAPETEMPTemporaryTEXTSIZE ThenTIMESTAMP toTOPTRANTRANSACTIONTRIGGERTRUNCATEtsequalUncommittedUNIONUNIQUEUPDATEUPDATETEXT UseUSERUSINGVALUESVARYINGVIEWWAITFOR whenWHERE while with WorkWRITETEXT

Save and modify the file name to Sql.stx. And then

Add a new file type. Click Add in the upper-right corner, adding a type, fill in the Description field Sql,file Extensions field is also filled with SQL, if there are multiple extensions, between the ";" (For example: SQL;DB2), then in the Syntax file field, fill in the path of SQL.STX files, or click ... button, select the SQL shader file you created yourself. By the end, don't forget to click the OK button.

EditPlus cannot colorize problems that display SQL statements