82问答网 > 如何用sql server 2008选出列值中间某两个字符间的字符存到另一列；例取出http:

如何用sql server 2008选出列值中间某两个字符间的字符存到另一列；例取出http:

尀auto.163.com尀new尀10056.html中的auto.163.com尀new存到另一列去

2025-03-26 00:29:22

推荐回答（1个）

回答1：

create PROCEDURE UP_GETVALUE
AS
DECLARE @value VARCHAR(100), @tmp VARCHAR(100)
declare cursorA cursor for select KEYWORDS FROM
(SELECT '牛仔服' AS KEYWORDS UNION ALL SELECT '毛皮' UNION ALL SELECT '医药') AS aa
open cursorA
fetch next from cursorA into @tmp
SET @value = ''
while (@@fetch_status = 0)
BEGIN
SET @value = @value + @tmp + ' '
fetch next from cursorA into @tmp
END
SELECT rtrim(@value) AS keywords
close cursorA
deallocate cursorA
--测试
--EXEC up_getvalue

--结果

如何用sql server 2008选出 列值中间某两个字符间的字符存到另一列；例取出http:

如何用sql server 2008选出列值中间某两个字符间的字符存到另一列；例取出http: