ERROR DEBUGGING关键字'SELECT'附近的语法不正确。 [英] ERROR DEBUGGING incorrect syntax near the keyword '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屋！