VB.Net合并/更新查询不工作
问题描述:
我有两个SQL数据库表klaar和klaarvb,我想用下面的代码合并:VB.Net合并/更新查询不工作
Dim READER As SqlDataReader
Try
konneksie.Open()
Dim query As String
query = "MERGE blokkeklaar as target" & _
"USING blokkeklaarVB AS source" & _
"On target.Plaasblok = source.Plaasblok" & _
"WHEN MATCHED THEN" & _
"UPDATE SET klaarvb = source.klaarvb;"
COMMAND = New SqlCommand(query, konneksie)
READER = COMMAND.ExecuteReader
MessageBox.Show("Inligting vanaf blokkeklaarVB na blokkeklaar")
konneksie.Close()
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
End Try
我得到一个错误“blokkeklaarVB附近有语法错误”
当我运行在SQL管理语句我得到正确的结果:
MERGE blokkeklaar as target
USING blokkeklaarVB AS source
On target.Plaasblok = source.Plaasblok
WHEN MATCHED THEN
UPDATE SET klaarvb = source.klaarvb;
我想不通,我错过了什么。
Regards
答
在连接不同的行时,您在行续行之前缺少单词之间的空格。
query = "MERGE blokkeklaar as target " & _
"USING blokkeklaarVB AS source " & _
"On target.Plaasblok = source.Plaasblok " & _
"WHEN MATCHED THEN " & _
"UPDATE SET klaarvb = source.klaarvb;"
谢谢。发现。我正要回答我自己的问题。 – Gideon