附近有语法错误（'

Question

我相信这个问题是近(旁边quoted price我得到的Incorrect syntax near '('一个语法错误。任何帮助，将不胜感激。使用Microsoft SQL-Server Management Studio中。

create view order_total as 

select order_num 

sum (quoted_price * num_ordered) as total_amount 

from order_line; 

Answer 1

在您的查询，你有没有分开你想用逗号返回列的SELECT语句一般语法要求他们：

create view order_total as 

SELECT order_num, 
     sum (quoted_price * num_ordered) AS total_amount 
FROM  order_line 
GROUP BY order_num; 

（一个好办法来阻止forgett荷兰国际集团逗号是通过将它们放置在该行的开始，而不是在他们的结束，具体如下：

SELECT column1 
     ,column2 
     ,etc. 
FROM table 

使得它也很简单，通过把--在该行的前面，而不可以快速地注释一柱而出您的查询中断。）