sql - msdn 主题中的此 UPDATE 表语句是否正确

Question

我在以下 msdn 主题中看到过这种类型的 UPDATE 语句(就像 insert 语句一样):

http://msdn.microsoft.com/en-us/library/aa0416cz.aspx#Y2461

更新声明:-

adapter.UpdateCommand = New SqlCommand("UPDATE Customers " &
  "(CustomerID, CompanyName) VALUES(@CustomerID, @CompanyName) " & _
  "WHERE CustomerID = @oldCustomerID AND CompanyName = " &
  "@oldCompanyName", connection)

这个说法正确与否？

我尝试执行它，但它给出了语法错误。

Answer 1

不，应该是:

UPDATE Customers
SET 
CustomerID = @CustomerID,
CompanyName = @CompanyName
WHERE
CustomerID = @oldCustomerID AND
CompanyName = @oldCompanyName

或者要完成示例代码，它应该是:

adapter.UpdateCommand = New SqlCommand("UPDATE Customers SET CustomerID = @CustomerID, CompanyName = @CompanyName WHERE CustomerID = @oldCustomerID AND CompanyName = @oldCompanyName", connection)

这是给您和这种情况的另一个引用:http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.updatecommand.aspx