• css
• hip1
  • .vscode
    • 4.1.php
  • 4.2
    • navigation_bar.html
    • page1.php
    • page2.php
    • page3.php
  • 11.2
    • firstpage.php
    • secondpage.php
  • 11.4
    • 11.4.html
    • 11.4.php
  • 11.5
    • page1.html
    • page2.php
    • page3.php
  • 11.9
    • 11.9.html
    • 11.9.php
  • 14.8
    • 14.8A.php
    • auteurs.php
    • timestuff.php
    • uitleningen.php
  • 16.2
    • ajax.php
    • info.php
    • main.php
  • po
    • cssmap
    • js
    • songs
      • text.php
    • albuminfo.php
    • albums.php
    • bandinfo.php
    • bandlist.php
    • concertinfo.php
    • concerts.php
    • functions.php
    • index.php
    • list.php
    • memberinfo.php
    • memberlist.php
    • songplayer.php
  • 10.1.php
  • 10.2.php
  • 10.3.php
  • 10.4.php
  • 11.1.php
  • 11.3.php
  • 11.6.php
  • 11.7.php
  • 11.8.php
  • 11.9.php
  • 12.php
  • 14.1.php
  • 14.2.php
  • 14.3.php
  • 14.4.php
  • 14.5.php
  • 14.6.php
  • 14.7.php
  • 15.1.php
  • 15.2.php
  • 15.php
  • 4.1.php
  • 6.1.php
  • 6.2.php
  • 6.3.php
  • 6.4.php
  • 7.1.php
  • 7.2.php
  • 7.3.php
  • 7.4.php
  • 7.5.php
  • 7.6.php
  • 9.1.php
  • 9.2.php
  • 9.3.php
  • 9.4.php
  • db.php
  • index.php
  • simonkoster.txt
  • test.php
• hip2
  • .vscode
  • afbeeldingen
  • css
  • db.php
  • gamedetails.php
  • games.php
  • genre.php
  • genres.php
  • home.php
  • index.php
  • leden.php
  • liddetails.php
  • menu.php
  • platformen.php
  • reviews.php
• hip3
• img
• javascriptcursus
  • _notes
  • css
    • _notes
  • img
    • _notes
    • screenshots
      • _notes
  • js
    • _notes
  • php
    • _notes
    • admin
      • _notes
      • answers.php
      • assignments.php
      • delete_assignment.php
      • edit_assignment.php
      • home.php
      • logout.php
      • new_assignment.php
    • geshi
      • _notes
      • contrib
        • _notes
        • aliased.php
        • cssgen.php
        • cssgen2.php
        • example.php
        • langcheck.php
        • langwiz.php
      • docs
        • _notes
        • api
          • __filesource
            • _notes
            • fsource_geshi_core_geshi.php.html
          • _notes
          • geshi
            • core
              • _notes
              • GeSHi.html
              • _geshi.php.html
          • media
            • _notes
            • images
              • _notes
          • blank.html
          • classtrees_geshi.html
          • elementindex.html
          • elementindex_geshi.html
          • errors.html
          • index.html
          • li_geshi.html
          • packages.html
          • todolist.html
        • geshi-doc.html
        • geshi-doc.txt
      • geshi
        • _notes
        • 4cs.php
        • 6502acme.php
        • 6502kickass.php
        • 6502tasm.php
        • 68000devpac.php
        • abap.php
        • actionscript.php
        • actionscript3.php
        • ada.php
        • algol68.php
        • apache.php
        • applescript.php
        • apt_sources.php
        • asm.php
        • asp.php
        • autoconf.php
        • autohotkey.php
        • autoit.php
        • avisynth.php
        • awk.php
        • bascomavr.php
        • bash.php
        • basic4gl.php
        • bf.php
        • bibtex.php
        • blitzbasic.php
        • bnf.php
        • boo.php
        • c.php
        • c_loadrunner.php
        • c_mac.php
        • caddcl.php
        • cadlisp.php
        • cfdg.php
        • cfm.php
        • chaiscript.php
        • cil.php
        • clojure.php
        • cmake.php
        • cobol.php
        • coffeescript.php
        • cpp-qt.php
        • cpp.php
        • csharp.php
        • css.php
        • cuesheet.php
        • d.php
        • dcs.php
        • delphi.php
        • diff.php
        • div.php
        • dos.php
        • dot.php
        • e.php
        • ecmascript.php
        • eiffel.php
        • email.php
        • epc.php
        • erlang.php
        • euphoria.php
        • f1.php
        • falcon.php
        • fo.php
        • fortran.php
        • freebasic.php
        • fsharp.php
        • gambas.php
        • gdb.php
        • genero.php
        • genie.php
        • gettext.php
        • glsl.php
        • gml.php
        • gnuplot.php
        • go.php
        • groovy.php
        • gwbasic.php
        • haskell.php
        • hicest.php
        • hq9plus.php
        • html4strict.php
        • html5.php
        • icon.php
        • idl.php
        • ini.php
        • inno.php
        • intercal.php
        • io.php
        • j.php
        • java.php
        • java5.php
        • javascript.php
        • jquery.php
        • kixtart.php
        • klonec.php
        • klonecpp.php
        • latex.php
        • lb.php
        • lisp.php
        • llvm.php
        • locobasic.php
        • logtalk.php
        • lolcode.php
        • lotusformulas.php
        • lotusscript.php
        • lscript.php
        • lsl2.php
        • lua.php
        • m68k.php
        • magiksf.php
        • make.php
        • mapbasic.php
        • matlab.php
        • mirc.php
        • mmix.php
        • modula2.php
        • modula3.php
        • mpasm.php
        • mxml.php
        • mysql.php
        • newlisp.php
        • nsis.php
        • oberon2.php
        • objc.php
        • objeck.php
        • ocaml-brief.php
        • ocaml.php
        • oobas.php
        • oracle11.php
        • oracle8.php
        • oxygene.php
        • oz.php
        • pascal.php
        • pcre.php
        • per.php
        • perl.php
        • perl6.php
        • pf.php
        • php-brief.php
        • php.php
        • pic16.php
        • pike.php
        • pixelbender.php
        • pli.php
        • plsql.php
        • postgresql.php
        • povray.php
        • powerbuilder.php
        • powershell.php
        • proftpd.php
        • progress.php
        • prolog.php
        • properties.php
        • providex.php
        • purebasic.php
        • pycon.php
        • python.php
        • q.php
        • qbasic.php
        • rails.php
        • rebol.php
        • reg.php
        • robots.php
        • rpmspec.php
        • rsplus.php
        • ruby.php
        • sas.php
        • scala.php
        • scheme.php
        • scilab.php
        • sdlbasic.php
        • smalltalk.php
        • smarty.php
        • sql.php
        • systemverilog.php
        • tcl.php
        • teraterm.php
        • text.php
        • thinbasic.php
        • tsql.php
        • typoscript.php
        • unicon.php
        • uscript.php
        • vala.php
        • vb.php
        • vbnet.php
        • verilog.php
        • vhdl.php
        • vim.php
        • visualfoxpro.php
        • visualprolog.php
        • whitespace.php
        • whois.php
        • winbatch.php
        • xbasic.php
        • xml.php
        • xorg_conf.php
        • xpp.php
        • yaml.php
        • z80.php
        • zxbasic.php
      • geshi.php
    • adminpage.php
    • assignments.php
    • bookpage.php
    • chapter_titles.php
    • meekrodb.2.3.class.php
    • page.php
  • admin.php
  • hoofdstuk_1.php
  • hoofdstuk_10.php
  • hoofdstuk_11.php
  • hoofdstuk_2.php
  • hoofdstuk_3.php
  • hoofdstuk_4.php
  • hoofdstuk_5.php
  • hoofdstuk_6.php
  • hoofdstuk_7.php
  • hoofdstuk_8.php
  • hoofdstuk_9.php
  • index.php
  • inhoudsopgave.php
  • links.php
  • opdrachten.php
  • playground-preview.php
  • playground.php
  • voorbeeld.php
