home *** CD-ROM | disk | FTP | other *** search
/ Personal Computer World 2006 December / PCWDEC06.iso / Software / Shareware / Twistpad 1.1 / Setup.exe / Syntax / Sql2000.sdf < prev    next >
Encoding:
Text File  |  2006-04-29  |  6.3 KB  |  104 lines
  1. ;Microsoft Transact-SQL 2000 adicional Syntax highlight Script for Twistpad
  2. ;1998 - 2006 (C) Carthago Software
  3.  
  4. [::Header::]
  5. SyntaxName=Microsoft Transact-SQL 2000
  6. Extensions=_ss
  7. Functions=(?i)sElect*
  8. Spelling=0 
  9. SpellingContexts=1;2
  10.  
  11. [Comment1]
  12. Type=StartStop
  13. Context=1
  14. Priority=10
  15. Scope=0
  16. WholeWordOnly=0
  17. First=--
  18. Last=
  19. Background=Default
  20. Foreground=008000
  21.  
  22. [Comment2]
  23. Type=StartStop
  24. Context=2
  25. Scope=0
  26. Priority=10
  27. WholeWordOnly=0
  28. First=/*
  29. Last=*/
  30. Background=Default
  31. Foreground=008000
  32. Outline=1
  33.  
  34. [Quote]
  35. Type=StartStop
  36. Context=4
  37. Scope=0
  38. Priority=10
  39. WholeWordOnly=0
  40. First='
  41. Last='
  42. Background=Default
  43. Foreground=FF0000
  44.  
  45. [Operators]
  46. Type=keyword
  47. Context=101
  48. Scope=0
  49. Priority=6
  50. WholeWordOnly=1
  51. Keyword1=ALL;AND;ANY;BETWEEN;CROSS;EXISTS;IN;JOIN;LIKE;NOT;NULL;OR;OUTER;SOME
  52. Keyword2=
  53. Keyword3=
  54. Keyword4=
  55. Keyword5=
  56. Keyword6=
  57. Keyword7=
  58. Keyword8=
  59. Keyword9=
  60. Keyword10=
  61. Keyword11=
  62. Keyword12=
  63. Keyword13=
  64. Keyword14=
  65. Keyword15=
  66. Keyword16=
  67. Background=Default
  68. Foreground=808080
  69.  
  70. [SQL Keywords]
  71. Type=keyword
  72. Context=102
  73. Scope=0
  74. Priority=6
  75. WholeWordOnly=1
  76. Keyword1=ABSOLUTE;ACTION;ADD;AFTER;ALTER;ANSI_DEFAULTS;ANSI_NULLS;ANSI_NULL_DFLT_OFF;ANSI_NULL_DFLT_ON;ANSI_PADDING;ANSI_WARNINGS;APPEND;ARITHABORT;ARITHIGNORE;AS;ASC;AT;AUTHORIZATION;AUTO;BACKUP;BASE64;BEGIN;BLOCKSIZE;BREAK;BROWSE;BULK;BY;CASCADE;CHECK
  77. Keyword2=CHECKALLOC;CHECKCATALOG;CHECKDB;CHECKFILEGROUP;CHECKIDENT;CHECKPOINT;CHECKTABLE;CLOSE;CLUSTERED;COLLATE;COLUMN;COLUMNS;COMMIT;COMMITTED;COMPUTE;CONCAT;CONCAT_NULL_YIELDS_NULL;CONFIRM;CONNECT;CONNECTION;CONSTRAINT;CONTAINS;CONTAINSTABLE;CONTEXT_INFO;CONTINUE
  78. Keyword3=CONTROLROW;CREATE;CUBE;CURRENT;CURRENT_DATE;CURRENT_TIME;CURSOR;CURSOR_CLOSE_ON_COMMIT;DATABASE;DATE;DATEFORMAT;DBCC;DBREPAIR;DEADLOCK_PRIORITY;DEALLOCATE;DECLARE;DEFAULT;DELAY;DELETE;DENY;DESC;DESCRIPTION;DIFFERENTIAL;DISABLE_DEF_CNST_CHK;DISK;DISTINCT;DISTRIBUTED;DOUBLE;DROP;DROP_EXISTING;DUMMY
  79. Keyword4=DUMP;DYNAMIC;ELEMENTS;ELSE;ENCRYPTION;END;ERRLVL;ERROREXIT;ESCAPE;EXCEPT;EXEC;EXECUTE;EXIT;EXPIREDATE;EXPLICIT;FALSE;FAST;FASTFIRSTROW;FAST_FORWARD;FETCH;FILE;FILEGROUP;FILEGROWTH;FILELISTONLY;FILENAME;FILLFACTOR;FIPS_FLAGGER;FIRST;FLOPPY;FMTONLY;FOR;FORCE;FORCEPLAN;FOREIGN;FORMAT;FORWARD_ONLY;FREE
  80. Keyword5=FREETEXT;FREETEXTTABLE;FROM;FULL;FULLSCAN;FUNCTION;FUNCTIONS;GLOBAL;GOTO;GRANT;GROUP;GROUPING;HASH;HASH;HAVING;HEADERONLY;HELP;HOLDLOCK;HOUR;IDENTITYCOL;IDENTITY_INSERT;IF;IGNORE_DUP_KEY;IMPLICIT_TRANSACTIONS;INDEX;INIT;INNER;INPUTBUFFER;INSENSITIVE;INSERT;INSTEAD;INTERSECT;INTO;IO;IS;ISOLATION;KEEP;KEY;KEYSET;KILL;LABELONLY;LAST
  81. Keyword6=LEVEL;LINENO;LOAD;LOCAL;LOOP;MAX;MAXDOP;MAXSIZE;MEDIADESCRIPTION;MEDIANAME;MEDIAPASSWORD;MERGE;MIN;MINUTE;MIRROREXIT;MODIFY;MOVE;MSLOGREADER_HISTORY;NAME;NATIONAL;NEWALLOC;NEXT;NO;NOCHECK;NOCOUNT;NOEXEC;NOFORMAT;NOINIT;NOLOCK;NONCLUSTERED;NORECOMPUTE;NORECOVERY;NOREWIND;NOSKIP;NOUNLOAD;NO_LOG;NO_TRUNCATE;NUMERIC_ROUNDABORT;OF;OFF;OFFSETS
  82. Keyword7=ON;ONCE;ONLY;OPEN;OPENDATASOURCE;OPENQUERY;OPENROWSET;OPENTRAN;OPENXML;OPTIMISTIC;OPTION;ORDER;OUT;OUTPUT;OUTPUTBUFFER;OVER;PAD_INDEX;PAGLOCK;PARSEONLY;PARTIAL;PASSWORD;PERCENT;PERM;PERMANENT;PINTABLE;PIPE;PLAN;PRECISION;PREPARE;PRIMARY;PRINT;PRIOR;PRIVILEGES;PROC;PROCCACHE;PROCEDURE;PROCESSEXIT;PROFILE;PUBLIC;QUERY_GOVERNOR_COST_LIMIT;QUOTED_IDENTIFIER;RAISERROR;RAW;READ
  83. Keyword8=READCOMMITTED;READPAST;READTEXT;READUNCOMMITTED;READ_ONLY;RECOMPILE;RECONFIGURE;RECOVERY;REFERENCES;RELATIVE;REMOTE_PROC_TRANSACTIONS;REMOVE;REPEATABLE;REPEATABLEREAD;REPLICATION;RESTART;RESTORE;RESTRICT;RESTRICTED_USER;RETAINDAYS;RETURN;RETURNS;REVOKE;REWIND;ROBUST;ROLLBACK;ROLLUP;ROWGUIDCOL;ROWLOCK;ROWS;ROWVERSION;RULE;SAMPLE;SAVE;SCHEMA;SCHEMABINDING;SCROLL;SCROLL;SCROLL_LOCKS;SECOND
  84. Keyword9=SECTION;SELECT;SEQUENCE;SERIALIZABLE;SET;SETUSER;SHOWCONTIG;SHOWPLAN_ALL;SHOWPLAN_TEXT;SHOW_STATISTICS;SHRINKDATABASE;SHRINKFILE;SHUTDOWN;SIZE;SKIP;SQLPERF;STANDBY;STATIC;STATISTICS;STATISTICS_NORECOMPUTE;STATS;STOPAT;STOPATMARK;STOPBEFOREMARK;TABLE;TABLOCK;TABLOCKX;TAPE;TEMP;TEMPORARY;TEXTIMAGE_ON;THEN;TIME;TO;TOP;TRACEOFF;TRACEON;TRACESTATUS;TRAN;TRANSACTION;TRANSLATION;TRIGGER;TRUE;TRUNCATE;TRUNCATE_ONLY
  85. Keyword10=TSEQUAL;TYPE_WARNING;UNCOMMITTED;UNION;UNIQUE;UNLOAD;UNPINTABLE;UPDATE;UPDATETEXT;UPDATEUSAGE;UPDLOCK;USE;USEROPTIONS;VALUES;VARYING;VERIFYONLY;VIEW;VIEWS;VIEW_METADATA;WAITFOR;WHEN;WHERE;WHILE;WITH;WORK;WRITETEXT;XACT_ABORT;XML
  86. Keyword11=XMLDATA;BIGINT;BINARY;BIT;CHAR;CHARACTER;DATETIME;DEC;DECIMAL;FLOAT;IMAGE;INT;INTEGER;MONEY;NCHAR;NTEXT;NUMERIC;NVARCHAR;REAL;SMALLDATETIME;SMALLINT;SMALLMONEY;SQL_VARIANT;TEXT;TIMESTAMP;TINYINT;UNIQUEIDENTIFIER;VARBINARY;VARCHAR;GO
  87. Background=Default
  88. Foreground=0000FF
  89.  
  90.  
  91. [Functions]
  92. Type=keyword
  93. Context=103
  94. Scope=0
  95. Priority=6
  96. WholeWordOnly=1
  97. Keyword1=@@CONNECTIONS;@@CPU_BUSY;@@CURSOR_ROWS;@@DATEFIRST;@@DBTS;@@ERROR;@@FETCH_STATUS;@@IDENTITY;@@IDLE;@@IO_BUSY;@@LANGID;@@LANGUAGE;@@LOCK_TIMEOUT;@@MAX_CONNECTION;@@MAX_PRECISION;@@NESTLEVEL;@@OPTIONS;@@PACKET_ERRORS;@@PACK_RECEIVED;@@PACK_SENT;@@PROCID;@@REMSERVER;@@ROWCOUNT;@@SERVERNAME;@@SERVICENAME;@@SPID;@@TEXTSIZE;@@TIMETICKS;@@TOTAL_ERRORS
  98. Keyword2=@@TOTAL_READ;@@TOTAL_WRITE;@@TRANCOUNT;@@VERSION;ABS;ACOS;APP_NAME;ASCII;ASIN;ATAN;ATN2;AVG;BINARY_CHECKSUM;CASE;CAST;CEILING;CHARINDEX;CHECKSUM;CHECKSUM_AGG;COALESCE;COLLATIONPROPERT;COLUMNPROPERTY;COL_LENGTH;COL_NAME;CONVERT;COS;COT;COUNT;COUNT_BIG;CURRENT_TIMESTAM;CURRENT_USER;CURSOR_STATUS;DATABASEPROPERTY;DATABASEPROPERTY;DATALENGTH;DATEADD;DATEDIFF;DATENAME;DATEPART;DAY;DB_ID
  99. Keyword3=DB_NAME;DEGREES;DIFFERENCE;EXP;FILEGROUPPROPERT;FILEGROUP_ID;FILEGROUP_NAME;FILEPROPERTY;FILE_ID;FILE_NAME;FLOOR;FORMATMESSAGE;FULLTEXTCATALOGP;FULLTEXTSERVICEP;GETANSINULL;GETDATE;GETUTCDATE;HOST_ID;HOST_NAME;IDENTITY;IDENT_CURRENT;IDENT_INCR;IDENT_SEED;INDEXKEY_PROPERT;INDEXPROPERTY;INDEX_COL;ISDATE;ISNULL;ISNUMERIC;IS_MEMBER;IS_SRVROLEMEMBER;LEFT;LEN;LOG;LOG10;LOWER;LTRIM;MONTH;NEWID
  100. Keyword4=NULLIF;OBJECTPROPERTY;OBJECT_ID;OBJECT_NAME;PARSENAME;PATINDEX;PATINDEX;PERMISSIONS;PI;POWER;QUOTENAME;RADIANS;RAND;REPLACE;REPLICATE;REVERSE;RIGHT;ROUND;RTRIM;SCOPE_IDENTITY;SERVERPROPERTY;SESSIONPROPERTY;SESSION_USER;SIGN;SIN;SOUNDEX;SPACE;SQL_VARIANT_PROP;SQRT;SQUARE;STATS_DATE;STDEV;STDEVP;STR;STUFF;SUBSTRING;SUM;SUSER_ID;SUSER_NAME;SUSER_SID;SUSER_SNAME;SYSTEM_USER;TAN;TEXTPTR;TEXTVALID;TYPEPROPERTY;UNICODE
  101. Keyword5=UPPER;USER;USER;USER_ID;USER_NAME;VAR;VARP;YEAR
  102. Background=Default
  103. Foreground=FF00FF
  104.