Skip to content

Commit 61e2da4

Browse files
JerryFan626JerryFan626
committed
feat: Add SQLServer keywords and functions
1 parent 8588559 commit 61e2da4

2 files changed

Lines changed: 247 additions & 1 deletion

File tree

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

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2,5 +2,6 @@ import mysql from './mysql';
22
import oracle from './oracle';
33
import postgresql from './pgsql';
44
import redis from './redis';
5+
import sqlserver from './sqlserver'
56

6-
export default { mysql, oracle, postgresql, redis };
7+
export default { mysql, oracle, postgresql, redis, sqlserver };

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

Lines changed: 245 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,245 @@
1+
import { DatabaseTypeCode } from '../common';
2+
3+
export default {
4+
type: DatabaseTypeCode.SQLSERVER,
5+
keywords: [
6+
'ADD',
7+
'ALL',
8+
'ALTER',
9+
'AND',
10+
'ANY',
11+
'AS',
12+
'ASC',
13+
'AUTHORIZATION',
14+
'BACKUP',
15+
'BEGIN',
16+
'BETWEEN',
17+
'BREAK',
18+
'BROWSE',
19+
'BULK',
20+
'BY',
21+
'CASCADE',
22+
'CASE',
23+
'CHECK',
24+
'CLOSE',
25+
'CLUSTERED',
26+
'COALESCE',
27+
'COLLATE',
28+
'COLUMN',
29+
'COMMIT',
30+
'COMPUTE',
31+
'CONSTRAINT',
32+
'CONTAINS',
33+
'CONTAINSTABLE',
34+
'CONTINUE',
35+
'CONVERT',
36+
'CREATE',
37+
'CROSS',
38+
'CURRENT',
39+
'CURRENT_DATE',
40+
'CURRENT_TIME',
41+
'CURRENT_TIMESTAMP',
42+
'CURRENT_USER',
43+
'CURSOR',
44+
'DATABASE',
45+
'DBCC',
46+
'DEALLOCATE',
47+
'DECLARE',
48+
'DEFAULT',
49+
'DELETE',
50+
'DENY',
51+
'DESC',
52+
'DISK',
53+
'DISTINCT',
54+
'DISTRIBUTED',
55+
'DOUBLE',
56+
'DROP',
57+
'DUMP',
58+
'ELSE',
59+
'END',
60+
'ERRLVL',
61+
'ESCAPE',
62+
'EXCEPT',
63+
'EXEC',
64+
'EXECUTE',
65+
'EXISTS',
66+
'EXIT',
67+
'EXTERNAL',
68+
'FETCH',
69+
'FILE',
70+
'FILLFACTOR',
71+
'FOR',
72+
'FOREIGN',
73+
'FREETEXT',
74+
'FREETEXTTABLE',
75+
'FROM',
76+
'FULL',
77+
'FUNCTION',
78+
'GOTO',
79+
'GRANT',
80+
'GROUP',
81+
'HAVING',
82+
'HOLDLOCK',
83+
'IDENTITY',
84+
'IDENTITY_INSERT',
85+
'IDENTITYCOL',
86+
'IF',
87+
'IN',
88+
'INDEX',
89+
'INNER',
90+
'INSERT',
91+
'INTERSECT',
92+
'INTO',
93+
'IS',
94+
'JOIN',
95+
'KEY',
96+
'KILL',
97+
'LEFT',
98+
'LIKE',
99+
'LINENO',
100+
'LOAD',
101+
'MERGE',
102+
'NATIONAL',
103+
'NOCHECK',
104+
'NONCLUSTERED',
105+
'NOT',
106+
'NULL',
107+
'NULLIF',
108+
'OF',
109+
'OFF',
110+
'OFFSETS',
111+
'ON',
112+
'OPEN',
113+
'OPENDATASOURCE',
114+
'OPENQUERY',
115+
'OPENROWSET',
116+
'OPENXML',
117+
'OPTION',
118+
'OR',
119+
'ORDER',
120+
'OUTER',
121+
'OVER',
122+
'PERCENT',
123+
'PIVOT',
124+
'PLAN',
125+
'PRECISION',
126+
'PRIMARY',
127+
'PRINT',
128+
'PROC',
129+
'PROCEDURE',
130+
'PUBLIC',
131+
'RAISERROR',
132+
'READ',
133+
'READTEXT',
134+
'RECONFIGURE',
135+
'REFERENCES',
136+
'REPLICATION',
137+
'RESTORE',
138+
'RESTRICT',
139+
'RETURN',
140+
'REVERT',
141+
'REVOKE',
142+
'RIGHT',
143+
'ROLLBACK',
144+
'ROWCOUNT',
145+
'ROWGUIDCOL',
146+
'RULE',
147+
'SAVE',
148+
'SCHEMA',
149+
'SECURITYAUDIT',
150+
'SELECT',
151+
'SEMANTICKEYPHRASETABLE',
152+
'SEMANTICSIMILARITYDETAILSTABLE',
153+
'SEMANTICSIMILARITYTABLE',
154+
'SESSION_USER',
155+
'SET',
156+
'SETUSER',
157+
'SHUTDOWN',
158+
'SOME',
159+
'STATISTICS',
160+
'SYSTEM_USER',
161+
'TABLE',
162+
'TABLESAMPLE',
163+
'TEXTSIZE',
164+
'THEN',
165+
'TO',
166+
'TOP',
167+
'TRAN',
168+
'TRANSACTION',
169+
'TRIGGER',
170+
'TRUNCATE',
171+
'TRY_CONVERT',
172+
'TSEQUAL',
173+
'UNION',
174+
'UNIQUE',
175+
'UNPIVOT',
176+
'UPDATE',
177+
'UPDATETEXT',
178+
'USE',
179+
'USER',
180+
'VALUES',
181+
'VARYING',
182+
'VIEW',
183+
'WAITFOR',
184+
'WHEN',
185+
'WHERE',
186+
'WHILE',
187+
'WITH',
188+
'WRITETEXT',
189+
],
190+
functions: [
191+
'ABS',
192+
'AVG',
193+
'CAST',
194+
'CEILING',
195+
'COALESCE',
196+
'CONVERT',
197+
'COUNT',
198+
'CURRENT_TIMESTAMP',
199+
'DATALENGTH',
200+
'DATEADD',
201+
'DATEDIFF',
202+
'DATENAME',
203+
'DATEPART',
204+
'DAY',
205+
'GETDATE',
206+
'GETUTCDATE',
207+
'IDENT_CURRENT',
208+
'IDENT_INCR',
209+
'IDENT_SEED',
210+
'ISDATE',
211+
'ISNULL',
212+
'LEN',
213+
'LOWER',
214+
'LTRIM',
215+
'MAX',
216+
'MIN',
217+
'MONTH',
218+
'NEWID',
219+
'NULLIF',
220+
'PATINDEX',
221+
'RAND',
222+
'REPLACE',
223+
'REPLICATE',
224+
'REVERSE',
225+
'ROUND',
226+
'RTRIM',
227+
'SESSION_USER',
228+
'SPACE',
229+
'SQL_VARIANT_PROPERTY',
230+
'SQUARE',
231+
'SQRT',
232+
'STATS_DATE',
233+
'STDEV',
234+
'STDEVP',
235+
'STR',
236+
'STRING_AGG',
237+
'STRING_ESCAPE',
238+
'STRING_SPLIT',
239+
'SUBSTRING',
240+
'SUM',
241+
'SYSTEM_USER',
242+
'UPPER',
243+
'YEAR',
244+
],
245+
};

0 commit comments

Comments
 (0)