>我有如下所示的字符串
Declare @string ='welcome'
我想要这样的输出
w
e
l
c
o
m
e
你可以为此使用计数表,通常比循环快,但你必须自己测试:
declare @s varchar(200)
set @s = 'Welcome'
;with t as (
select v
from (values(1),(1),(1),(1),(1),(1),(1),(1),(1),(1)) t(v)
),
n as (
select row_number() over(order by (select null)) rn
from t t1 cross join t t2
)
select substring(@s, rn, 1)
from n
where rn <= len(@s)
DECLARE @string VARCHAR(256) = 'welcome'
DECLARE @cnt INT = 0;
WHILE @cnt < len(@string)
BEGIN
SET @cnt = @cnt + 1;
PRINT SUBSTRING ( @string ,@cnt , 1 )
END;
实质上,您循环遍历字符串的长度。 在循环索引的位置打印字符并打印该字符。
您可以使用递归 CTE。
Declare @string varchar(10) ='welcome'
;with cte as
(
select 1 as i,substring(@string,1,1) as single_char
union all
select i+1 as i,convert(varchar(1),substring(@string,i+1,i+1)) as single_char from cte where len(convert(varchar(1),substring(@string,i+1,i+1)))=1
)
select single_char From cte