在Sql Server 2008 R2中无法识别表 [英] Table does not get recognized in Sql Server 2008 r2

问题描述

大家好，
我已将SQL Server中的表从Project重命名为Order.
现在当我触发``select * from Order''时会给出错误-``Order附近的语法不正确''.

我正在使用sql server 2008 r2.

请帮忙.

Hello everyone,
I have renamed a table in sql server from Project to Order.
Now when I fire ''select * from Order'' it gives error - ''Incorrect syntax near Order'' .

I am using sql server 2008 r2.

Please help.

推荐答案

这是因为"Order"是保留字(在查询"order by"时使用).因此，您必须按照OriginalGriff所说的去做.放在[]周围.当您写保留字时，您将在tou查询编辑器中看到它.变成蓝色(至少默认情况下)

That is because "Order" is a reserved word (used when querying "order by"). So you have to do as OriginalGriff says. Put [] around it. You will see it in tou query editorwhen you write a reserved word. It turns blue (at least by default)

SELECT * FROM [Order]

以下是sql中所有保留字的列表: http://drupal.org/node/141051 [

Here is a list over all reserved words in sql: http://drupal.org/node/141051[^]

It''s a good practice to avoid naming your tables with names from this list..

简单:"ORDER"是SQL保留字.请不要将其用作表名(而是尝试使用"Orders"，表通常为复数形式)或将其括在方括号中:

Simple: "ORDER" is an SQL reserved word. Either don''t use it for your table name (try "Orders" instead, tables are normally plural) or enclose it in square brackets:

SELECT * FROM [Order]

这篇关于在Sql Server 2008 R2中无法识别表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！