UPDATE查询无效

问题描述:

我正在尝试创建更新查询,但它未能进行任何更改。

以下是我的代码...

I am trying to create an update query but it is failing to make any changes.
Below is the code I have...

展开 | 选择 | Wrap | 行号

有一种简单的方法可以解决数据库错误。使用try catch块包围代码。如果try中的代码没有成功执行,代码将落入catch块,为您提供问题的详细信息。


Nathan
There is an easy way to troubleshoot database errors. Surround your code with a try catch block. If the code in the try does not successfully execute the code will fall into the catch block giving you details of the problem.

Nathan


有您是否尝试在Management Studio中运行更新查询以查看它是否有效?


您的代码是否出错并导致异常?


博士B
Have you tried running your update query in Management Studio first to see whether it works?

Is your code erroring and causing an exception?

Dr B



有一种简单的方法来解决数据库错误。使用try catch块包围代码。如果try中的代码没有成功执行,代码将落入catch块,为您提供问题的详细信息。


Nathan
There is an easy way to troubleshoot database errors. Surround your code with a try catch block. If the code in the try does not successfully execute the code will fall into the catch block giving you details of the problem.

Nathan



我试过......

I tried...

展开 | 选择 | Wrap | / span> 行号