从sqlserver 2008中的列中删除一些单词 [英] remove some words from a column in sqlserver 2008

问题描述

您好，先生.

我在数据库中有一个图像路径，例如E:/BackUpWebsites/sri/images/........ jpg.

我想从每一行中删除(E:/BackUpWebsites/sri).
我的桌子上有100行.
我该怎么办?

任何人，请帮助我.

谢谢.

Hello sir.

I have an image path in database like E:/BackUpWebsites/sri/images/........jpg.

I want to remove (E:/BackUpWebsites/sri) from every row.
I have 100 rows in a table.
How can I do this?

Anybody, please help me.

Thanking you.

推荐答案

希望 ^ ]将给出一个想法.

Hope this[^] will give an idea.

使用

Use Replace[^]

UPDATE TableName SET ColumnName = (SELECT REPLACE(ColumnName,'E:/BackUpWebsites/sri','') FROM TableName)

您可以通过以下方式进行更新

You can update by the following way

UPDATE TableName SET [ColumnName] = REPLACE([ColumnName],'E:/BackUpWebsites/sri','') FROM TableName

致谢-感谢Ankur.

Acknowledgment - Thanks to Ankur.

DECLARE @path VARCHAR(256) -- path name
DECLARE db_cursor CURSOR FOR
SELECT ColunmName
FROM TableName
OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @path
WHILE @@FETCH_STATUS = 0
BEGIN
       SELECT REPLACE(@path,''E:/BackUpWebsites/sri'','''') FROM TableName
       FETCH NEXT FROM db_cursor INTO @path
END
CLOSE db_cursor
DEALLOCATE db_cursor

这篇关于从sqlserver 2008中的列中删除一些单词的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！