|
|
 |
专题栏目 |
 |
|
相关文章 |
|
|
|
|
|
 |
T-SQL关键字集锦 |
热 |
|
| T-SQL关键字集锦 |
|
作者：liujun999999 文章来源：不详 点击数： 更新时间：2007-11-14 12:55:58  |
|
下面这此词都是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
|
|
| 文章录入：mintao 责任编辑：mintao |
|
|
上一篇文章： SQL Server 2000游标使用方法
下一篇文章： SQL Server 2000的安全配置 |
|
|
| 【字体：小 大】【发表评论】【加入收藏】【告诉好友】【打印此文】【关闭窗口】 |
|
 注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] |
| 网友评论：（只显示最新10条。评论内容只代表网友观点，与本站立场无关！） |
| |
|
|
|
|
