Forgot Password ??

PHP , ASP , ASP.NET, VB.NET, C#, Java , jQuery , Android , iOS , Windows Phone

	Registered : 109,037

HOME > SQL Tutorial : สอน SQL รูปแบบคำสั่ง SQL และการใช้งานภาษา SQL ในรูปแบบต่าง ๆ > SQL SERVER RESERVED WORDS / Keywords

SQL SERVER RESERVED WORDS / Keywords

SQL SERVER RESERVED WORDS / Keywords
เป็นคำสงวนที่ห้ามใช้ ในฐานข้อมูล SQL Server 2000,2005 และ 2008 หรือสามารถใช้โดยการครอบด้วยเครื่องหมาย [wording]

Database : SQL Server 2000,2005 และ 2008 ,

Syntax

SELECT * FROM [order] ....

คำสงวนทั้งหมดที่แนะนำห้ามใช้

ADD	EXCEPT	PERCENT
ALL	EXEC	PLAN
ALTER	EXECUTE	PRECISION
AND	EXISTS	PRIMARY
ANY	EXIT	PRINT
AS	FETCH	PROC
ASC	FILE	PROCEDURE
AUTHORIZATION	FILLFACTOR	PUBLIC
BACKUP	FOR	RAISERROR
BEGIN	FOREIGN	READ
BETWEEN	FREETEXT	READTEXT
BREAK	FREETEXTTABLE	RECONFIGURE
BROWSE	FROM	REFERENCES
BULK	FULL	REPLICATION
BY	FUNCTION	RESTORE
CASCADE	GOTO	RESTRICT
CASE	GRANT	RETURN
CHECK	GROUP	REVOKE
CHECKPOINT	HAVING	RIGHT
CLOSE	HOLDLOCK	ROLLBACK
CLUSTERED	IDENTITY	ROWCOUNT
COALESCE	IDENTITY_INSERT	ROWGUIDCOL
COLLATE	IDENTITYCOL	RULE
COLUMN	IF	SAVE
COMMIT	IN	SCHEMA
COMPUTE	INDEX	SELECT
CONSTRAINT	INNER	SESSION_USER
CONTAINS	INSERT	SET
CONTAINSTABLE	INTERSECT	SETUSER
CONTINUE	INTO	SHUTDOWN
CONVERT	IS	SOME
CREATE	JOIN	STATISTICS
CROSS	KEY	SYSTEM_USER
CURRENT	KILL	TABLE
CURRENT_DATE	LEFT	TEXTSIZE
CURRENT_TIME	LIKE	THEN
CURRENT_TIMESTAMP	LINENO	TO
CURRENT_USER	LOAD	TOP
CURSOR	NATIONAL	TRAN
DATABASE	NOCHECK	TRANSACTION
DBCC	NONCLUSTERED	TRIGGER
DEALLOCATE	NOT	TRUNCATE
DECLARE	NULL	TSEQUAL
DEFAULT	NULLIF	UNION
DELETE	OF	UNIQUE
DENY	OFF	UPDATE
DESC	OFFSETS	UPDATETEXT
DISK	ON	USE
DISTINCT	OPEN	USER
DISTRIBUTED	OPENDATASOURCE	VALUES
DOUBLE	OPENQUERY	VARYING
DROP	OPENROWSET	VIEW
DUMMY	OPENXML	WAITFOR
DUMP	OPTION	WHEN
ELSE	OR	WHERE
END	ORDER	WHILE
ERRLVL	OUTER	WITH
ESCAPE	OVER	WRITETEXT

กรณีใช้ผ่าน Driver ODBC ควรหลีกเลี่ยงคำดังต่อไปใช้

