日期:2014-02-03 浏览次数:20632 次
Microsoft® SQL Server™ 2000 使用保留关键字定义、操作和访问数据库。保留关键字是 SQL Server 使用的 Transact-SQL 语言语法的一部分,用于分析和理解 Transact-SQL 语句和批处理。尽管在 Transact-SQL 脚本中,使用 SQL Server 保留关键字作为标识符和对象名在语法上是可行的,但规定只能使用分隔标识符。China It Power . Com9meWH
下表列出了 SQL Server 的保留关键字。China It Power . Com9meWH
| ADD | EXCEPT | PERCENT | 
| ALL | EXEC | PLAN | 
| ALTER | EXECUTE | PRECISION | 
| AND | EXISTS | PRIMARY | 
| ANY | EXIT | |
| 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 | 
| 
                    
                    
                     
                        免责声明: 本文仅代表作者个人观点,与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
                     
                    
                
                
            
            
            
    
        
   
 |