Sql 分割 键值对字符串 得到某值对应的名称
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER function [dbo].[GetStrOfIndex] ( @content varchar(1024), --要分割的字符串 @index varchar(500) --要获取的元素的值 ) returns varchar(1024) as begin declare @str varchar(500) if(charindex(@index,@content)<>0) begin declare @strname varchar(500) set @strname=substring(@content,charindex(@index,@content),len(@content)-charindex(@index,@content)+1) if(charindex(',',@strname)<>0) set @str= substring(@strname,charindex(':',@strname)+1,charindex(',',@strname)-charindex(':',@strname)-1) else set @str= substring(@strname,charindex(':',@strname)+1,len(@strname)-charindex(':',@strname)) end else set @str= @index return @str end
示例如下:
select dbo.GetStrOfIndex('1:普通员工,3:部门经理,6:常务副总,7:总经理,8:董事长','3')
返回值:
部门经理