|
|
|
|
T-SQL关键字集锦 |
|
|
|
作者：未知 来源：月光软件站 加入时间：2005-2-28 月光软件站 |
|
下面这此词都是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 |
|
| EXISTS |
PREPARE | 
|
|
相关文章：相关软件： |
|
本类阅读TOP10