sql关键字
下面这此词都是T-SQL语句中的关键字,在你写SQL语句,存储过程,触发器或字段命名等时要避免使用这些词。
| ADD | EXIT | PRIMARY |
| ALL | FETCH | |
| ALTER | FILE | PRIVILEGES |
| AND | FILLFACTOR | PROC |
| ANY | FLOPPY | PROCEDURE |
| AS | FOR | PROCESSEXIT |
| ASC | FOREIGN | PUBLIC |
| AUTHORIZATION | FREETEXT | RAISERROR |
| AVG | FREETEXTTABLE | READ |
| BACKUP | FROM | READTEXT |
| BEGIN | FULL | RECONFIGURE |
| BETWEEN | GOTO | REFERENCES |
| BREAK | GRANT | REPEATABLE |
| BROWSE | GROUP | REPLICATION |
| BULK | HAVING | RESTORE |
| BY | HOLDLOCK | RESTRICT |
| CASCADE | IDENTITY | RETURN |
| CASE | IDENTITY_INSERT | REVOKE |
| CHECK | IDENTITYCOL | RIGHT |
| CHECKPOINT | IF | ROLLBACK |
| CLOSE | IN | ROWCOUNT |
| CLUSTERED | INDEX | ROWGUIDCOL |
| COALESCE | INNER | RULE |
| COLUMN | INSERT | SAVE |
| COMMIT | INTERSECT | SCHEMA |
| COMMITTED | INTO | SELECT |
| COMPUTE | IS | SERIALIZABLE |
| CONFIRM | ISOLATION | SESSION_USER |
| CONSTRAINT | JOIN | SET |
| CONTAINS | KEY | SETUSER |
| CONTAINSTABLE | KILL | SHUTDOWN |
| CONTINUE | LEFT | SOME |
| CONTROLROW | LEVEL | STATISTICS |
| CONVERT | LIKE | SUM |
| COUNT | LINENO | SYSTEM_USER |
| CREATE | LOAD | TABLE |
| CROSS | MAX | TAPE |
| CURRENT | MIN | TEMP |
| CURRENT_DATE | MIRROREXIT | TEMPORARY |
| CURRENT_TIME | NATIONAL | TEXTSIZE |
| CURRENT_TIMESTAMP | NOCHECK | THEN |
| CURRENT_USER | NONCLUSTERED | TO |
| CURSOR | NOT | TOP |
| DATABASE | NULL | TRAN |
| DBCC | NULLIF | TRANSACTION |
| DEALLOCATE | OF | TRIGGER |
| DECLARE | OFF | TRUNCATE |
| DEFAULT | OFFSETS | TSEQUAL |
| DELETE | ON | UNCOMMITTED |
| DENY | ONCE | UNION |
| DESC | ONLY | UNIQUE |
| DISK | OPEN | UPDATE |
| DISTINCT 消除重复项 | OPENDATASOURCE | UPDATETEXT |
| DISTRIBUTED | OPENQUERY | USE |
| DOUBLE | OPENROWSET | USER |
| DROP | OPTION | VALUES |
| DUMMY | OR | VARYING |
| DUMP | ORDER | VIEW |
| ELSE | OUTER | WAITFOR |
| END | OVER | WHEN |
| ERRLVL | PERCENT | WHERE |
| ERROREXIT | PERM | WHILE |
| ESCAPE | PERMANENT | WITH |
| EXCEPT | PIPE | WORK |
| EXEC | PLAN | WRITETEXT |
| EXECUTE | PRECISION | |
| EXISTS | PREPARE |

浙公网安备 33010602011771号