复制--将档案IDS的定义字符串转换成名字的网站模板字符串 ALTER FUNCTION GetArchivesNameStr(@SourceSql nvarchar(500),@StrSeprate nvarchar(10)) --字符串格式41,56,77, RETURNS nvarchar(500) AS begin declare @names nvarchar(500) declare @i int set @names= set @SourceSql=rtrim(ltrim(@SourceSql)) set @i=charindex(@StrSeprate,@SourceSql) while @i>=1 begin set @names=@names+(select name from Archives where ArchivesID=convert(int,left(@SourceSql,@i-1)))+, set @SourceSql=substring(@SourceSql,@i+1,len(@SourceSql)-@i) --已经转换好的IT技术网去掉 set @i=charindex(@StrSeprate,@SourceSql) --重新定位 end --return @names if @SourceSql<>and @i>=1 --最后一个 begin set @names=@names+(select name from Archives where ArchivesID=convert(int,left(@SourceSql,@i-1))) end if(right(@names,1)=,) --去掉后面的香港云服务器逗号 set @names=substring(@names,1,len(@names)-1) return @names end 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27. |
喜欢
讨厌