Export (0) Print
Expand All
2 out of 6 rated this helpful - Rate this topic

Reserved Words

SQL Server 2000

A reserved word in Microsoft® SQL Server™ 2000 Windows® CE Edition (SQL Server CE) does not necessarily function the same way as the corresponding word in SQL Server 2000. The following table lists the reserved words used in SQL Server CE.

Important  Avoid using reserved words as identifiers. If reserved words must be used as identifiers, they must be delimited with double quotation marks.

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