一个函数老是出错。。。。
function dbo.fn_GetBZC_aa(@iYear smallint,@sSchool varchar(8000))
returns numeric(9,5)
as
begin
declare @nValue numeric(9,5)
if @sSchool='' or @sSchool is null
select @nValue=stdevp(tjxx.sg)
from jk_xstj_tjxx as tjxx inner join jk_xstj_xsjkk as xsjkk on tjxx.sfzh=xsjkk.sfzh
inner join jk_xstj_bjxx bjxx on tjxx.bjxx_id=bjxx.bjxx_id
where tjxx.tjnf=@iYear
else
select @nValue=stdevp(tjxx.sg)
from jk_xstj_tjxx as tjxx inner join jk_xstj_xsjkk as xsjkk on tjxx.sfzh=xsjkk.sfzh
inner join jk_xstj_bjxx bjxx on tjxx.bjxx_id=bjxx.bjxx_id
where tjxx.tjnf=@iYear and (bjxx.xxjbxx_id in (@sSchool))
return(@nValue)
END
在asp页面里调用,若@sSchool里有不只一个的学校就出错了。
传过来的学校用都号隔开:'222','3456','56777'
提示错误:函数参数不对
想用replace转换一下,去掉逗号,变成‘222’‘3456’‘56777’
然后在dbo.fn_GetBZC_aa函数里转换成:'222','3456','56777'
请问该如何实现???
期盼您!!!!!!