• l100
  • Lessen
    • les 1.php
    • menu.html
  • opdrachten
    • 4.1.php
    • 4.2.1.html
    • 4.2.1.php
    • 4.2.2.html
  • db.php
  • index.php
  • svenvanderberg.txt
• l101
  • lessen
    • les1.php
    • les1menu.html
  • opdrachten
    • H4
      • 4.1.php
      • 4.2.php
    • 4.1.php
    • 4.2.html
    • 4.2.php
  • db.php
  • frisoderuiter.txt
  • index.php
• l102
  • .vscode
  • db.php
  • index.php
  • thorstenkorving.txt
• l103
  • DestanYildirim.txt
  • db.php
  • index.php
  • les1.php
  • menu.html
• l104
  • 4.1.php
  • 4.2.php
  • db.php
  • index.php
  • menu.html
  • ryankobus.txt
• l105
  • H4
    • 1.php
  • klas 5
    • P2
      • phpserver
        • H4
          • 4.2
            • menu.html
            • website 1.php
            • website 2.php
  • db.php
  • index.php
  • jedidjafabriek.txt
• l106
  • werkmap
    • aan elkaar
      • 1efile.php
      • hoem.php
      • idk.php
      • nynm.php
    • nog een file.php
  • Mats Rooijakkers.txt
  • db.php
  • index.php
• l107
  • phpserver
    • Opdrachten
      • H4
        • 4.2
          • hoofdpagina.php
          • menu.php
        • 4.1.php
  • KaiHolzinger.txt
  • db.php
  • index.php
• l108
  • 4.1.php
  • Daan_Schmitz.txt
  • db.php
  • index.php
• l109
  • db.php
  • index.php
• l110
  • db.php
  • index.php
• l111
  • db.php
  • index.php
• l112
  • db.php
  • index.php
• l113
  • .vscode
  • db.php
  • index.php
• l114
  • db.php
  • index copy.php
  • index.php
• l115
  • db.php
  • index.php
• l116
  • db.php
  • index.php
• l117
  • db.php
  • index.php
• l118
  • index.php
• l119
  • db.php
  • index.php
• l120
  • db.php
  • index.php
• l200
  • Hoofdstuk 4
    • 4.1.php
    • 4.2.php
    • menu.php
    • pag1.php
    • pag2.php
    • pag3.php
  • Hoofdstuk 6
    • 6.2.6.1.php
    • 6.2.6.2.php
    • 6.2.6.3.php
  • db.php
  • index.php
  • marielleharte.txt
• l201
  • JaydenHillebrandt.txt
  • db.php
  • index.php
• l202
  • 4.1.php
  • 6.1-4.php
  • db.php
  • index.php
  • markvossebeld.txt
  • menu.php
• l203
  • db.php
  • index.php
• l204
  • db.php
  • index.php
  • nawarkodaesat.txt
  • vastevoettekst.php
  • voorbeeld.php
• l205
  • db.php
  • index.php
  • matteoxu.txt
• l206
  • db.php
  • index.php
  • nisrinefaress.txt
• l207
  • db.php
  • index.php
• l208
  • db.php
  • index.php
• l209
  • db.php
  • index.php
• l210
  • db.php
  • index.php
• l211
  • db.php
  • index.php
• l212
  • db.php
  • index.php
• l213
  • db.php
  • index.php
• l214
  • db.php
  • index.php
• l215
  • db.php
  • index.php
• test
  • fcgi
    • test.html
  • perl
    • test.html
  • php
    • test.html
    • test.php
  • python
    • test.html
  • ssi
    • test.html
