Skip to content

Commit 0de30f1

Browse files
JerryFan626JerryFan626
committed
feat: Update SQLServer keywords and functions
1 parent 61e2da4 commit 0de30f1

1 file changed

Lines changed: 178 additions & 26 deletions

File tree

‎chat2db-client/src/constants/IntelliSense/sqlserver.ts‎

Lines changed: 178 additions & 26 deletions
Original file line numberDiff line numberDiff line change
@@ -3,24 +3,33 @@ import { DatabaseTypeCode } from '../common';
33
export default {
44
type: DatabaseTypeCode.SQLSERVER,
55
keywords: [
6+
'ABSOLUTE',
7+
'ACTION',
68
'ADD',
9+
'AFTER',
710
'ALL',
811
'ALTER',
12+
'ALWAYS',
913
'AND',
1014
'ANY',
15+
'APPLY',
1116
'AS',
1217
'ASC',
1318
'AUTHORIZATION',
1419
'BACKUP',
1520
'BEGIN',
1621
'BETWEEN',
22+
'BINARY',
1723
'BREAK',
1824
'BROWSE',
1925
'BULK',
2026
'BY',
2127
'CASCADE',
2228
'CASE',
29+
'CAST',
30+
'CATCH',
2331
'CHECK',
32+
'CHECKPOINT',
2433
'CLOSE',
2534
'CLUSTERED',
2635
'COALESCE',
@@ -33,14 +42,13 @@ export default {
3342
'CONTAINSTABLE',
3443
'CONTINUE',
3544
'CONVERT',
45+
'CORRESPONDING',
3646
'CREATE',
3747
'CROSS',
3848
'CURRENT',
39-
'CURRENT_DATE',
40-
'CURRENT_TIME',
41-
'CURRENT_TIMESTAMP',
42-
'CURRENT_USER',
4349
'CURSOR',
50+
'CYCLE',
51+
'DATA',
4452
'DATABASE',
4553
'DBCC',
4654
'DEALLOCATE',
@@ -49,13 +57,17 @@ export default {
4957
'DELETE',
5058
'DENY',
5159
'DESC',
52-
'DISK',
60+
'DESCRIPTION',
61+
'DISABLE',
62+
'DISALLOW',
63+
'DISCONNECT',
5364
'DISTINCT',
5465
'DISTRIBUTED',
5566
'DOUBLE',
5667
'DROP',
5768
'DUMP',
5869
'ELSE',
70+
'ENABLE',
5971
'END',
6072
'ERRLVL',
6173
'ESCAPE',
@@ -68,10 +80,9 @@ export default {
6880
'FETCH',
6981
'FILE',
7082
'FILLFACTOR',
83+
'FOLLOWING',
7184
'FOR',
7285
'FOREIGN',
73-
'FREETEXT',
74-
'FREETEXTTABLE',
7586
'FROM',
7687
'FULL',
7788
'FUNCTION',
@@ -81,23 +92,25 @@ export default {
8192
'HAVING',
8293
'HOLDLOCK',
8394
'IDENTITY',
84-
'IDENTITY_INSERT',
85-
'IDENTITYCOL',
8695
'IF',
8796
'IN',
8897
'INDEX',
8998
'INNER',
9099
'INSERT',
100+
'INSTEAD',
91101
'INTERSECT',
92102
'INTO',
93103
'IS',
94104
'JOIN',
95105
'KEY',
96106
'KILL',
107+
'LAST',
97108
'LEFT',
98109
'LIKE',
110+
'LIMIT',
99111
'LINENO',
100112
'LOAD',
113+
'LOCAL',
101114
'MERGE',
102115
'NATIONAL',
103116
'NOCHECK',
@@ -109,19 +122,18 @@ export default {
109122
'OFF',
110123
'OFFSETS',
111124
'ON',
125+
'ONLY',
112126
'OPEN',
113-
'OPENDATASOURCE',
114-
'OPENQUERY',
115-
'OPENROWSET',
116-
'OPENXML',
117127
'OPTION',
118128
'OR',
119129
'ORDER',
120130
'OUTER',
131+
'OUTPUT',
121132
'OVER',
133+
'PARTITION',
122134
'PERCENT',
123-
'PIVOT',
124135
'PLAN',
136+
'PRECEDING',
125137
'PRECISION',
126138
'PRIMARY',
127139
'PRINT',
@@ -130,14 +142,14 @@ export default {
130142
'PUBLIC',
131143
'RAISERROR',
132144
'READ',
145+
'READONLY',
133146
'READTEXT',
134147
'RECONFIGURE',
135148
'REFERENCES',
136149
'REPLICATION',
137150
'RESTORE',
138151
'RESTRICT',
139152
'RETURN',
140-
'REVERT',
141153
'REVOKE',
142154
'RIGHT',
143155
'ROLLBACK',
@@ -162,13 +174,14 @@ export default {
162174
'TABLESAMPLE',
163175
'TEXTSIZE',
164176
'THEN',
177+
'THROW',
165178
'TO',
166179
'TOP',
167180
'TRAN',
168181
'TRANSACTION',
169182
'TRIGGER',
170183
'TRUNCATE',
171-
'TRY_CONVERT',
184+
'TRY',
172185
'TSEQUAL',
173186
'UNION',
174187
'UNIQUE',
@@ -185,61 +198,200 @@ export default {
185198
'WHERE',
186199
'WHILE',
187200
'WITH',
201+
'WITHIN',
188202
'WRITETEXT',
203+
'XML',
189204
],
190205
functions: [
191206
'ABS',
207+
'ACOS',
208+
'APP_NAME',
209+
'ASCII',
210+
'ASIN',
211+
'ATAN',
212+
'ATN2',
192213
'AVG',
214+
'BIGCOUNT',
215+
'BINARY_CHECKSUM',
193216
'CAST',
194217
'CEILING',
218+
'CHAR',
219+
'CHARINDEX',
220+
'CHECKSUM',
221+
'CHECKSUM_AGG',
195222
'COALESCE',
223+
'COL_LENGTH',
224+
'COL_NAME',
225+
'CONCAT',
226+
'CONCAT_WS',
227+
'CONNECTIONPROPERTY',
228+
'CONTEXT_INFO',
196229
'CONVERT',
230+
'COS',
231+
'COT',
197232
'COUNT',
198-
'CURRENT_TIMESTAMP',
199-
'DATALENGTH',
233+
'COUNT_BIG',
234+
'CRYPT_GEN_RANDOM',
235+
'CRYPT_PROPERTY',
236+
'CURSOR_STATUS',
237+
'DATABASEPROPERTYEX',
200238
'DATEADD',
201239
'DATEDIFF',
202240
'DATENAME',
203241
'DATEPART',
204242
'DAY',
243+
'DB_ID',
244+
'DB_NAME',
245+
'DEGREES',
246+
'DIFFERENCE',
247+
'EXP',
248+
'FILE_ID',
249+
'FILE_NAME',
250+
'FILEGROUP_ID',
251+
'FILEGROUP_NAME',
252+
'FILEGROUPPROPERTY',
253+
'FILEPROPERTY',
254+
'FLOOR',
255+
'FORMAT',
256+
'GETANSINULL',
205257
'GETDATE',
206258
'GETUTCDATE',
259+
'HASHBYTES',
260+
'HOST_ID',
261+
'HOST_NAME',
207262
'IDENT_CURRENT',
208263
'IDENT_INCR',
209264
'IDENT_SEED',
265+
'IIF',
266+
'INDEX_COL',
267+
'INDEXKEY_PROPERTY',
268+
'INDEXPROPERTY',
210269
'ISDATE',
211270
'ISNULL',
271+
'ISNUMERIC',
272+
'IS_MEMBER',
273+
'IS_OBJECTSIGNED',
274+
'IS_SRVROLEMEMBER',
275+
'ISNULL',
276+
'LEFT',
212277
'LEN',
278+
'LOG',
279+
'LOG10',
213280
'LOWER',
214281
'LTRIM',
215282
'MAX',
216283
'MIN',
217284
'MONTH',
218285
'NEWID',
219286
'NULLIF',
287+
'OBJECT_DEFINITION',
288+
'OBJECT_ID',
289+
'OBJECT_NAME',
290+
'OBJECT_SCHEMA_NAME',
291+
'OBJECTPROPERTY',
292+
'OBJECTPROPERTYEX',
293+
'PARSE',
220294
'PATINDEX',
221-
'RAND',
295+
'PERCENT_RANK',
296+
'PERCENTILE_CONT',
297+
'PERCENTILE_DISC',
298+
'PI',
299+
'POWER',
300+
'RADIANS',
301+
'RANK',
222302
'REPLACE',
223303
'REPLICATE',
224304
'REVERSE',
305+
'RIGHT',
225306
'ROUND',
307+
'ROW_NUMBER',
226308
'RTRIM',
227-
'SESSION_USER',
309+
'SCOPE_IDENTITY',
310+
'SERVERPROPERTY',
311+
'SESSIONPROPERTY',
312+
'SIGN',
313+
'SIN',
314+
'SOUNDEX',
228315
'SPACE',
229-
'SQL_VARIANT_PROPERTY',
230-
'SQUARE',
231316
'SQRT',
317+
'SQUARE',
232318
'STATS_DATE',
233319
'STDEV',
234320
'STDEVP',
235-
'STR',
236-
'STRING_AGG',
237-
'STRING_ESCAPE',
238-
'STRING_SPLIT',
321+
'STUFF',
239322
'SUBSTRING',
240323
'SUM',
324+
'SUSER_ID',
325+
'SUSER_NAME',
326+
'SUSER_SID',
327+
'SUSER_SNAME',
241328
'SYSTEM_USER',
329+
'TAN',
330+
'TEXTPTR',
331+
'TEXTVALID',
332+
'TRY_CAST',
333+
'TRY_CONVERT',
334+
'TRY_PARSE',
335+
'TYPE_ID',
336+
'TYPE_NAME',
337+
'TYPEPROPERTY',
338+
'UNICODE',
242339
'UPPER',
340+
'USER_ID',
341+
'USER_NAME',
243342
'YEAR',
343+
'GET_FILESTREAM_TRANSACTION_CONTEXT',
344+
'CURRENT_TRANSACTION_ID',
345+
'XACT_STATE',
346+
'STRING_AGG',
347+
'STRING_ESCAPE',
348+
'STRING_SPLIT',
349+
'FORMATMESSAGE',
350+
'XML_SCHEMA_NAMESPACE',
351+
'ISJSON',
352+
'JSON_VALUE',
353+
'JSON_QUERY',
354+
'JSON_MODIFY',
355+
'JSON_EXISTS',
356+
'JSON_TEXTCONTAINS',
357+
'CHOOSE',
358+
'IIF',
359+
'FORMAT',
360+
'PARSE',
361+
'SEQUENCE_SCHEMA',
362+
'SEQUENCE_NAME',
363+
'SPATIAL_ST_GEOMETRYTYPE',
364+
'SPATIAL_ST_DIMENSION',
365+
'SPATIAL_ST_SRID',
366+
'SPATIAL_ST_ISVALID',
367+
'SPATIAL_ST_ASTEXT',
368+
'SPATIAL_ST_ASBINARY',
369+
'SPATIAL_ST_AREA',
370+
'SPATIAL_ST_LENGTH',
371+
'SPATIAL_ST_ISCLOSED',
372+
'SPATIAL_ST_NUMPOINTS',
373+
'SPATIAL_ST_X',
374+
'SPATIAL_ST_Y',
375+
'SPATIAL_ST_NUMGEOMETRIES',
376+
'SPATIAL_ST_BOUNDARY',
377+
'SPATIAL_ST_BUFFER',
378+
'SPATIAL_ST_CENTROID',
379+
'SPATIAL_ST_CONTAINS',
380+
'SPATIAL_ST_CONVEXHULL',
381+
'SPATIAL_ST_CROSSES',
382+
'SPATIAL_ST_DIFFERENCE',
383+
'SPATIAL_ST_DISJOINT',
384+
'SPATIAL_ST_DISTANCE',
385+
'SPATIAL_ST_ENVELOPE',
386+
'SPATIAL_ST_EQUALS',
387+
'SPATIAL_ST_INTERSECTION',
388+
'SPATIAL_ST_INTERSECTS',
389+
'SPATIAL_ST_ISRING',
390+
'SPATIAL_ST_ISSIMPLE',
391+
'SPATIAL_ST_OVERLAPS',
392+
'SPATIAL_ST_SYMDIFFERENCE',
393+
'SPATIAL_ST_TOUCHES',
394+
'SPATIAL_ST_UNION',
395+
'SPATIAL_ST_WITHIN',
244396
],
245397
};

0 commit comments

Comments
 (0)