如何替换SQL Server表列中的字符串 [英] How to replace a string in a SQL Server Table Column
本文介绍了如何替换SQL Server表列中的字符串的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个表(SQL服务器)引用路径(UNC或其他),但现在路径将改变。在路径列中,我有很多记录,我需要更改路径的一部分,但不是整个路径。
I have a table (SQL Sever) which references paths (UNC or otherwise), but now the path is going to change. In the path column, I have many records and I need to change just a portion of the path, but not the entire path. And I need to change the same string to the new one, in every record.
如何通过简单的更新来做到这一点?
How can I do this with a simple update?
推荐答案
这很容易:
update my_table
set path = replace(path, 'oldstring', 'newstring')
这篇关于如何替换SQL Server表列中的字符串的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文