帐号: 密码:
站内搜索: 订阅资讯
万民商业网—(wanminsyw.cn)来万民,知天下,论世事,长知识,看美图,发信息,乐逍遥!
设为首页 加入收藏
邮箱登陆 请您留言
 
您当前位置:网站首页 >> 电脑网络 >> 站长必读 >> 阅读文章

T-SQL语句关键字集锦

2011-09-19 13:01:27 来源:万民商业网 浏览:3745次


      下面这此词都是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

热点排行

查看:29554
查看:15497
查看:5606
查看:4900
查看:4447
查看:4076
查看:4069
查看:4052
查看:3921
查看:3902
查看:3886
查看:3756
查看:3745
查看:3536
查看:3524
查看:3517
查看:3487
查看:3376
查看:3344
查看:3278
查看:3255
查看:3014
查看:2880
查看:2871
查看:2725
查看:2717
查看:2705
查看:2676
查看:2639
查看:2621
关于我们 | 服务条款 | 免责声明及用户隐私制度 | 联系方式 | 鲁ICP备09074644号
联系邮箱:spzn_net@126.com,wanminw@126.com 在线QQ:852523998/332084348
Copyright 2009-2026, 版权所有 www.wanminw.com/wanminsyw/.
Powered by Ok3w 4.7 ASP+ACC to Html.
请使用IE8.0、360安全浏览器5.0正式版、firefox 10.0以上版本或Google Chrome浏览器进行浏览,分辨率设为1024X768效果更好!