• x100
  • .vscode
  • A3.php
  • B2.php
  • C2.php
  • D2.php
  • E1.php
  • H4.php
  • I1_1.php
  • I1_2.php
  • K1.php
  • L1.php
  • M1.php
  • SachaDubbelman_V5.txt
  • db.php
  • index.php
• x101
  • A4.php
  • B1.php
  • C2.php
  • D2.php
  • E1.php
  • F4.php
  • MatsRooijakkers_V5c.txt
  • db.php
  • index.php
• x102
  • .vscode
  • A4.php
  • B1.php
  • D2.php
  • D6.php
  • F4.php
  • H4.php
  • I1.php
  • I1_1.php
  • I1_2.php
  • chahidachamlal_v5.txt
  • db.php
  • index.php
• x103
  • A4.php
  • I1_1.php
  • I1_2.php
  • I2_1.php
  • J2_1.php
  • J2_2.php
  • K3_1.php
  • L2_1.php
  • L2_2.php
  • M1_1.php
  • M1_2.php
  • MaxBoesBoxem_V5b.txt
  • db.php
  • index.php
• x104
  • A3.php
  • D1.php
  • DestanYildirim_VWO5.txt
  • E1.php
  • F1.php
  • H1.php
  • J1_1.php
  • J1_2.php
  • L1.php
  • db.php
  • index.php
• x105
  • .vscode
    • db.php
  • A4.php
  • B1.php
  • C2.php
  • CamielvanVliet_vwo5.txt
  • F1.php
  • H3.php
  • I1_1.php
  • I1_2.php
  • db.php
  • index.php
• x106
  • .vscode
  • A1.php
  • A3.php
  • B1.php
  • C1.php
  • D2.php
  • E1.php
  • F.php
  • F1.php
  • G1.php
  • H2.php
  • H3.php
  • K1.php
  • M.php
  • WoutvanLuijn_vwo5.txt
  • db.php
  • i1.php
  • index.php
• x107
  • A4.php
  • B1.php
  • C1.php
  • D2.php
  • E1.php
  • F.php
  • F2.php
  • G1.php
  • PascalPieters_VWO.txt
  • db.php
  • index.php
• x108
  • .vscode
    • B1_X108.php
    • B6_X108.php
  • Python Bestanden
    • .ipynb_checkpoints
  • A1.php
  • B2.php
  • C2.php
  • D2.php
  • E2.php
  • F4.php
  • G1.php
  • H4.php
  • I2_1.php
  • I2_2.php
  • J1.php
  • K3.php
  • db.php
  • index.php
  • pepijnbookelaar_V5.txt
• x109
  • .vscode
  • A3.php
  • B1.php
  • C2.php
  • D1.php
  • F2.php
  • H2.php
  • antoinesie_v5.txt
  • db.php
  • index.php
• x110
  • A4.php
  • B1.php
  • C1.php
  • D2.php
  • E1.php
  • F1.php
  • F2.php
  • H2.php
  • MerlijnEggink_v5.txt
  • db.php
  • index.php
• x111
  • .vscode
  • Python Bestanden
    • .ipynb_checkpoints
      • namen-checkpoint.txt
  • A4.php
  • B2.php
  • C2.php
  • D2.php
  • E2.php
  • F3.php
  • H2.php
  • db.php
  • index.php
  • okkeloman_V5.txt
• x112
  • .vscode
  • A4.php
  • B1.php
  • C2.php
  • D2.php
  • E1.php
  • F1.php
  • G1.php
  • H2.php
  • I1_1.php
  • I1_2.php
  • J2.php
  • OtKrewinkel_V5.txt
  • db.php
  • index.php
• x113
  • A3.php
  • B2.php
  • C2.php
  • D2.php
  • E1.php
  • F2.php
  • H4.php
  • I1.php
  • J1.php
  • L1.php
  • index.php
  • syb.txt
• x114
  • index.php
• x115
  • A1.php
  • B2.php
  • C2.php
  • D2.php
  • E2.php
  • J1.php
  • db.php
  • index.php
• 100
• 123456
  • .vscode
  • H5 2425
    • H6.php
    • les1.php
    • les1b.php
  • V5 2425
    • les1.php
  • ajax
  • db.php
  • footer.html
  • index.php
  • js.html
  • les.php
• index.php
• wf.php

javascriptcursus/php/geshi/geshi/tsql.php

Hide
<?php
/*************************************************************************************
 * tsql.php
 * --------
 * Author: Duncan Lock (dunc@dflock.co.uk)
 * Copyright: (c) 2006 Duncan Lock (http://dflock.co.uk/), Nigel McNie (http://qbnz.com/highlighter)
 * Release Version: 1.0.8.10
 * Date Started: 2005/11/22
 *
 * T-SQL language file for GeSHi.
 *
 * CHANGES
 * -------
 * 2004/01/23 (1.0.0)
 *  -  First Release
 *
 * TODO (updated 2006/01/23)
 * -------------------------
 *
 *************************************************************************************
 *
 *     This file is part of GeSHi.
 *
 *   GeSHi is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 *   GeSHi is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU General Public License for more details.
 *
 *   You should have received a copy of the GNU General Public License
 *   along with GeSHi; if not, write to the Free Software
 *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 *
 ************************************************************************************/

