sql.stx

; EditPlus Syntax File added by lmx88

; This file is provided as a default syntax file for ANSI SQL(especially for MS SQL server 2000)
#TITLE=ANSI_SQL
#DELIMITER=,()-+*/="'!<>:.
;#QUOTATION1="
#QUOTATION2='
#CONTINUE_QUOTE=y
#LINECOMMENT=--
#LINECOMMENT2=
#COMMENTON=/*
#COMMENTOFF=*/
#COMMENTON2=
#COMMENTOFF2=
#ESCAPE=
#CASE=N
#PREFIX1=
#PREFIX2=
#PREFIX3=
#PREFIX4=
#PREFIX5=
#SUFFIX1=
#SUFFIX2=
#SUFFIX3=
#SUFFIX4=
#SUFFIX5=

#KEYWORD=Reserved (blue)
ABSOLUTE
ADD
ALTER
ARITHABORT
ARITHIGNORE
AS
ASC
AT
AUTHORIZATION
BEGIN
BLOCKSIZE
BREAK
BROWSE
BY
CASCADE
CHAR
CHECK
CHECKALLOC
CHECKCATALOG
CHECKDB
CHECKPOINT
CHECKTABLE
CLOSE
CLUSTERED
columns
COMMIT
COMPUTE
CONCAT
CONNECT
CONSTRAINT
CONTINUE
CREATE
CURRENT
CURSOR
DATABASE
DATEFORMAT
DBCC
DBREPAIR
DEALLOCATE
DECLARE
DEFAULT
DELAY
DELETE
DESC
DISK
DISTINCT
DROP
DROP_EXISTING
DUMP
ELSE
END
ESCAPE
EXEC
EXECUTE
FAST
FETCH
FILE
FILLFACTOR
FIRST
FOR
FOREIGN
FROM
FULL
FUNCTION
GOTO
GRANT
GROUP
HASH
HAVING
HEADERONLY
HOLDLOCK
IDENTITY_INSERT
IF
IGNORE_DUP_KEY
INDEX
INIT
INNER
INSERT
INTO
IO
IS
ISOLATION
KEY
KILL
LAST
LEVEL
LOAD
LOOP
MAX
MERGE
MIN
MIRROR
MIRROREXIT
NAME
NEXT
NO_LOG
NOCOUNT
NOEXEC
NOINIT
NONCLUSTERED
NOUNLOAD
NOWAIT
OF
OFF
OFFSETS
ON
ONLY
OPEN
OPTION
ORDER
OUTPUT
OVERRIDE
PARSEONLY
PERCENT
PHYSNAME
PREPARE
PRIMARY
PRINT
PRIOR
PRIVILEGES
PROC
PROCEDURE
PROCESSEXIT
PUBLIC
QUOTED_IDENTIFIER
READ
READTEXT
RECOMPILE
RECONFIGURE
REFERENCES
RELATIVE
REMIRROR
REMOVE
RETAINDAYS
RETURN
RETURNS
REVOKE
ROLLBACK
ROWS
RULE
SAVE
SCHEMA
SELECT
SERIALIZABLE
SET
SETUSER
SHOWPLAN
SHUTDOWN
SIZE
SORTED_DATA
STATISTICS
STRIPE
TABLE
THEN
TIME
TO
TOP
TRACEOFF
TRACEON
TRAN
TRANSACTION
TRUNCATE
TRUNCATE_ONLY
TRIGGER
TSEQUAL
UNION
UNIQUE
UNLOAD
UNMIRROR
UPDATE
USE
VALUES
VDEVNO
VIEW
VSTART
WAITFOR
WHEN
WHERE
WHILE
WITH
WORK
WRITETEXT

#KEYWORD=Reserved (grey)
ALL
AND
ANY
BETWEEN
EXISTS
IN
JOIN
LIKE
NOT
NULL
OR
OUTER
SOME
||
%
(
)
*
!
+
-
.
<
>
<
>
/
=

