自定义个函数
CREATE FUNCTION GetName (@submit_str varchar(128))
RETURNS varchar(128)
AS
BEGIN
declare @sub_info varchar(128)
set @sub_info='';
set @submit_str=@submit_str+',' ----------如果结尾没有 逗号 加上
declare @i int,@j int,@strnew varchar(1024) ,@num1 int,@num2 int ,@zz int,@outstr varchar(32)
set @outstr=''
set @i=1
set @num1=1
set @j=len(@submit_str)
set @zz=1
while @i<@j
begin
set @num1=charindex(',',@submit_str,@i)
set @strnew=substring(@submit_str,@i,@num1-@i)
set @outstr=(select [name] from b表 where [id]=@strnew)
set @sub_info=@sub_info+@strnew+','
set @i=@num1+1
set @zz=1
end
set @sub_info=substring(@sub_info,1,len(@sub_info)-1) ---------去掉最后的','
return (@sub_info)
END
------------------
执行
select dbo.getname(a表.字段) from a表