$language_data = array (
    'LANG_NAME' => 'T-SQL',
    'COMMENT_SINGLE' => array(1 => '--'),
    'COMMENT_MULTI' => array('/*' => '*/'),
    'CASE_KEYWORDS' => GESHI_CAPS_NO_CHANGE,
    'QUOTEMARKS' => array("'", '"'),
    'ESCAPE_CHAR' => '',
    'KEYWORDS' => array(
        1 => array(
            // Datatypes
            'bigint', 'tinyint', 'money',
            'smallmoney', 'datetime', 'smalldatetime',
            'text', 'nvarchar', 'ntext', 'varbinary', 'image',
            'sql_variant', 'uniqueidentifier',

            // Keywords
            'ABSOLUTE', 'ACTION', 'ADD', 'ADMIN', 'AFTER', 'AGGREGATE', 'ALIAS', 'ALLOCATE', 'ALTER', 'ARE', 'ARRAY', 'AS',
            'ASC', 'ASSERTION', 'AT', 'AUTHORIZATION', 'BACKUP', 'BEFORE', 'BEGIN', 'BINARY', 'BIT', 'BLOB', 'BOOLEAN', 'BOTH', 'BREADTH',
            'BREAK', 'BROWSE', 'BULK', 'BY', 'CALL', 'CASCADE', 'CASCADED', 'CASE', 'CAST', 'CATALOG', 'CHAR', 'CHARACTER', 'CHECK', 'CHECKPOINT',
            'CLASS', 'CLOB', 'CLOSE', 'CLUSTERED', 'COALESCE', 'COLLATE', 'COLLATION', 'COLUMN', 'COMMIT', 'COMPLETION', 'COMPUTE', 'CONNECT',
            'CONNECTION', 'CONSTRAINT', 'CONSTRAINTS', 'CONSTRUCTOR', 'CONTAINS', 'CONTAINSTABLE', 'CONTINUE', 'CONVERT', 'CORRESPONDING', 'CREATE',
            'CUBE', 'CURRENT', 'CURRENT_DATE', 'CURRENT_PATH', 'CURRENT_ROLE', 'CURRENT_TIME', 'CURRENT_TIMESTAMP', 'CURRENT_USER',
            'CURSOR', 'CYCLE', 'DATA', 'DATABASE', 'DATE', 'DAY', 'DBCC', 'DEALLOCATE', 'DEC', 'DECIMAL', 'DECLARE', 'DEFAULT', 'DEFERRABLE',
            'DEFERRED', 'DELETE', 'DENY', 'DEPTH', 'DEREF', 'DESC', 'DESCRIBE', 'DESCRIPTOR', 'DESTROY', 'DESTRUCTOR', 'DETERMINISTIC',
            'DIAGNOSTICS', 'DICTIONARY', 'DISCONNECT', 'DISK', 'DISTINCT', 'DISTRIBUTED', 'DOMAIN', 'DOUBLE', 'DROP', 'DUMMY', 'DUMP', 'DYNAMIC',
            'EACH', 'ELSE', 'END', 'END-EXEC', 'EQUALS', 'ERRLVL', 'ESCAPE', 'EVERY', 'EXCEPT', 'EXCEPTION', 'EXEC', 'EXECUTE', 'EXIT',
            'EXTERNAL', 'FALSE', 'FETCH', 'FILE', 'FILLFACTOR', 'FIRST', 'FLOAT', 'FOR', 'FOREIGN', 'FOUND', 'FREE', 'FREETEXT', 'FREETEXTTABLE',
            'FROM', 'FULL', 'FUNCTION', 'GENERAL', 'GET', 'GLOBAL', 'GOTO', 'GRANT', 'GROUP', 'GROUPING', 'HAVING', 'HOLDLOCK', 'HOST', 'HOUR',
            'IDENTITY', 'IDENTITY_INSERT', 'IDENTITYCOL', 'IF', 'IGNORE', 'IMMEDIATE', 'INDEX', 'INDICATOR', 'INITIALIZE', 'INITIALLY',
            'INNER', 'INOUT', 'INPUT', 'INSERT', 'INT', 'INTEGER', 'INTERSECT', 'INTERVAL', 'INTO', 'IS', 'ISOLATION', 'ITERATE', 'KEY',
            'KILL', 'LANGUAGE', 'LARGE', 'LAST', 'LATERAL', 'LEADING', 'LEFT', 'LESS', 'LEVEL', 'LIMIT', 'LINENO', 'LOAD', 'LOCAL',
            'LOCALTIME', 'LOCALTIMESTAMP', 'LOCATOR', 'MAP', 'MATCH', 'MINUTE', 'MODIFIES', 'MODIFY', 'MODULE', 'MONTH', 'NAMES', 'NATIONAL',
            'NATURAL', 'NCHAR', 'NCLOB', 'NEW', 'NEXT', 'NO', 'NOCHECK', 'NONCLUSTERED', 'NONE', 'NULLIF', 'NUMERIC', 'OBJECT', 'OF',
            'OFF', 'OFFSETS', 'OLD', 'ON', 'ONLY', 'OPEN', 'OPENDATASOURCE', 'OPENQUERY', 'OPENROWSET', 'OPENXML', 'OPERATION', 'OPTION',
            'ORDER', 'ORDINALITY', 'OUT', 'OUTPUT', 'OVER', 'PAD', 'PARAMETER', 'PARAMETERS', 'PARTIAL', 'PATH', 'PERCENT', 'PLAN',
            'POSTFIX', 'PRECISION', 'PREFIX', 'PREORDER', 'PREPARE', 'PRESERVE', 'PRIMARY', 'PRINT', 'PRIOR', 'PRIVILEGES', 'PROC', 'PROCEDURE',
            'PUBLIC', 'RAISERROR', 'READ', 'READS', 'READTEXT', 'REAL', 'RECONFIGURE', 'RECURSIVE', 'REF', 'REFERENCES', 'REFERENCING', 'RELATIVE',
            'REPLICATION', 'RESTORE', 'RESTRICT', 'RESULT', 'RETURN', 'RETURNS', 'REVOKE', 'RIGHT', 'ROLE', 'ROLLBACK', 'ROLLUP', 'ROUTINE', 'ROW',
            'ROWGUIDCOL', 'ROWS', 'RULE', 'SAVE', 'SAVEPOINT', 'SCHEMA', 'SCOPE', 'SCROLL', 'SEARCH', 'SECOND', 'SECTION', 'SELECT',
            'SEQUENCE', 'SESSION', 'SESSION_USER', 'SET', 'SETS', 'SETUSER', 'SHUTDOWN', 'SIZE', 'SMALLINT', 'SPACE', 'SPECIFIC',
            'SPECIFICTYPE', 'SQL', 'SQLEXCEPTION', 'SQLSTATE', 'SQLWARNING', 'START', 'STATE', 'STATEMENT', 'STATIC', 'STATISTICS', 'STRUCTURE',
            'SYSTEM_USER', 'TABLE', 'TEMPORARY', 'TERMINATE', 'TEXTSIZE', 'THAN', 'THEN', 'TIME', 'TIMESTAMP', 'TIMEZONE_HOUR', 'TIMEZONE_MINUTE',
            'TO', 'TOP', 'TRAILING', 'TRAN', 'TRANSACTION', 'TRANSLATION', 'TREAT', 'TRIGGER', 'TRUE', 'TRUNCATE', 'TSEQUAL', 'UNDER', 'UNION',
            'UNIQUE', 'UNKNOWN', 'UNNEST', 'UPDATE', 'UPDATETEXT', 'USAGE', 'USE', 'USER', 'USING', 'VALUE', 'VALUES', 'VARCHAR', 'VARIABLE',
            'VARYING', 'VIEW', 'WAITFOR', 'WHEN', 'WHENEVER', 'WHERE', 'WHILE', 'WITH', 'WITHOUT', 'WORK', 'WRITE', 'WRITETEXT', 'YEAR', 'ZONE',
            'UNCOMMITTED', 'NOCOUNT',
            ),
        2 => array(
            /*
                Built-in functions
                Highlighted in pink.
            */

            //Configuration Functions
            '@@DATEFIRST','@@OPTIONS','@@DBTS','@@REMSERVER','@@LANGID','@@SERVERNAME',
            '@@LANGUAGE','@@SERVICENAME','@@LOCK_TIMEOUT','@@SPID','@@MAX_CONNECTIONS',
            '@@TEXTSIZE','@@MAX_PRECISION','@@VERSION','@@NESTLEVEL',

            //Cursor Functions
            '@@CURSOR_ROWS','@@FETCH_STATUS',

            //Date and Time Functions
            'DATEADD','DATEDIFF','DATENAME','DATEPART','GETDATE','GETUTCDATE',

            //Mathematical Functions
            'ABS','DEGREES','RAND','ACOS','EXP','ROUND','ASIN','FLOOR','SIGN',
            'ATAN','LOG','SIN','ATN2','LOG10','SQUARE','CEILING','PI','SQRT','COS',
            'POWER','TAN','COT','RADIANS',

            //Meta Data Functions
            'COL_LENGTH','COL_NAME','FULLTEXTCATALOGPROPERTY',
            'COLUMNPROPERTY','FULLTEXTSERVICEPROPERTY','DATABASEPROPERTY','INDEX_COL',
            'DATABASEPROPERTYEX','INDEXKEY_PROPERTY','DB_ID','INDEXPROPERTY','DB_NAME',
            'OBJECT_ID','FILE_ID','OBJECT_NAME','FILE_NAME','OBJECTPROPERTY','FILEGROUP_ID',
            '@@PROCID','FILEGROUP_NAME','SQL_VARIANT_PROPERTY','FILEGROUPPROPERTY',
            'TYPEPROPERTY','FILEPROPERTY',

            //Security Functions
            'IS_SRVROLEMEMBER','SUSER_SID','SUSER_SNAME','USER_ID',
            'HAS_DBACCESS','IS_MEMBER',

            //String Functions
            'ASCII','SOUNDEX','PATINDEX','CHARINDEX','REPLACE','STR',
            'DIFFERENCE','QUOTENAME','STUFF','REPLICATE','SUBSTRING','LEN',
            'REVERSE','UNICODE','LOWER','UPPER','LTRIM','RTRIM',

            //System Functions
            'APP_NAME','COLLATIONPROPERTY','@@ERROR','FORMATMESSAGE',
            'GETANSINULL','HOST_ID','HOST_NAME','IDENT_CURRENT','IDENT_INCR',
            'IDENT_SEED','@@IDENTITY','ISDATE','ISNUMERIC','PARSENAME','PERMISSIONS',
            '@@ROWCOUNT','ROWCOUNT_BIG','SCOPE_IDENTITY','SERVERPROPERTY','SESSIONPROPERTY',
            'STATS_DATE','@@TRANCOUNT','USER_NAME',

            //System Statistical Functions
            '@@CONNECTIONS','@@PACK_RECEIVED','@@CPU_BUSY','@@PACK_SENT',
            '@@TIMETICKS','@@IDLE','@@TOTAL_ERRORS','@@IO_BUSY',
            '@@TOTAL_READ','@@PACKET_ERRORS','@@TOTAL_WRITE',

            //Text and Image Functions
            'TEXTPTR','TEXTVALID',

            //Aggregate functions
            'AVG', 'MAX', 'BINARY_CHECKSUM', 'MIN', 'CHECKSUM', 'SUM', 'CHECKSUM_AGG',
            'STDEV', 'COUNT', 'STDEVP', 'COUNT_BIG', 'VAR', 'VARP'
            ),
        3 => array(
            /*
                System stored procedures
                Higlighted dark brown
            */

            //Active Directory Procedures
            'sp_ActiveDirectory_Obj', 'sp_ActiveDirectory_SCP',

            //Catalog Procedures
            'sp_column_privileges', 'sp_special_columns', 'sp_columns', 'sp_sproc_columns',
            'sp_databases', 'sp_statistics', 'sp_fkeys', 'sp_stored_procedures', 'sp_pkeys',
            'sp_table_privileges', 'sp_server_info', 'sp_tables',

            //Cursor Procedures
            'sp_cursor_list', 'sp_describe_cursor_columns', 'sp_describe_cursor', 'sp_describe_cursor_tables',

            //Database Maintenance Plan Procedures
            'sp_add_maintenance_plan', 'sp_delete_maintenance_plan_db', 'sp_add_maintenance_plan_db',
            'sp_delete_maintenance_plan_job', 'sp_add_maintenance_plan_job', 'sp_help_maintenance_plan',
            'sp_delete_maintenance_plan',

            //Distributed Queries Procedures
            'sp_addlinkedserver', 'sp_indexes', 'sp_addlinkedsrvlogin', 'sp_linkedservers', 'sp_catalogs',
            'sp_primarykeys', 'sp_column_privileges_ex', 'sp_columns_ex',
            'sp_table_privileges_ex', 'sp_tables_ex', 'sp_foreignkeys',

            //Full-Text Search Procedures
            'sp_fulltext_catalog', 'sp_help_fulltext_catalogs_cursor', 'sp_fulltext_column',
            'sp_help_fulltext_columns', 'sp_fulltext_database', 'sp_help_fulltext_columns_cursor',
            'sp_fulltext_service', 'sp_help_fulltext_tables', 'sp_fulltext_table',
            'sp_help_fulltext_tables_cursor', 'sp_help_fulltext_catalogs',

            //Log Shipping Procedures
            'sp_add_log_shipping_database', 'sp_delete_log_shipping_database', 'sp_add_log_shipping_plan',
            'sp_delete_log_shipping_plan', 'sp_add_log_shipping_plan_database',
            'sp_delete_log_shipping_plan_database', 'sp_add_log_shipping_primary',
            'sp_delete_log_shipping_primary', 'sp_add_log_shipping_secondary',
            'sp_delete_log_shipping_secondary', 'sp_can_tlog_be_applied', 'sp_get_log_shipping_monitor_info',
            'sp_change_monitor_role', 'sp_remove_log_shipping_monitor', 'sp_change_primary_role',
            'sp_resolve_logins', 'sp_change_secondary_role', 'sp_update_log_shipping_monitor_info',
            'sp_create_log_shipping_monitor_account', 'sp_update_log_shipping_plan',
            'sp_define_log_shipping_monitor', 'sp_update_log_shipping_plan_database',

            //OLE Automation Extended Stored Procedures
            'sp_OACreate', 'sp_OAMethod', 'sp_OADestroy', 'sp_OASetProperty', 'sp_OAGetErrorInfo',
            'sp_OAStop', 'sp_OAGetProperty',

            //Replication Procedures
            'sp_add_agent_parameter', 'sp_enableagentoffload', 'sp_add_agent_profile',
            'sp_enumcustomresolvers', 'sp_addarticle', 'sp_enumdsn', 'sp_adddistpublisher',
            'sp_enumfullsubscribers', 'sp_adddistributiondb', 'sp_expired_subscription_cleanup',
            'sp_adddistributor', 'sp_generatefilters', 'sp_addmergealternatepublisher',
            'sp_getagentoffloadinfo', 'sp_addmergearticle', 'sp_getmergedeletetype', 'sp_addmergefilter',
            'sp_get_distributor', 'sp_addmergepublication', 'sp_getqueuedrows', 'sp_addmergepullsubscription',
            'sp_getsubscriptiondtspackagename', 'sp_addmergepullsubscription_agent', 'sp_grant_publication_access',
            'sp_addmergesubscription', 'sp_help_agent_default', 'sp_addpublication', 'sp_help_agent_parameter',
            'sp_addpublication_snapshot', 'sp_help_agent_profile', 'sp_addpublisher70', 'sp_helparticle',
            'sp_addpullsubscription', 'sp_helparticlecolumns', 'sp_addpullsubscription_agent', 'sp_helparticledts',
            'sp_addscriptexec', 'sp_helpdistpublisher', 'sp_addsubscriber', 'sp_helpdistributiondb',
            'sp_addsubscriber_schedule', 'sp_helpdistributor', 'sp_addsubscription', 'sp_helpmergealternatepublisher',
            'sp_addsynctriggers', 'sp_helpmergearticle', 'sp_addtabletocontents', 'sp_helpmergearticlecolumn',
            'sp_adjustpublisheridentityrange', 'sp_helpmergearticleconflicts', 'sp_article_validation',
            'sp_helpmergeconflictrows', 'sp_articlecolumn', 'sp_helpmergedeleteconflictrows', 'sp_articlefilter',
            'sp_helpmergefilter', 'sp_articlesynctranprocs', 'sp_helpmergepublication', 'sp_articleview',
            'sp_helpmergepullsubscription', 'sp_attachsubscription', 'sp_helpmergesubscription', 'sp_browsesnapshotfolder',
            'sp_helppublication', 'sp_browsemergesnapshotfolder', 'sp_help_publication_access', 'sp_browsereplcmds',
            'sp_helppullsubscription', 'sp_change_agent_parameter', 'sp_helpreplfailovermode', 'sp_change_agent_profile',
            'sp_helpreplicationdboption', 'sp_changearticle', 'sp_helpreplicationoption', 'sp_changedistpublisher',
            'sp_helpsubscriberinfo', 'sp_changedistributiondb', 'sp_helpsubscription', 'sp_changedistributor_password',
            'sp_ivindexhasnullcols', 'sp_changedistributor_property', 'sp_helpsubscription_properties', 'sp_changemergearticle',
            'sp_link_publication', 'sp_changemergefilter', 'sp_marksubscriptionvalidation', 'sp_changemergepublication',
            'sp_mergearticlecolumn', 'sp_changemergepullsubscription', 'sp_mergecleanupmetadata', 'sp_changemergesubscription',
            'sp_mergedummyupdate', 'sp_changepublication', 'sp_mergesubscription_cleanup', 'sp_changesubscriber',
            'sp_publication_validation', 'sp_changesubscriber_schedule', 'sp_refreshsubscriptions', 'sp_changesubscriptiondtsinfo',
            'sp_reinitmergepullsubscription', 'sp_changesubstatus', 'sp_reinitmergesubscription', 'sp_change_subscription_properties',
            'sp_reinitpullsubscription', 'sp_check_for_sync_trigger', 'sp_reinitsubscription', 'sp_copymergesnapshot',
            'sp_removedbreplication', 'sp_copysnapshot', 'sp_repladdcolumn', 'sp_copysubscription', 'sp_replcmds',
            'sp_deletemergeconflictrow', 'sp_replcounters', 'sp_disableagentoffload', 'sp_repldone', 'sp_drop_agent_parameter',
            'sp_repldropcolumn', 'sp_drop_agent_profile', 'sp_replflush', 'sp_droparticle', 'sp_replicationdboption',
            'sp_dropanonymouseagent', 'sp_replication_agent_checkup', 'sp_dropdistpublisher', 'sp_replqueuemonitor',
            'sp_dropdistributiondb', 'sp_replsetoriginator', 'sp_dropmergealternatepublisher', 'sp_replshowcmds',
            'sp_dropdistributor', 'sp_repltrans', 'sp_dropmergearticle', 'sp_restoredbreplication', 'sp_dropmergefilter',
            'sp_revoke_publication_access', 'sp_scriptsubconflicttable', 'sp_dropmergepublication', 'sp_script_synctran_commands',
            'sp_dropmergepullsubscription', 'sp_setreplfailovermode', 'sp_showrowreplicainfo', 'sp_dropmergesubscription',
            'sp_subscription_cleanup', 'sp_droppublication', 'sp_table_validation', 'sp_droppullsubscription',
            'sp_update_agent_profile', 'sp_dropsubscriber', 'sp_validatemergepublication', 'sp_dropsubscription',
            'sp_validatemergesubscription', 'sp_dsninfo', 'sp_vupgrade_replication', 'sp_dumpparamcmd',

            //Security Procedures
            'sp_addalias', 'sp_droprolemember', 'sp_addapprole', 'sp_dropserver', 'sp_addgroup', 'sp_dropsrvrolemember',
            'sp_dropuser', 'sp_addlogin', 'sp_grantdbaccess', 'sp_addremotelogin',
            'sp_grantlogin', 'sp_addrole', 'sp_helpdbfixedrole', 'sp_addrolemember', 'sp_helpgroup',
            'sp_addserver', 'sp_helplinkedsrvlogin', 'sp_addsrvrolemember', 'sp_helplogins', 'sp_adduser',
            'sp_helpntgroup', 'sp_approlepassword', 'sp_helpremotelogin', 'sp_changedbowner', 'sp_helprole',
            'sp_changegroup', 'sp_helprolemember', 'sp_changeobjectowner', 'sp_helprotect', 'sp_change_users_login',
            'sp_helpsrvrole', 'sp_dbfixedrolepermission', 'sp_helpsrvrolemember', 'sp_defaultdb', 'sp_helpuser',
            'sp_defaultlanguage', 'sp_MShasdbaccess', 'sp_denylogin', 'sp_password', 'sp_dropalias', 'sp_remoteoption',
            'sp_dropapprole', 'sp_revokedbaccess', 'sp_dropgroup', 'sp_revokelogin', 'sp_droplinkedsrvlogin',
            'sp_setapprole', 'sp_droplogin', 'sp_srvrolepermission', 'sp_dropremotelogin', 'sp_validatelogins', 'sp_droprole',

            //SQL Mail Procedures
            'sp_processmail', 'xp_sendmail', 'xp_deletemail', 'xp_startmail', 'xp_findnextmsg', 'xp_stopmail', 'xp_readmail',

            //SQL Profiler Procedures
            'sp_trace_create', 'sp_trace_setfilter', 'sp_trace_generateevent', 'sp_trace_setstatus', 'sp_trace_setevent',

            //SQL Server Agent Procedures
            'sp_add_alert', 'sp_help_jobhistory', 'sp_add_category', 'sp_help_jobschedule', 'sp_add_job',
            'sp_help_jobserver', 'sp_add_jobschedule', 'sp_help_jobstep', 'sp_add_jobserver', 'sp_help_notification',
            'sp_add_jobstep', 'sp_help_operator', 'sp_add_notification', 'sp_help_targetserver',
            'sp_add_operator', 'sp_help_targetservergroup', 'sp_add_targetservergroup', 'sp_helptask',
            'sp_add_targetsvrgrp_member', 'sp_manage_jobs_by_login', 'sp_addtask', 'sp_msx_defect',
            'sp_apply_job_to_targets', 'sp_msx_enlist', 'sp_delete_alert', 'sp_post_msx_operation',
            'sp_delete_category', 'sp_purgehistory', 'sp_delete_job', 'sp_purge_jobhistory', 'sp_delete_jobschedule',
            'sp_reassigntask', 'sp_delete_jobserver', 'sp_remove_job_from_targets', 'sp_delete_jobstep',
            'sp_resync_targetserver', 'sp_delete_notification', 'sp_start_job', 'sp_delete_operator',
            'sp_stop_job', 'sp_delete_targetserver', 'sp_update_alert', 'sp_delete_targetservergroup',
            'sp_update_category', 'sp_delete_targetsvrgrp_member', 'sp_update_job', 'sp_droptask',
            'sp_update_jobschedule', 'sp_help_alert', 'sp_update_jobstep', 'sp_help_category',
            'sp_update_notification', 'sp_help_downloadlist', 'sp_update_operator', 'sp_helphistory',
            'sp_update_targetservergroup', 'sp_help_job', 'sp_updatetask', 'xp_sqlagent_proxy_account',

            //System Procedures
            'sp_add_data_file_recover_suspect_db', 'sp_helpconstraint', 'sp_addextendedproc',
            'sp_helpdb', 'sp_addextendedproperty', 'sp_helpdevice', 'sp_add_log_file_recover_suspect_db',
            'sp_helpextendedproc', 'sp_addmessage', 'sp_helpfile', 'sp_addtype', 'sp_helpfilegroup',
            'sp_addumpdevice', 'sp_helpindex', 'sp_altermessage', 'sp_helplanguage', 'sp_autostats',
            'sp_helpserver', 'sp_attach_db', 'sp_helpsort', 'sp_attach_single_file_db', 'sp_helpstats',
            'sp_bindefault', 'sp_helptext', 'sp_bindrule', 'sp_helptrigger', 'sp_bindsession',
            'sp_indexoption', 'sp_certify_removable', 'sp_invalidate_textptr', 'sp_configure',
            'sp_lock', 'sp_create_removable', 'sp_monitor', 'sp_createstats', 'sp_procoption',
            'sp_cycle_errorlog', 'sp_recompile', 'sp_datatype_info', 'sp_refreshview', 'sp_dbcmptlevel',
            'sp_releaseapplock', 'sp_dboption', 'sp_rename', 'sp_dbremove', 'sp_renamedb',
            'sp_delete_backuphistory', 'sp_resetstatus', 'sp_depends', 'sp_serveroption', 'sp_detach_db',
            'sp_setnetname', 'sp_dropdevice', 'sp_settriggerorder', 'sp_dropextendedproc', 'sp_spaceused',
            'sp_dropextendedproperty', 'sp_tableoption', 'sp_dropmessage', 'sp_unbindefault', 'sp_droptype',
            'sp_unbindrule', 'sp_executesql', 'sp_updateextendedproperty', 'sp_getapplock', 'sp_updatestats',
            'sp_getbindtoken', 'sp_validname', 'sp_help', 'sp_who',

            //Web Assistant Procedures
            'sp_dropwebtask', 'sp_makewebtask', 'sp_enumcodepages', 'sp_runwebtask',

            //XML Procedures
            'sp_xml_preparedocument', 'sp_xml_removedocument',

            //General Extended Procedures
            'xp_cmdshellxp_logininfo', 'xp_enumgroups', 'xp_msver', 'xp_findnextmsgxp_revokelogin',
            'xp_grantlogin', 'xp_sprintf', 'xp_logevent', 'xp_sqlmaint', 'xp_loginconfig', 'xp_sscanf',

            //API System Stored Procedures
            'sp_cursor', 'sp_cursorclose', 'sp_cursorexecute', 'sp_cursorfetch', 'sp_cursoropen',
            'sp_cursoroption', 'sp_cursorprepare', 'sp_cursorunprepare', 'sp_execute', 'sp_prepare', 'sp_unprepare',

            //Misc
            'sp_createorphan', 'sp_droporphans', 'sp_reset_connection', 'sp_sdidebug'
            ),
        4 => array(
            //Function/sp's higlighted brown.
            'fn_helpcollations', 'fn_listextendedproperty ', 'fn_servershareddrives',
            'fn_trace_geteventinfo', 'fn_trace_getfilterinfo', 'fn_trace_getinfo',
            'fn_trace_gettable', 'fn_virtualfilestats','fn_listextendedproperty',
            ),
        ),
    'SYMBOLS' => array(
        '!', '!=', '%', '&', '&&', '(', ')', '*', '+', '-', '/', '<', '<<', '<=',
        '<=>', '<>', '=', '>', '>=', '>>', '^', 'ALL', 'AND', 'ANY', 'BETWEEN', 'CROSS',
        'EXISTS', 'IN', 'JOIN', 'LIKE', 'NOT', 'NULL', 'OR', 'OUTER', 'SOME', '|', '||', '~'
        ),
    'CASE_SENSITIVE' => array(
        GESHI_COMMENTS => false,
        1 => false,
        2 => false,
        3 => false,
        4 => false,
        ),
    'STYLES' => array(
        'KEYWORDS' => array(
            1 => 'color: #0000FF;',
            2 => 'color: #FF00FF;',
            3 => 'color: #AF0000;',
            4 => 'color: #AF0000;'
            ),
        'COMMENTS' => array(
            1 => 'color: #008080;',
            'MULTI' => 'color: #008080;'
            ),
        'ESCAPE_CHAR' => array(
            0 => 'color: #000099; font-weight: bold;'
            ),
        'BRACKETS' => array(
            0 => 'color: #808080;'
            ),
        'STRINGS' => array(
            0 => 'color: #FF0000;'
            ),
        'NUMBERS' => array(
            0 => 'color: #000;'
            ),
        'METHODS' => array(
            1 => 'color: #202020;',
            2 => 'color: #202020;'
            ),
        'SYMBOLS' => array(
            0 => 'color: #808080;'
            ),
        'REGEXPS' => array(
            ),
        'SCRIPT' => array(
            )
        ),
    'URLS' => array(
        1 => '',
        2 => '',
        3 => '',
        4 => ''
        ),
    'OOLANG' => true,
    'OBJECT_SPLITTERS' => array(
        1 => '.'
        ),
    'REGEXPS' => array(
        ),
    'STRICT_MODE_APPLIES' => GESHI_NEVER,
    'SCRIPT_DELIMITERS' => array(
        ),
    'HIGHLIGHT_STRICT_BLOCK' => array(
        )
);

?>

Resultaat