sql - SQL Server 08 ')'附近的语法不正确

Question

尝试将以下值从Excel宏插入sql数据库

我收到以下错误消息“(()附近的语法不正确。

代码是...

Dim insert2 As String

insert2 = "INSERT INTO DETAIL" _
   & " ( plant, taskno, commentno, commentby, commenton, comment, nextactionby)   VALUES " _
   & " ( 'UK' ((SELECT max(taskno) AS count from HEADER),'1', '" & UserID & "', CONVERT(datetime, '" & Hdate & "' ,103), '" & Dcomment & "', '" & Dnextactionby & "')"

谁能解释为什么会这样？

Answer 1

您这里缺少逗号和一些不平衡的括号:

'UK' ((SELECT max(taskno) AS count from HEADER)
   ^ ^^                                       ^