ERROR DEBUGGING关键字'SELECT'附近的语法不正确。 [英] ERROR DEBUGGING incorrect syntax near the keyword 'SELECT'.
本文介绍了ERROR DEBUGGING关键字'SELECT'附近的语法不正确。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
Msg 156,Level 15,State 1,Line 12
关键字'SELECT'附近的语法不正确。
请协助纠正
MS-SQL SERVER -2008
注意没有环绕T-SQL
Msg 156, Level 15, State 1, Line 12
Incorrect syntax near the keyword 'SELECT'.
Please assist to rectify
MS-SQL SERVER -2008
Note No Surround for T-SQL
DECLARE @Request AS TABLE (Req_ID VARCHAR (20),
R1 INT, R2 INT, R3 INT, R4 INT, R5 INT)
INSERT INTO @Request VALUES('R12673',2, 5, 3, 7, 10)
INSERT INTO @Request VALUES('R34721',3, 5, 2, 1, 8)
INSERT INTO @Request VALUES('R27835',1, 3, 8, 5, 6
SELECT Req_ID,
(SELECT AVG(c)
FROM (VALUES(R1),
(R2),
(R3),
(R4),
(R5)) T (c)) AS [Average]
FROM @Request
我是什么尝试过:
程序代码。需要帮助纠正程序段
What I have tried:
Program Codes. Needs help to correct the program segment
推荐答案
你错过了第5行的关闭括号
You're missing the close bracket on line 5
缺少关闭括号:
Missing close bracket:
INSERT INTO @Request VALUES('R27835',1, 3, 8, 5, 6
^
SELECT Req_ID,
这篇关于ERROR DEBUGGING关键字'SELECT'附近的语法不正确。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文