UPDATE查询无效 [英] UPDATE query not working

问题描述

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

以下是我的代码...

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 | 行号

这篇关于UPDATE查询无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！