1、首先需要打开sql server 数据库。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7a899e510fb30f2457e51dd9c695d143ac4b03e8?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、点击新建查询按钮,进入sql 执行界面。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0d338744ebf81a4c2c481813d92a6059242da6f6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、编写sql 更新语句,update tablename set name='更新' ,点击执行按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d1160924ab18972bda44f110e8cd7b899f510ae9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、使用查询语句,检查是否更新成功,select * from tablename。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b8014a90f603738d9d43fdf8bd1bb051f919ecdb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、上面的语句是对数据库进行批量更新,如果更新指定的信息可以在update 语句后面加上where语句update tablename set name='根据条件更新' where id=1 。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d4628535e5dde71127b9b22ca9efce1b9c166185?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、使用查询语句,检查是否更新成功,select * from tablename where id=1。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3b87e950352ac65c9e6f97a9f5f2b21192138a86?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)