ABSOLUTE	EXEC	OVERLAPS
ACTION	EXECUTE	PAD
ADA	EXISTS	PARTIAL
ADD	EXTERNAL	PASCAL
ALL	EXTRACT	POSITION
ALLOCATE	FALSE	PRECISION
ALTER	FETCH	PREPARE
AND	FIRST	PRESERVE
ANY	FLOAT	PRIMARY
ARE	FOR	PRIOR
AS	FOREIGN	PRIVILEGES
ASC	FORTRAN	PROCEDURE
ASSERTION	FOUND	PUBLIC
AT	FROM	READ
AUTHORIZATION	FULL	REAL
AVG	GET	REFERENCES
BEGIN	GLOBAL	RELATIVE
BETWEEN	GO	RESTRICT
BIT	GOTO	REVOKE
BIT_LENGTH	GRANT	RIGHT
BOTH	GROUP	ROLLBACK
BY	HAVING	ROWS
CASCADE	HOUR	SCHEMA
CASCADED	IDENTITY	SCROLL
CASE	IMMEDIATE	SECOND
CAST	IN	SECTION
CATALOG	INCLUDE	SELECT
CHAR	INDEX	SESSION
CHAR_LENGTH	INDICATOR	SESSION_USER
CHARACTER	INITIALLY	SET
CHARACTER_LENGTH	INNER	SIZE
CHECK	INPUT	SMALLINT
CLOSE	INSENSITIVE	SOME
COALESCE	INSERT	SPACE
COLLATE	INT	SQL
COLLATION	INTEGER	SQLCA
COLUMN	INTERSECT	SQLCODE
COMMIT	INTERVAL	SQLERROR
CONNECT	INTO	SQLSTATE
CONNECTION	IS	SQLWARNING
CONSTRAINT	ISOLATION	SUBSTRING
CONSTRAINTS	JOIN	SUM
CONTINUE	KEY	SYSTEM_USER
CONVERT	LANGUAGE	TABLE
CORRESPONDING	LAST	TEMPORARY
COUNT	LEADING	THEN
CREATE	LEFT	TIME
CROSS	LEVEL	TIMESTAMP
CURRENT	LIKE	TIMEZONE_HOUR
CURRENT_DATE	LOCAL	TIMEZONE_MINUTE
CURRENT_TIME	LOWER	TO
CURRENT_TIMESTAMP	MATCH	TRAILING
CURRENT_USER	MAX	TRANSACTION
CURSOR	MIN	TRANSLATE
DATE	MINUTE	TRANSLATION
DAY	MODULE	TRIM
DEALLOCATE	MONTH	TRUE
DEC	NAMES	UNION
DECIMAL	NATIONAL	UNIQUE
DECLARE	NATURAL	UNKNOWN
DEFAULT	NCHAR	UPDATE
DEFERRABLE	NEXT	UPPER
DEFERRED	NO	USAGE
DELETE	NONE	USER
DESC	NOT	USING
DESCRIBE	NULL	VALUE
DESCRIPTOR	NULLIF	VALUES
DIAGNOSTICS	NUMERIC	VARCHAR
DISCONNECT	OCTET_LENGTH	VARYING
DISTINCT	OF	VIEW
DOMAIN	ON	WHEN
DOUBLE	ONLY	WHENEVER
DROP	OPEN	WHERE
ELSE	OPTION	WITH
END	OR	WORK
END-EXEC	ORDER	WRITE
ESCAPE	OUTER	YEAR
EXCEPT	OUTPUT	ZONE
EXCEPTION

ฟีเจอร์ในอนาคต ทีคาดว่าจะมีในรุ่นถัด ๆ ไป ควรหลีกเลี่ยงคำดังต่อไปใช้

ABSOLUTE	FOUND	PRESERVE
ACTION	FREE	PRIOR
ADMIN	GENERAL	PRIVILEGES
AFTER	GET	READS
AGGREGATE	GLOBAL	REAL
ALIAS	GO	RECURSIVE
ALLOCATE	GROUPING	REF
ARE	HOST	REFERENCING
ARRAY	HOUR	RELATIVE
ASSERTION	IGNORE	RESULT
AT	IMMEDIATE	RETURNS
BEFORE	INDICATOR	ROLE
BINARY	INITIALIZE	ROLLUP
BIT	INITIALLY	ROUTINE
BLOB	INOUT	ROW
BOOLEAN	INPUT	ROWS
BOTH	INT	SAVEPOINT
BREADTH	INTEGER	SCROLL
CALL	INTERVAL	SCOPE
CASCADED	ISOLATION	SEARCH
CAST	ITERATE	SECOND
CATALOG	LANGUAGE	SECTION
CHAR	LARGE	SEQUENCE
CHARACTER	LAST	SESSION
CLASS	LATERAL	SETS
CLOB	LEADING	SIZE
COLLATION	LESS	SMALLINT
COMPLETION	LEVEL	SPACE
CONNECT	LIMIT	SPECIFIC
CONNECTION	LOCAL	SPECIFICTYPE
CONSTRAINTS	LOCALTIME	SQL
CONSTRUCTOR	LOCALTIMESTAMP	SQLEXCEPTION
CORRESPONDING	LOCATOR	SQLSTATE
CUBE	MAP	SQLWARNING
CURRENT_PATH	MATCH	START
CURRENT_ROLE	MINUTE	STATE
CYCLE	MODIFIES	STATEMENT
DATA	MODIFY	STATIC
DATE	MODULE	STRUCTURE
DAY	MONTH	TEMPORARY
DEC	NAMES	TERMINATE
DECIMAL	NATURAL	THAN
DEFERRABLE	NCHAR	TIME
DEFERRED	NCLOB	TIMESTAMP
DEPTH	NEW	TIMEZONE_HOUR
DEREF	NEXT	TIMEZONE_MINUTE
DESCRIBE	NO	TRAILING
DESCRIPTOR	NONE	TRANSLATION
DESTROY	NUMERIC	TREAT
DESTRUCTOR	OBJECT	TRUE
DETERMINISTIC	OLD	UNDER
DICTIONARY	ONLY	UNKNOWN
DIAGNOSTICS	OPERATION	UNNEST
DISCONNECT	ORDINALITY	USAGE
DOMAIN	OUT	USING
DYNAMIC	OUTPUT	VALUE
EACH	PAD	VARCHAR
END-EXEC	PARAMETER	VARIABLE
EQUALS	PARAMETERS	WHENEVER
EVERY	PARTIAL	WITHOUT
EXCEPTION	PATH	WORK
EXTERNAL	POSTFIX	WRITE
FALSE	PREFIX	YEAR
FIRST	PREORDER	ZONE
FLOAT	PREPARE

ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน Source Code 2.0 ของทีมงานไทยครีเอท

