如何使用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)asbegindeclare @char varchar(max)set @char = ''while (@number>0 )beginselect @char = @char+@keyset @number = @number -1endreturn @charend