ILIAS  release_5-2 Revision v5.2.25-18-g3f80b828510
tsql.php
Go to the documentation of this file.
1 <?php
2 /*************************************************************************************
3  * tsql.php
4  * --------
5  * Author: Duncan Lock (dunc@dflock.co.uk)
6  * Copyright: (c) 2006 Duncan Lock (http://dflock.co.uk/), Nigel McNie (http://qbnz.com/highlighter)
7  * Release Version: 1.0.8.12
8  * Date Started: 2005/11/22
9  *
10  * T-SQL language file for GeSHi.
11  *
12  * CHANGES
13  * -------
14  * 2004/01/23 (1.0.0)
15  * - First Release
16  *
17  * TODO (updated 2006/01/23)
18  * -------------------------
19  *
20  *************************************************************************************
21  *
22  * This file is part of GeSHi.
23  *
24  * GeSHi is free software; you can redistribute it and/or modify
25  * it under the terms of the GNU General Public License as published by
26  * the Free Software Foundation; either version 2 of the License, or
27  * (at your option) any later version.
28  *
29  * GeSHi is distributed in the hope that it will be useful,
30  * but WITHOUT ANY WARRANTY; without even the implied warranty of
31  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
32  * GNU General Public License for more details.
33  *
34  * You should have received a copy of the GNU General Public License
35  * along with GeSHi; if not, write to the Free Software
36  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
37  *
38  ************************************************************************************/
39 
40 $language_data = array (
41  'LANG_NAME' => 'T-SQL',
42  'COMMENT_SINGLE' => array(1 => '--'),
43  'COMMENT_MULTI' => array('/*' => '*/'),
44  'CASE_KEYWORDS' => GESHI_CAPS_NO_CHANGE,
45  'QUOTEMARKS' => array("'", '"'),
46  'ESCAPE_CHAR' => '',
47  'KEYWORDS' => array(
48  1 => array(
49  // Datatypes
50  'bigint', 'tinyint', 'money',
51  'smallmoney', 'datetime', 'smalldatetime',
52  'text', 'nvarchar', 'ntext', 'varbinary', 'image',
53  'sql_variant', 'uniqueidentifier',
54 
55  // Keywords
56  'ABSOLUTE', 'ACTION', 'ADD', 'ADMIN', 'AFTER', 'AGGREGATE', 'ALIAS', 'ALLOCATE', 'ALTER', 'ARE', 'ARRAY', 'AS',
57  'ASC', 'ASSERTION', 'AT', 'AUTHORIZATION', 'BACKUP', 'BEFORE', 'BEGIN', 'BINARY', 'BIT', 'BLOB', 'BOOLEAN', 'BOTH', 'BREADTH',
58  'BREAK', 'BROWSE', 'BULK', 'BY', 'CALL', 'CASCADE', 'CASCADED', 'CASE', 'CAST', 'CATALOG', 'CATCH', 'CHAR', 'CHARACTER', 'CHECK', 'CHECKPOINT',
59  'CLASS', 'CLOB', 'CLOSE', 'CLUSTERED', 'COALESCE', 'COLLATE', 'COLLATION', 'COLUMN', 'COMMIT', 'COMPLETION', 'COMPUTE', 'CONNECT',
60  'CONNECTION', 'CONSTRAINT', 'CONSTRAINTS', 'CONSTRUCTOR', 'CONTAINS', 'CONTAINSTABLE', 'CONTINUE', 'CONVERT', 'CORRESPONDING', 'CREATE',
61  'CUBE', 'CURRENT', 'CURRENT_DATE', 'CURRENT_PATH', 'CURRENT_ROLE', 'CURRENT_TIME', 'CURRENT_TIMESTAMP', 'CURRENT_USER',
62  'CURSOR', 'CYCLE', 'DATA', 'DATABASE', 'DATE', 'DAY', 'DBCC', 'DEALLOCATE', 'DEC', 'DECIMAL', 'DECLARE', 'DEFAULT', 'DEFERRABLE',
63  'DEFERRED', 'DELETE', 'DENY', 'DEPTH', 'DEREF', 'DESC', 'DESCRIBE', 'DESCRIPTOR', 'DESTROY', 'DESTRUCTOR', 'DETERMINISTIC',
64  'DIAGNOSTICS', 'DICTIONARY', 'DISCONNECT', 'DISK', 'DISTINCT', 'DISTRIBUTED', 'DOMAIN', 'DOUBLE', 'DROP', 'DUMMY', 'DUMP', 'DYNAMIC',
65  'EACH', 'ELSE', 'END', 'END-EXEC', 'EQUALS', 'ERRLVL', 'ESCAPE', 'EVERY', 'EXCEPT', 'EXCEPTION', 'EXEC', 'EXECUTE', 'EXIT',
66  'EXTERNAL', 'FALSE', 'FETCH', 'FILE', 'FILLFACTOR', 'FIRST', 'FLOAT', 'FOR', 'FOREIGN', 'FOUND', 'FREE', 'FREETEXT', 'FREETEXTTABLE',
67  'FROM', 'FULL', 'FUNCTION', 'GENERAL', 'GET', 'GLOBAL', 'GOTO', 'GRANT', 'GROUP', 'GROUPING', 'HAVING', 'HOLDLOCK', 'HOST', 'HOUR',
68  'IDENTITY', 'IDENTITY_INSERT', 'IDENTITYCOL', 'IF', 'IGNORE', 'IMMEDIATE', 'INDEX', 'INDICATOR', 'INITIALIZE', 'INITIALLY',
69  'INNER', 'INOUT', 'INPUT', 'INSERT', 'INT', 'INTEGER', 'INTERSECT', 'INTERVAL', 'INTO', 'IS', 'ISOLATION', 'ITERATE', 'KEY',
70  'KILL', 'LANGUAGE', 'LARGE', 'LAST', 'LATERAL', 'LEADING', 'LEFT', 'LESS', 'LEVEL', 'LIMIT', 'LINENO', 'LOAD', 'LOCAL',
71  'LOCALTIME', 'LOCALTIMESTAMP', 'LOCATOR', 'MAP', 'MATCH', 'MINUTE', 'MODIFIES', 'MODIFY', 'MODULE', 'MONTH', 'NAMES', 'NATIONAL',
72  'NATURAL', 'NCHAR', 'NCLOB', 'NEW', 'NEXT', 'NO', 'NOCHECK', 'NONCLUSTERED', 'NONE', 'NULLIF', 'NUMERIC', 'OBJECT', 'OF',
73  'OFF', 'OFFSETS', 'OLD', 'ON', 'ONLY', 'OPEN', 'OPENDATASOURCE', 'OPENQUERY', 'OPENROWSET', 'OPENXML', 'OPERATION', 'OPTION',
74  'ORDER', 'ORDINALITY', 'OUT', 'OUTPUT', 'OVER', 'PAD', 'PARAMETER', 'PARAMETERS', 'PARTIAL', 'PATH', 'PERCENT', 'PLAN',
75  'POSTFIX', 'PRECISION', 'PREFIX', 'PREORDER', 'PREPARE', 'PRESERVE', 'PRIMARY', 'PRINT', 'PRIOR', 'PRIVILEGES', 'PROC', 'PROCEDURE',
76  'PUBLIC', 'RAISERROR', 'READ', 'READS', 'READTEXT', 'REAL', 'RECONFIGURE', 'RECURSIVE', 'REF', 'REFERENCES', 'REFERENCING', 'RELATIVE',
77  'REPLICATION', 'RESTORE', 'RESTRICT', 'RESULT', 'RETURN', 'RETURNS', 'REVOKE', 'RIGHT', 'ROLE', 'ROLLBACK', 'ROLLUP', 'ROUTINE', 'ROW',
78  'ROWGUIDCOL', 'ROWS', 'RULE', 'SAVE', 'SAVEPOINT', 'SCHEMA', 'SCOPE', 'SCROLL', 'SEARCH', 'SECOND', 'SECTION', 'SELECT',
79  'SEQUENCE', 'SESSION', 'SESSION_USER', 'SET', 'SETS', 'SETUSER', 'SHUTDOWN', 'SIZE', 'SMALLINT', 'SPACE', 'SPECIFIC',
80  'SPECIFICTYPE', 'SQL', 'SQLEXCEPTION', 'SQLSTATE', 'SQLWARNING', 'START', 'STATE', 'STATEMENT', 'STATIC', 'STATISTICS', 'STRUCTURE',
81  'SYSTEM_USER', 'TABLE', 'TEMPORARY', 'TERMINATE', 'TEXTSIZE', 'THAN', 'THEN', 'TIME', 'TIMESTAMP', 'TIMEZONE_HOUR', 'TIMEZONE_MINUTE',
82  'TO', 'TOP', 'TRAILING', 'TRAN', 'TRANSACTION', 'TRANSLATION', 'TREAT', 'TRIGGER', 'TRUE', 'TRUNCATE', 'TRY', 'TSEQUAL', 'UNDER', 'UNION',
83  'UNIQUE', 'UNKNOWN', 'UNNEST', 'UPDATE', 'UPDATETEXT', 'USAGE', 'USE', 'USER', 'USING', 'VALUE', 'VALUES', 'VARCHAR', 'VARIABLE',
84  'VARYING', 'VIEW', 'WAITFOR', 'WHEN', 'WHENEVER', 'WHERE', 'WHILE', 'WITH', 'WITHOUT', 'WORK', 'WRITE', 'WRITETEXT', 'YEAR', 'ZONE',
85  'UNCOMMITTED', 'NOCOUNT',
86  ),
87  2 => array(
88  /*
89  Built-in functions
90  Highlighted in pink.
91  */
92 
93  //Configuration Functions
94  '@@DATEFIRST','@@OPTIONS','@@DBTS','@@REMSERVER','@@LANGID','@@SERVERNAME',
95  '@@LANGUAGE','@@SERVICENAME','@@LOCK_TIMEOUT','@@SPID','@@MAX_CONNECTIONS',
96  '@@TEXTSIZE','@@MAX_PRECISION','@@VERSION','@@NESTLEVEL',
97 
98  //Cursor Functions
99  '@@CURSOR_ROWS','@@FETCH_STATUS',
100 
101  //Date and Time Functions
102  'DATEADD','DATEDIFF','DATENAME','DATEPART','GETDATE','GETUTCDATE',
103 
104  //Mathematical Functions
105  'ABS','DEGREES','RAND','ACOS','EXP','ROUND','ASIN','FLOOR','SIGN',
106  'ATAN','LOG','SIN','ATN2','LOG10','SQUARE','CEILING','PI','SQRT','COS',
107  'POWER','TAN','COT','RADIANS',
108 
109  //Meta Data Functions
110  'COL_LENGTH','COL_NAME','FULLTEXTCATALOGPROPERTY',
111  'COLUMNPROPERTY','FULLTEXTSERVICEPROPERTY','DATABASEPROPERTY','INDEX_COL',
112  'DATABASEPROPERTYEX','INDEXKEY_PROPERTY','DB_ID','INDEXPROPERTY','DB_NAME',
113  'OBJECT_ID','FILE_ID','OBJECT_NAME','FILE_NAME','OBJECTPROPERTY','FILEGROUP_ID',
114  '@@PROCID','FILEGROUP_NAME','SQL_VARIANT_PROPERTY','FILEGROUPPROPERTY',
115  'TYPEPROPERTY','FILEPROPERTY',
116 
117  //Security Functions
118  'IS_SRVROLEMEMBER','SUSER_SID','SUSER_SNAME','USER_ID',
119  'HAS_DBACCESS','IS_MEMBER',
120 
121  //String Functions
122  'ASCII','SOUNDEX','PATINDEX','CHARINDEX','REPLACE','STR',
123  'DIFFERENCE','QUOTENAME','STUFF','REPLICATE','SUBSTRING','LEN',
124  'REVERSE','UNICODE','LOWER','UPPER','LTRIM','RTRIM',
125 
126  //System Functions
127  'APP_NAME','COLLATIONPROPERTY','@@ERROR','FORMATMESSAGE',
128  'GETANSINULL','HOST_ID','HOST_NAME','IDENT_CURRENT','IDENT_INCR',
129  'IDENT_SEED','@@IDENTITY','ISDATE','ISNUMERIC','PARSENAME','PERMISSIONS',
130  '@@ROWCOUNT','ROWCOUNT_BIG','SCOPE_IDENTITY','SERVERPROPERTY','SESSIONPROPERTY',
131  'STATS_DATE','@@TRANCOUNT','USER_NAME',
132 
133  //System Statistical Functions
134  '@@CONNECTIONS','@@PACK_RECEIVED','@@CPU_BUSY','@@PACK_SENT',
135  '@@TIMETICKS','@@IDLE','@@TOTAL_ERRORS','@@IO_BUSY',
136  '@@TOTAL_READ','@@PACKET_ERRORS','@@TOTAL_WRITE',
137 
138  //Text and Image Functions
139  'TEXTPTR','TEXTVALID',
140 
141  //Aggregate functions
142  'AVG', 'MAX', 'BINARY_CHECKSUM', 'MIN', 'CHECKSUM', 'SUM', 'CHECKSUM_AGG',
143  'STDEV', 'COUNT', 'STDEVP', 'COUNT_BIG', 'VAR', 'VARP'
144  ),
145  3 => array(
146  /*
147  System stored procedures
148  Higlighted dark brown
149  */
150 
151  //Active Directory Procedures
152  'sp_ActiveDirectory_Obj', 'sp_ActiveDirectory_SCP',
153 
154  //Catalog Procedures
155  'sp_column_privileges', 'sp_special_columns', 'sp_columns', 'sp_sproc_columns',
156  'sp_databases', 'sp_statistics', 'sp_fkeys', 'sp_stored_procedures', 'sp_pkeys',
157  'sp_table_privileges', 'sp_server_info', 'sp_tables',
158 
159  //Cursor Procedures
160  'sp_cursor_list', 'sp_describe_cursor_columns', 'sp_describe_cursor', 'sp_describe_cursor_tables',
161 
162  //Database Maintenance Plan Procedures
163  'sp_add_maintenance_plan', 'sp_delete_maintenance_plan_db', 'sp_add_maintenance_plan_db',
164  'sp_delete_maintenance_plan_job', 'sp_add_maintenance_plan_job', 'sp_help_maintenance_plan',
165  'sp_delete_maintenance_plan',
166 
167  //Distributed Queries Procedures
168  'sp_addlinkedserver', 'sp_indexes', 'sp_addlinkedsrvlogin', 'sp_linkedservers', 'sp_catalogs',
169  'sp_primarykeys', 'sp_column_privileges_ex', 'sp_columns_ex',
170  'sp_table_privileges_ex', 'sp_tables_ex', 'sp_foreignkeys',
171 
172  //Full-Text Search Procedures
173  'sp_fulltext_catalog', 'sp_help_fulltext_catalogs_cursor', 'sp_fulltext_column',
174  'sp_help_fulltext_columns', 'sp_fulltext_database', 'sp_help_fulltext_columns_cursor',
175  'sp_fulltext_service', 'sp_help_fulltext_tables', 'sp_fulltext_table',
176  'sp_help_fulltext_tables_cursor', 'sp_help_fulltext_catalogs',
177 
178  //Log Shipping Procedures
179  'sp_add_log_shipping_database', 'sp_delete_log_shipping_database', 'sp_add_log_shipping_plan',
180  'sp_delete_log_shipping_plan', 'sp_add_log_shipping_plan_database',
181  'sp_delete_log_shipping_plan_database', 'sp_add_log_shipping_primary',
182  'sp_delete_log_shipping_primary', 'sp_add_log_shipping_secondary',
183  'sp_delete_log_shipping_secondary', 'sp_can_tlog_be_applied', 'sp_get_log_shipping_monitor_info',
184  'sp_change_monitor_role', 'sp_remove_log_shipping_monitor', 'sp_change_primary_role',
185  'sp_resolve_logins', 'sp_change_secondary_role', 'sp_update_log_shipping_monitor_info',
186  'sp_create_log_shipping_monitor_account', 'sp_update_log_shipping_plan',
187  'sp_define_log_shipping_monitor', 'sp_update_log_shipping_plan_database',
188 
189  //OLE Automation Extended Stored Procedures
190  'sp_OACreate', 'sp_OAMethod', 'sp_OADestroy', 'sp_OASetProperty', 'sp_OAGetErrorInfo',
191  'sp_OAStop', 'sp_OAGetProperty',
192 
193  //Replication Procedures
194  'sp_add_agent_parameter', 'sp_enableagentoffload', 'sp_add_agent_profile',
195  'sp_enumcustomresolvers', 'sp_addarticle', 'sp_enumdsn', 'sp_adddistpublisher',
196  'sp_enumfullsubscribers', 'sp_adddistributiondb', 'sp_expired_subscription_cleanup',
197  'sp_adddistributor', 'sp_generatefilters', 'sp_addmergealternatepublisher',
198  'sp_getagentoffloadinfo', 'sp_addmergearticle', 'sp_getmergedeletetype', 'sp_addmergefilter',
199  'sp_get_distributor', 'sp_addmergepublication', 'sp_getqueuedrows', 'sp_addmergepullsubscription',
200  'sp_getsubscriptiondtspackagename', 'sp_addmergepullsubscription_agent', 'sp_grant_publication_access',
201  'sp_addmergesubscription', 'sp_help_agent_default', 'sp_addpublication', 'sp_help_agent_parameter',
202  'sp_addpublication_snapshot', 'sp_help_agent_profile', 'sp_addpublisher70', 'sp_helparticle',
203  'sp_addpullsubscription', 'sp_helparticlecolumns', 'sp_addpullsubscription_agent', 'sp_helparticledts',
204  'sp_addscriptexec', 'sp_helpdistpublisher', 'sp_addsubscriber', 'sp_helpdistributiondb',
205  'sp_addsubscriber_schedule', 'sp_helpdistributor', 'sp_addsubscription', 'sp_helpmergealternatepublisher',
206  'sp_addsynctriggers', 'sp_helpmergearticle', 'sp_addtabletocontents', 'sp_helpmergearticlecolumn',
207  'sp_adjustpublisheridentityrange', 'sp_helpmergearticleconflicts', 'sp_article_validation',
208  'sp_helpmergeconflictrows', 'sp_articlecolumn', 'sp_helpmergedeleteconflictrows', 'sp_articlefilter',
209  'sp_helpmergefilter', 'sp_articlesynctranprocs', 'sp_helpmergepublication', 'sp_articleview',
210  'sp_helpmergepullsubscription', 'sp_attachsubscription', 'sp_helpmergesubscription', 'sp_browsesnapshotfolder',
211  'sp_helppublication', 'sp_browsemergesnapshotfolder', 'sp_help_publication_access', 'sp_browsereplcmds',
212  'sp_helppullsubscription', 'sp_change_agent_parameter', 'sp_helpreplfailovermode', 'sp_change_agent_profile',
213  'sp_helpreplicationdboption', 'sp_changearticle', 'sp_helpreplicationoption', 'sp_changedistpublisher',
214  'sp_helpsubscriberinfo', 'sp_changedistributiondb', 'sp_helpsubscription', 'sp_changedistributor_password',
215  'sp_ivindexhasnullcols', 'sp_changedistributor_property', 'sp_helpsubscription_properties', 'sp_changemergearticle',
216  'sp_link_publication', 'sp_changemergefilter', 'sp_marksubscriptionvalidation', 'sp_changemergepublication',
217  'sp_mergearticlecolumn', 'sp_changemergepullsubscription', 'sp_mergecleanupmetadata', 'sp_changemergesubscription',
218  'sp_mergedummyupdate', 'sp_changepublication', 'sp_mergesubscription_cleanup', 'sp_changesubscriber',
219  'sp_publication_validation', 'sp_changesubscriber_schedule', 'sp_refreshsubscriptions', 'sp_changesubscriptiondtsinfo',
220  'sp_reinitmergepullsubscription', 'sp_changesubstatus', 'sp_reinitmergesubscription', 'sp_change_subscription_properties',
221  'sp_reinitpullsubscription', 'sp_check_for_sync_trigger', 'sp_reinitsubscription', 'sp_copymergesnapshot',
222  'sp_removedbreplication', 'sp_copysnapshot', 'sp_repladdcolumn', 'sp_copysubscription', 'sp_replcmds',
223  'sp_deletemergeconflictrow', 'sp_replcounters', 'sp_disableagentoffload', 'sp_repldone', 'sp_drop_agent_parameter',
224  'sp_repldropcolumn', 'sp_drop_agent_profile', 'sp_replflush', 'sp_droparticle', 'sp_replicationdboption',
225  'sp_dropanonymouseagent', 'sp_replication_agent_checkup', 'sp_dropdistpublisher', 'sp_replqueuemonitor',
226  'sp_dropdistributiondb', 'sp_replsetoriginator', 'sp_dropmergealternatepublisher', 'sp_replshowcmds',
227  'sp_dropdistributor', 'sp_repltrans', 'sp_dropmergearticle', 'sp_restoredbreplication', 'sp_dropmergefilter',
228  'sp_revoke_publication_access', 'sp_scriptsubconflicttable', 'sp_dropmergepublication', 'sp_script_synctran_commands',
229  'sp_dropmergepullsubscription', 'sp_setreplfailovermode', 'sp_showrowreplicainfo', 'sp_dropmergesubscription',
230  'sp_subscription_cleanup', 'sp_droppublication', 'sp_table_validation', 'sp_droppullsubscription',
231  'sp_update_agent_profile', 'sp_dropsubscriber', 'sp_validatemergepublication', 'sp_dropsubscription',
232  'sp_validatemergesubscription', 'sp_dsninfo', 'sp_vupgrade_replication', 'sp_dumpparamcmd',
233 
234  //Security Procedures
235  'sp_addalias', 'sp_droprolemember', 'sp_addapprole', 'sp_dropserver', 'sp_addgroup', 'sp_dropsrvrolemember',
236  'sp_dropuser', 'sp_addlogin', 'sp_grantdbaccess', 'sp_addremotelogin',
237  'sp_grantlogin', 'sp_addrole', 'sp_helpdbfixedrole', 'sp_addrolemember', 'sp_helpgroup',
238  'sp_addserver', 'sp_helplinkedsrvlogin', 'sp_addsrvrolemember', 'sp_helplogins', 'sp_adduser',
239  'sp_helpntgroup', 'sp_approlepassword', 'sp_helpremotelogin', 'sp_changedbowner', 'sp_helprole',
240  'sp_changegroup', 'sp_helprolemember', 'sp_changeobjectowner', 'sp_helprotect', 'sp_change_users_login',
241  'sp_helpsrvrole', 'sp_dbfixedrolepermission', 'sp_helpsrvrolemember', 'sp_defaultdb', 'sp_helpuser',
242  'sp_defaultlanguage', 'sp_MShasdbaccess', 'sp_denylogin', 'sp_password', 'sp_dropalias', 'sp_remoteoption',
243  'sp_dropapprole', 'sp_revokedbaccess', 'sp_dropgroup', 'sp_revokelogin', 'sp_droplinkedsrvlogin',
244  'sp_setapprole', 'sp_droplogin', 'sp_srvrolepermission', 'sp_dropremotelogin', 'sp_validatelogins', 'sp_droprole',
245 
246  //SQL Mail Procedures
247  'sp_processmail', 'xp_sendmail', 'xp_deletemail', 'xp_startmail', 'xp_findnextmsg', 'xp_stopmail', 'xp_readmail',
248 
249  //SQL Profiler Procedures
250  'sp_trace_create', 'sp_trace_setfilter', 'sp_trace_generateevent', 'sp_trace_setstatus', 'sp_trace_setevent',
251 
252  //SQL Server Agent Procedures
253  'sp_add_alert', 'sp_help_jobhistory', 'sp_add_category', 'sp_help_jobschedule', 'sp_add_job',
254  'sp_help_jobserver', 'sp_add_jobschedule', 'sp_help_jobstep', 'sp_add_jobserver', 'sp_help_notification',
255  'sp_add_jobstep', 'sp_help_operator', 'sp_add_notification', 'sp_help_targetserver',
256  'sp_add_operator', 'sp_help_targetservergroup', 'sp_add_targetservergroup', 'sp_helptask',
257  'sp_add_targetsvrgrp_member', 'sp_manage_jobs_by_login', 'sp_addtask', 'sp_msx_defect',
258  'sp_apply_job_to_targets', 'sp_msx_enlist', 'sp_delete_alert', 'sp_post_msx_operation',
259  'sp_delete_category', 'sp_purgehistory', 'sp_delete_job', 'sp_purge_jobhistory', 'sp_delete_jobschedule',
260  'sp_reassigntask', 'sp_delete_jobserver', 'sp_remove_job_from_targets', 'sp_delete_jobstep',
261  'sp_resync_targetserver', 'sp_delete_notification', 'sp_start_job', 'sp_delete_operator',
262  'sp_stop_job', 'sp_delete_targetserver', 'sp_update_alert', 'sp_delete_targetservergroup',
263  'sp_update_category', 'sp_delete_targetsvrgrp_member', 'sp_update_job', 'sp_droptask',
264  'sp_update_jobschedule', 'sp_help_alert', 'sp_update_jobstep', 'sp_help_category',
265  'sp_update_notification', 'sp_help_downloadlist', 'sp_update_operator', 'sp_helphistory',
266  'sp_update_targetservergroup', 'sp_help_job', 'sp_updatetask', 'xp_sqlagent_proxy_account',
267 
268  //System Procedures
269  'sp_add_data_file_recover_suspect_db', 'sp_helpconstraint', 'sp_addextendedproc',
270  'sp_helpdb', 'sp_addextendedproperty', 'sp_helpdevice', 'sp_add_log_file_recover_suspect_db',
271  'sp_helpextendedproc', 'sp_addmessage', 'sp_helpfile', 'sp_addtype', 'sp_helpfilegroup',
272  'sp_addumpdevice', 'sp_helpindex', 'sp_altermessage', 'sp_helplanguage', 'sp_autostats',
273  'sp_helpserver', 'sp_attach_db', 'sp_helpsort', 'sp_attach_single_file_db', 'sp_helpstats',
274  'sp_bindefault', 'sp_helptext', 'sp_bindrule', 'sp_helptrigger', 'sp_bindsession',
275  'sp_indexoption', 'sp_certify_removable', 'sp_invalidate_textptr', 'sp_configure',
276  'sp_lock', 'sp_create_removable', 'sp_monitor', 'sp_createstats', 'sp_procoption',
277  'sp_cycle_errorlog', 'sp_recompile', 'sp_datatype_info', 'sp_refreshview', 'sp_dbcmptlevel',
278  'sp_releaseapplock', 'sp_dboption', 'sp_rename', 'sp_dbremove', 'sp_renamedb',
279  'sp_delete_backuphistory', 'sp_resetstatus', 'sp_depends', 'sp_serveroption', 'sp_detach_db',
280  'sp_setnetname', 'sp_dropdevice', 'sp_settriggerorder', 'sp_dropextendedproc', 'sp_spaceused',
281  'sp_dropextendedproperty', 'sp_tableoption', 'sp_dropmessage', 'sp_unbindefault', 'sp_droptype',
282  'sp_unbindrule', 'sp_executesql', 'sp_updateextendedproperty', 'sp_getapplock', 'sp_updatestats',
283  'sp_getbindtoken', 'sp_validname', 'sp_help', 'sp_who',
284 
285  //Web Assistant Procedures
286  'sp_dropwebtask', 'sp_makewebtask', 'sp_enumcodepages', 'sp_runwebtask',
287 
288  //XML Procedures
289  'sp_xml_preparedocument', 'sp_xml_removedocument',
290 
291  //General Extended Procedures
292  'xp_cmdshellxp_logininfo', 'xp_enumgroups', 'xp_msver', 'xp_findnextmsgxp_revokelogin',
293  'xp_grantlogin', 'xp_sprintf', 'xp_logevent', 'xp_sqlmaint', 'xp_loginconfig', 'xp_sscanf',
294 
295  //API System Stored Procedures
296  'sp_cursor', 'sp_cursorclose', 'sp_cursorexecute', 'sp_cursorfetch', 'sp_cursoropen',
297  'sp_cursoroption', 'sp_cursorprepare', 'sp_cursorunprepare', 'sp_execute', 'sp_prepare', 'sp_unprepare',
298 
299  //Misc
300  'sp_createorphan', 'sp_droporphans', 'sp_reset_connection', 'sp_sdidebug'
301  ),
302  4 => array(
303  //Function/sp's higlighted brown.
304  'fn_helpcollations', 'fn_listextendedproperty ', 'fn_servershareddrives',
305  'fn_trace_geteventinfo', 'fn_trace_getfilterinfo', 'fn_trace_getinfo',
306  'fn_trace_gettable', 'fn_virtualfilestats','fn_listextendedproperty',
307  ),
308  5 => array(
309  'ALL', 'AND', 'ANY', 'BETWEEN', 'CROSS', 'EXISTS', 'IN', 'JOIN', 'LIKE', 'NOT', 'NULL',
310  'OR', 'OUTER', 'SOME',
311  )
312  ),
313  'SYMBOLS' => array(
314  '!', '!=', '%', '&', '&&', '(', ')', '*', '+', '-', '/', '<', '<<', '<=',
315  '<=>', '<>', '=', '>', '>=', '>>', '^', '|', '||', '~'
316  ),
317  'CASE_SENSITIVE' => array(
318  GESHI_COMMENTS => false,
319  1 => false,
320  2 => false,
321  3 => false,
322  4 => false,
323  5 => false
324  ),
325  'STYLES' => array(
326  'KEYWORDS' => array(
327  1 => 'color: #0000FF;',
328  2 => 'color: #FF00FF;',
329  3 => 'color: #AF0000;',
330  4 => 'color: #AF0000;',
331  5 => 'color: #808080;'
332  ),
333  'COMMENTS' => array(
334  1 => 'color: #008080;',
335  'MULTI' => 'color: #008080;'
336  ),
337  'ESCAPE_CHAR' => array(
338  0 => 'color: #000099; font-weight: bold;'
339  ),
340  'BRACKETS' => array(
341  0 => 'color: #808080;'
342  ),
343  'STRINGS' => array(
344  0 => 'color: #FF0000;'
345  ),
346  'NUMBERS' => array(
347  0 => 'color: #000;'
348  ),
349  'METHODS' => array(
350  1 => 'color: #202020;',
351  2 => 'color: #202020;'
352  ),
353  'SYMBOLS' => array(
354  0 => 'color: #808080;'
355  ),
356  'REGEXPS' => array(
357  ),
358  'SCRIPT' => array(
359  )
360  ),
361  'URLS' => array(
362  1 => '',
363  2 => '',
364  3 => '',
365  4 => '',
366  5 => ''
367  ),
368  'OOLANG' => true,
369  'OBJECT_SPLITTERS' => array(
370  1 => '.'
371  ),
372  'REGEXPS' => array(
373  ),
374  'STRICT_MODE_APPLIES' => GESHI_NEVER,
375  'SCRIPT_DELIMITERS' => array(
376  ),
377  'HIGHLIGHT_STRICT_BLOCK' => array(
378  )
379 );
GESHI_COMMENTS
const GESHI_COMMENTS
Used in language files to mark comments.
Definition: geshi.php:150
$language_data
$language_data
Definition: tsql.php:40
array
Create styles array
The data for the language used.
Definition: 40duplicateStyle.php:19
GESHI_NEVER
const GESHI_NEVER
#+ private
Definition: geshi.php:124
GESHI_CAPS_NO_CHANGE
const GESHI_CAPS_NO_CHANGE
Lowercase keywords found.
Definition: geshi.php:95