ลองใช้ค้นหาข้อมูล


	By :	ThaiCreate.Com Team (บทความเป็นลิขสิทธิ์ของเว็บไทยครีเอทห้ามนำเผยแพร่ ณ เว็บไซต์อื่น ๆ)
	Score Rating :
	Create/Update Date :	2011-06-06 21:00:45 / 2011-06-06 21:09:21
	Download :	No files

Sponsored Links / Related

SQL Database & Table
Rating :

SQL SELECT
Rating :

SQL WHERE
Rating :

SQL ALIAS
Rating :

SQL OR AND
Rating :

SQL ORDER BY
Rating :

SQL SUB SELECT QUERY
Rating :

SQL SELECT INTO
Rating :

SQL BETWEEN
Rating :

SQL JOIN
Rating :

SQL OUTER JOIN
Rating :

SQL RIGHT JOIN
Rating :

SQL LEFT JOIN
Rating :

SQL UNION
Rating :

SQL DISTINCT
Rating :

SQL TOP
Rating :

SQL LIMIT
Rating :

SQL ROWNUM
Rating :

SQL RAND
Rating :

SQL LIKE
Rating :

SQL NOT LIKE
Rating :

SQL INSERT
Rating :

SQL UPDATE
Rating :

SQL INSERT ... SELECT
Rating :

SQL DELETE
Rating :

SQL IN
Rating :

SQL NOT IN
Rating :

SQL GROUP BY
Rating :

SQL HAVING
Rating :

SQL COUNT
Rating :

SQL MAX
Rating :

SQL MIN
Rating :

SQL REPLACE
Rating :

SQL SUM
Rating :

SQL AVG
Rating :

SQL CONCAT
Rating :

SQL LENGTH
Rating :

SQL TRIM
Rating :

SQL SUBSTRING
Rating :

SQL TRUNCATE,DROP
Rating :

SQL INSERT DUPLICATE KEY UPDATE
Rating :

SQL COPY TABLE
Rating :

SQL CREATE TABLE
Rating :

SQL PRIMARY KEYS
Rating :

SQL CREATE INDEX
Rating :

SQL UNIQUE
Rating :

SQL AUTO_INCREMENT For MySQL
Rating :

SQL AUTO_INCREMENT/IDENTITY For SQL SERVER
Rating :

SQL AUTO_INCREMENT For ORACLE
Rating :

SQL INSERT INTO...SET
Rating :

SQL SERVER ROW_NUMBER()
Rating :

SQL Server 2005,2008 Full-Text Search
Rating :

SQL CREATE DATABSE
Rating :

SQL CASE..WHEN
Rating :

SQL NULL / ISNULL
Rating :

SQL CASCADE ONUPDATE/ONDELETE
Rating :

SQL FIRST
Rating :

SQL EXISTS
Rating :

SQL ALTER
Rating :

SQL DROP
Rating :

SQL UNION ALL
Rating :

SQL AS
Rating :

SQL LAST
Rating :

SQL MYSQL IF
Rating :

SQL DATE , DAY , MONTH , YEAR
Rating :

SQL MYSQL DATE_FORMAT
Rating :

SQL MYSQL DATE_ADD()
Rating :

