CREATE FUNCTION concatstr(@a varchar(12))
RETURNS varchar(300) AS
BEGIN
declare @return_input varchar(300),
@ssum varchar(300)
declare @len int
set @ssum = ''
set @return_input = ''
select @ssum = @ssum + b from t5 where a = @a
set @len = len(@ssum)
while (@len > 0) begin
set @len = @len - 1
set @return_input = @return_input + left(@ssum,1)
set @ssum = replace(@ssum,left(@ssum,1),'') --去掉與第一位相同的字符(delete)
set @ssum = ltrim(@ssum) --保証第一位不為‘ ’,而且' '不顯示
if @ssum = '' begin
break
end
end
return @return_input
END
MSSQL 自寫函數
最新推荐文章于 2021-03-27 21:11:26 发布