经常有人调试程序时,碰到一些关键字使用错误的提示。 下面这此词都是T-SQL语句中的关键字,在你写SQL语句,存储过程,触发器或字段命名等时要避免使用这些词。 | ADD | EXIT | PRIMARY | | ALL | FETCH | PRINT | | 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 | | [TR]EXISTS | PREPARE |
|