SQL MYSQL DATEDIFF()
Rating :

SQL MID
Rating :

SQL UCASE , UPPER
Rating :

SQL LCASE , LOWER
Rating :

SQL LEN
Rating :

SQL ROUND
Rating :

SQL NOW()
Rating :

SQL GETDATE()
Rating :

SQL SYSDATE()
Rating :

SQL REPAIR TABLE
Rating :

SQL USE
Rating :

SQL RENAME TABLE
Rating :

SQL RENAME DATABASE
Rating :

SQL ORACLE IMP (Import Database)
Rating :

SQL ORACLE EXP (Export Database)
Rating :

SQL OPTIMIZE TABLE
Rating :

SQL CONVERT
Rating :

SQL GROUP_CONCAT
Rating :

SQL MYSQL RESERVED WORDS
Rating :

SQL ORACLE RESERVED WORDS / Keywords
Rating :

MS ACCESS RESERVED WORDS / Keywords
Rating :

MYSQL ROUND
Rating :

MYSQL FLOOR
Rating :

MYSQL CEILING
Rating :

MYSQL ABS()
Rating :

MYSQL MIN() , LEAST() , MAX() ,GREATEST()
Rating :

MYSQL MOD()
Rating :

MYSQL POW() , POWER()
Rating :

MYSQL RAND()
Rating :

MYSQL SQRT()
Rating :

MYSQL TRUNCATE() Mathematical
Rating :

MYSQL CONCAT()
Rating :

MYSQL CONCAT_WS()
Rating :

MYSQL LOWER() , LCASE() , UCASE() , UPPER()
Rating :

MYSQL TRIM() , LTRIM() , RTRIM()
Rating :

MYSQL MID() , LEFT() , RIGHT() , SUBSTRING(), SUBSTR()
Rating :

MYSQL REPLACE()
Rating :

MYSQL RPAD() , LPAD()
Rating :

MYSQL FORMAT()
Rating :

MYSQL INSERT() String Function
Rating :

MYSQL INSTR()
Rating :

MYSQL REPEAT()
Rating :

MYSQL REVERSE()
Rating :

MYSQL DAYOFWEEK()
Rating :

MYSQL WEEKDAY()
Rating :

MYSQL DAYOFMONTH()
Rating :

MYSQL DAYOFYEAR()
Rating :

MYSQL DAYNAME()
Rating :

MYSQL MONTHNAME()
Rating :

MYSQL QUARTER()
Rating :

MYSQL YEARWEEK()
Rating :

MYSQL DAY() , MONTH() , YEAR(), HOUR(), MINUTE(), SECOND()
Rating :

MYSQL DATE_ADD() , DATE_SUB()
Rating :

MYSQL ADDDATE()
Rating :

MYSQL ADDTIME()
Rating :

MYSQL SUBDATE()
Rating :

MYSQL TIME_FORMAT()
Rating :

MYSQL CURDATE() , CURRENT_DATE() , CURTIME() , CURRENT_TIME() , NOW() , SYSDATE()
Rating :

MYSQL LAST_DAY()
Rating :

MYSQL WEEK()
Rating :

MYSQL Full-Text Search
Rating :

SQL SERVER CONCAT()
Rating :

MYSQL FIND_IN_SET()
Rating :

SQL JOIN/SUB QUERY
Rating :

สอน Windows Phone การเขียนโปรแกรม Windows Phone 7 และ 8

สอน Java GUI การเขียนโปรแกรม ภาษา Java GUI

Free Tutorial

	สอน Google Maps Api
	สอน Windows Service
	สอน Entity Framework
	สอน Android
	สอน Java เขียน Java
	Java GUI Swing
	สอน JSP (Web App)
	iOS (iPhone,iPad)
	Windows Phone
	Windows Azure
	Windows Store
	Laravel Framework
	Yii PHP Framework
	สอน jQuery
	สอน jQuery กับ Ajax
	สอน PHP OOP (Vdo)
	Ajax Tutorials
	SQL Tutorials
	สอน SQL (Part 2)
	JavaScript Tutorial
	Javascript Tips
	VBScript Tutorial
	VBScript Validation
	Microsoft Access
	MySQL Tutorials
	-- Stored Procedure
	MariaDB Database
	SQL Server Tutorial
	SQL Server 2005
	SQL Server 2008
	SQL Server 2012
	-- Stored Procedure
	Oracle Database
	-- Stored Procedure
	SVN (Subversion)
	แนวทางการทำ SEO
	ปรับแต่งเว็บให้โหลดเร็ว