如何使用SQL写一个重复字符串一定次数的函数Repeat

Question

输入变量@word VARCHAR(20)@times INT输出变量VARCHAR(100)运行效果演示

Answer 1

CREATE function dbo.Repeat(@key as varchar(256),@number as int)
returns varchar(max)
as
begin
declare @char varchar(max)
set @char = ''
while (@number>0 )
begin
select @char = @char+@key
set @number = @number -1
end
return @char
end