Register
Member Login
Forgot Password ??
PHP
,
ASP
,
ASP.NET, VB.NET, C#, Java
,
jQuery , Android , iOS , Windows Phone
Registered :
109,036
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
Share
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน
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 :
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
ปรับแต่งเว็บให้โหลดเร็ว
Hit Link
นำเข้าสินค้าจากจีน
Taobao
เฟอร์นิเจอร์
ของพรีเมี่ยม
ร่ม
ปากกา
power bank
แฟลชไดร์ฟ
กระบอกน้ำ
แลกเปลี่ยน Exchange Link
ลองค้นหาสิ่งที่ต้องการ
Load balance :
Server 00
© www.ThaiCreate.Com. 2003-2024 All Rights Reserved.
ไทยครีเอทบริการ จัดทำดูแลแก้ไข Web Application ทุกรูปแบบ (PHP, .Net Application, VB.Net, C#)
[
Conditions Privacy Statement
]
ติดต่อโฆษณา
081-987-6107
อัตราราคา
คลิกที่นี่
Inline