#KEYWORD=system sp (brown)
sp_addalias
sp_addextendedproc
sp_addgroup
sp_addlogin
sp_addmessage
sp_addremotelogin
sp_addserver
sp_addtype
sp_addumpdevice
sp_adduser
sp_altermessage
sp_bindefault
sp_bindrule
sp_changedbowner
sp_changegroup
sp_checknames
sp_column_privileges
sp_columns
sp_configure
sp_databases
sp_datatype_info
sp_dboption
sp_defaultdb
sp_defaultlanguage
sp_depends
sp_diskdefault
sp_dropalias
sp_dropdevice
sp_dropextendedproc
sp_dropgroup
sp_droplogin
sp_dropmessage
sp_dropremotelogin
sp_dropserver
sp_droptype
sp_dropuser
sp_fixindex
sp_fkeys
sp_grantlogin
sp_help
sp_helpconstraint
sp_helpdb
sp_helpdevice
sp_helpextendedproc
sp_helpgroup
sp_helpindex
sp_helplanguage
sp_helplog
sp_helpremotelogin
sp_helprotect
sp_helpserver
sp_helpsort
sp_helptext
sp_helpuser
sp_lock
sp_logdevice
sp_monitor
sp_password
sp_pkeys
sp_processmail
sp_recompile
sp_remoteoption
sp_rename
sp_renamedb
sp_revokelogin
sp_server_info
sp_serveroption
sp_spaceused
sp_special_columns
sp_sproc_columns
sp_statistics
sp_stored_procedures
sp_table_privileges
sp_tables
sp_unbindefault
sp_unbindrule
sp_validlang
sp_who
sp_who2
xp_cmdshell
xp_deletemail
xp_enumgroups
xp_findnextmsg
xp_logevent
xp_readmail
xp_sendmail
xp_startmail
xp_stopmail

#KEYWORD=ANSI*SQL Functions & Global Var (pink)
ABS
ACOS
ASCII
ASIN
ATAN
ATN2
AVG
CASE
CAST
CEILING
CHARINDEX
COALESCE
COL_LENGTH
COL_NAME
CONVERT
COS
COT
COUNT
DATALENGTH
DATEADD
DATEDIFF
DATENAME
DATEPART
DAY
DB_ID
DEGREES
EXP
FLOOR
GETDATE
GETUTCDATE
HOST_ID
HOST_NAME
INDEX_COL
INDEXPROPERTY
ISNULL
LEFT
LOG
LOG10
LOWER
LTRIM
MONTH
NULLIF
OBJECT_ID
OBJECT_NAME
OBJECTPROPERTY
PATINDEX
PI
POWER
RADIANS
RAND
REPLACE
REPLICATE
REVERSE
RIGHT
ROUND
RTRIM
SIGN
SIN
SOUNDEX
SPACE
SQRT
STR
STUFF
SUBSTRING
SUM
SUSER_ID
SUSER_NAME
TAN
TEXTPTR
TEXTVALID
UPPER
USER
USER_ID
USER_NAME
YEAR
; global variable
@@CONNECTIONS
@@CPU_BUSY
@@CURSOR_ROWS
@@DATEFIRST
@@DBTS
@@ERROR
@@FETCH_STATUS
@@IDENTITY
@@IDLE
@@IO_BUSY
@@LANGID
@@LANGUAGE
@@LOCK_TIMEOUT
@@MAX_CONNECTIONS
@@MAX_PRECISION
@@NESTLEVEL
@@OPTIONS
@@PACK_RECEIVED
@@PACK_SENT
@@PACKET_ERRORS
@@PROCID
@@REMSERVER
@@ROWCOUNT
@@SERVERNAME
@@SERVICENAME
@@SPID
@@TEXTSIZE
@@TIMETICKS
@@TOTAL_ERRORS
@@TOTAL_READ
@@TOTAL_WRITE
@@TRANCOUNT
@@VERSION

#KEYWORD=Datatypes (blue)
bigint
binary
bit
char
datetime
decimal
double
float
image
int
money
nchar
numeric
nvarchar
real
smalldatetime
smallint
smallmoney
text
tinyint
varbinary
varchar

#KEYWORD=System Objects (green)
sysobjects
sysindexes
syscolumns
systypes
syscomments
syssegments
sysprotects
sysusers
sysalternates
sysdepends
sysreferences
sysconstraints
system

#