有一段查询返回一个table,用这个table的一个字段的值作为一个函数的参数传进去,看看每一个值传进去后这个函数的返回值是多少sql:
select tel from t1
innner join t2 on t2.NO = t1.NO
where t1.name is not nullfun:
FunAddress(
@tel varchar
)return varchar 怎样用一个脚本实现sql里的每一个tel 都执行一遍fun,并保留返回的结果集
select tel from t1
innner join t2 on t2.NO = t1.NO
where t1.name is not nullfun:
FunAddress(
@tel varchar
)return varchar 怎样用一个脚本实现sql里的每一个tel 都执行一遍fun,并保留返回的结果集
set @s=''
select @s=@s=','+tel --以","分隔值
from t1
innner join t2 on t2.NO = t1.NO
where t1.name is not null
set @s=stuff(@s,1,1,'')go
returns nvarchar(1000)
as
begin
declare @s nvarchar(1000)
set @s=''
select @s=@s=','+tel --以","分隔值
from t1
innner join t2 on t2.NO = t1.NO
where t1.name is not null and t1.No=@No
set @s=stuff(@s,1,1,'')
return @s
end
go
用函数以NO作为条件时这样用