90 Highlighted in pink. |
90 Highlighted in pink. |
91 */ |
91 */ |
92 |
92 |
93 //Configuration Functions |
93 //Configuration Functions |
94 '@@DATEFIRST','@@OPTIONS','@@DBTS','@@REMSERVER','@@LANGID','@@SERVERNAME', |
94 '@@DATEFIRST','@@OPTIONS','@@DBTS','@@REMSERVER','@@LANGID','@@SERVERNAME', |
95 '@@LANGUAGE','@@SERVICENAME','@@LOCK_TIMEOUT','@@SPID','@@MAX_CONNECTIONS','@@TEXTSIZE', |
95 '@@LANGUAGE','@@SERVICENAME','@@LOCK_TIMEOUT','@@SPID','@@MAX_CONNECTIONS', |
96 '@@MAX_PRECISION','@@VERSION','@@NESTLEVEL', |
96 '@@TEXTSIZE','@@MAX_PRECISION','@@VERSION','@@NESTLEVEL', |
97 |
97 |
98 //Cursor Functions |
98 //Cursor Functions |
99 '@@CURSOR_ROWS','@@FETCH_STATUS', |
99 '@@CURSOR_ROWS','@@FETCH_STATUS', |
100 |
100 |
101 //Date and Time Functions |
101 //Date and Time Functions |
102 'DATEADD','DATEDIFF','DATENAME','DATEPART','DAY','GETDATE','GETUTCDATE','MONTH','YEAR', |
102 'DATEADD','DATEDIFF','DATENAME','DATEPART','GETDATE','GETUTCDATE', |
103 |
103 |
104 //Mathematical Functions |
104 //Mathematical Functions |
105 'ABS','DEGREES','RAND','ACOS','EXP','ROUND','ASIN','FLOOR','SIGN', |
105 'ABS','DEGREES','RAND','ACOS','EXP','ROUND','ASIN','FLOOR','SIGN', |
106 'ATAN','LOG','SIN','ATN2','LOG10','SQUARE','CEILING','PI','SQRT','COS', |
106 'ATAN','LOG','SIN','ATN2','LOG10','SQUARE','CEILING','PI','SQRT','COS', |
107 'POWER','TAN','COT','RADIANS', |
107 'POWER','TAN','COT','RADIANS', |
108 |
108 |
109 //Meta Data Functions |
109 //Meta Data Functions |
110 'COL_LENGTH','fn_listextendedproperty','COL_NAME','FULLTEXTCATALOGPROPERTY', |
110 'COL_LENGTH','COL_NAME','FULLTEXTCATALOGPROPERTY', |
111 'COLUMNPROPERTY','FULLTEXTSERVICEPROPERTY','DATABASEPROPERTY','INDEX_COL', |
111 'COLUMNPROPERTY','FULLTEXTSERVICEPROPERTY','DATABASEPROPERTY','INDEX_COL', |
112 'DATABASEPROPERTYEX','INDEXKEY_PROPERTY','DB_ID','INDEXPROPERTY','DB_NAME', |
112 'DATABASEPROPERTYEX','INDEXKEY_PROPERTY','DB_ID','INDEXPROPERTY','DB_NAME', |
113 'OBJECT_ID','FILE_ID','OBJECT_NAME','FILE_NAME','OBJECTPROPERTY','FILEGROUP_ID', |
113 'OBJECT_ID','FILE_ID','OBJECT_NAME','FILE_NAME','OBJECTPROPERTY','FILEGROUP_ID', |
114 '@@PROCID','FILEGROUP_NAME','SQL_VARIANT_PROPERTY','FILEGROUPPROPERTY', |
114 '@@PROCID','FILEGROUP_NAME','SQL_VARIANT_PROPERTY','FILEGROUPPROPERTY', |
115 'TYPEPROPERTY','FILEPROPERTY', |
115 'TYPEPROPERTY','FILEPROPERTY', |
116 |
116 |
117 //Security Functions |
117 //Security Functions |
118 'fn_trace_geteventinfo','IS_SRVROLEMEMBER','fn_trace_getfilterinfo','SUSER_SID', |
118 'IS_SRVROLEMEMBER','SUSER_SID','SUSER_SNAME','USER_ID', |
119 'fn_trace_getinfo','SUSER_SNAME','fn_trace_gettable','USER_ID','HAS_DBACCESS', |
119 'HAS_DBACCESS','IS_MEMBER', |
120 'IS_MEMBER', |
|
121 |
120 |
122 //String Functions |
121 //String Functions |
123 'ASCII','NCHAR','SOUNDEX','CHAR','PATINDEX','SPACE','CHARINDEX', |
122 'ASCII','SOUNDEX','PATINDEX','CHARINDEX','REPLACE','STR', |
124 'REPLACE','STR','DIFFERENCE','QUOTENAME','STUFF','LEFT','REPLICATE', |
123 'DIFFERENCE','QUOTENAME','STUFF','REPLICATE','SUBSTRING','LEN', |
125 'SUBSTRING','LEN','REVERSE','UNICODE','LOWER','RIGHT','UPPER','LTRIM', |
124 'REVERSE','UNICODE','LOWER','UPPER','LTRIM','RTRIM', |
126 'RTRIM', |
|
127 |
125 |
128 //System Functions |
126 //System Functions |
129 'APP_NAME','COLLATIONPROPERTY','@@ERROR','fn_helpcollations', |
127 'APP_NAME','COLLATIONPROPERTY','@@ERROR','FORMATMESSAGE', |
130 'fn_servershareddrives','fn_virtualfilestats','FORMATMESSAGE', |
|
131 'GETANSINULL','HOST_ID','HOST_NAME','IDENT_CURRENT','IDENT_INCR', |
128 'GETANSINULL','HOST_ID','HOST_NAME','IDENT_CURRENT','IDENT_INCR', |
132 'IDENT_SEED','@@IDENTITY','ISDATE','ISNUMERIC','PARSENAME','PERMISSIONS', |
129 'IDENT_SEED','@@IDENTITY','ISDATE','ISNUMERIC','PARSENAME','PERMISSIONS', |
133 '@@ROWCOUNT','ROWCOUNT_BIG','SCOPE_IDENTITY','SERVERPROPERTY','SESSIONPROPERTY', |
130 '@@ROWCOUNT','ROWCOUNT_BIG','SCOPE_IDENTITY','SERVERPROPERTY','SESSIONPROPERTY', |
134 'STATS_DATE','@@TRANCOUNT','USER_NAME', |
131 'STATS_DATE','@@TRANCOUNT','USER_NAME', |
135 |
132 |
304 ), |
301 ), |
305 4 => array( |
302 4 => array( |
306 //Function/sp's higlighted brown. |
303 //Function/sp's higlighted brown. |
307 'fn_helpcollations', 'fn_listextendedproperty ', 'fn_servershareddrives', |
304 'fn_helpcollations', 'fn_listextendedproperty ', 'fn_servershareddrives', |
308 'fn_trace_geteventinfo', 'fn_trace_getfilterinfo', 'fn_trace_getinfo', |
305 'fn_trace_geteventinfo', 'fn_trace_getfilterinfo', 'fn_trace_getinfo', |
309 'fn_trace_gettable', 'fn_virtualfilestats', |
306 'fn_trace_gettable', 'fn_virtualfilestats','fn_listextendedproperty', |
310 ), |
307 ), |
311 ), |
308 ), |
312 'SYMBOLS' => array( |
309 'SYMBOLS' => array( |
313 '!', '!=', '%', '&', '&&', '(', ')', '*', '+', '-', '/', '<', '<<', '<=', |
310 '!', '!=', '%', '&', '&&', '(', ')', '*', '+', '-', '/', '<', '<<', '<=', |
314 '<=>', '<>', '=', '>', '>=', '>>', '^', 'ALL', 'AND', 'ANY', 'BETWEEN', 'CROSS', |
311 '<=>', '<>', '=', '>', '>=', '>>', '^', 'ALL', 'AND', 'ANY', 'BETWEEN', 'CROSS', |