如何在sql server 2008中调用标量函数(how to call scalar function in sql server 2008)

我创建了一个标量函数，它已成功创建，但是当我使用select语句调用函数时，它说无效的对象名称为'dbo.fun_functional_score'。

我的功能：

ALTER function [dbo].[fun_functional_score] (@phy_id varchar(20)) returns varchar(50) as begin declare @level_initial int, @level_current int -- initial functional score set @level_initial=(SELECT pflag.fun_level FROM tbl_phy_demographic_details as [phy] inner join tbl_all_purple_flag_level as [pflag] on phy.Demographic_id=pflag.Id WHERE phy.Physicion_id=@phy_id and pflag.visited_count=(select MAX(visited_count)-1 from tbl_all_purple_flag_level )) -- current functional score set @level_current=(SELECT pflag.fun_level FROM tbl_phy_demographic_details as [phy] inner join tbl_all_purple_flag_level as [pflag] on phy.Demographic_id=pflag.Id WHERE phy.Physicion_id=@phy_id and pflag.visited_count=(select MAX(visited_count) from tbl_all_purple_flag_level )) --to calculate functional score declare @fun_level varchar(20),@result varchar(50) set @fun_level=@level_current-@level_initial; if @fun_level = 0 set @result='Maintained' if @fun_level = '-1' set @result='Minor Improvement' if @fun_level = '-2' set @result='Moderate Improvement' if @fun_level = '-3' set @result='Significant Improvement' if @fun_level = '-4' set @result='Substantial Improvement' if @fun_level = '1' set @result='Minor Reduction' if @fun_level = '2' set @result='Moderate Reduction' if @fun_level = '3' set @result='Significant Reduction' if @fun_level = '4' set @result='Substantial Reduction' return @result end

我用这个选择来呼叫

select * from dbo.fun_functional_score('01091400003') as [er]

要么

select * from dbo.fun_functional_score('01091400003')

都显示错误“无效的对象名称'dbo.fun_functional_score'”。

我犯了错误。谁能帮我...

I have created a Scalar Functions, it was created successfully, but when I call the function using select statement, it says Invalid object name 'dbo.fun_functional_score'.

my function:

ALTER function [dbo].[fun_functional_score] (@phy_id varchar(20)) returns varchar(50) as begin declare @level_initial int, @level_current int -- initial functional score set @level_initial=(SELECT pflag.fun_level FROM tbl_phy_demographic_details as [phy] inner join tbl_all_purple_flag_level as [pflag] on phy.Demographic_id=pflag.Id WHERE phy.Physicion_id=@phy_id and pflag.visited_count=(select MAX(visited_count)-1 from tbl_all_purple_flag_level )) -- current functional score set @level_current=(SELECT pflag.fun_level FROM tbl_phy_demographic_details as [phy] inner join tbl_all_purple_flag_level as [pflag] on phy.Demographic_id=pflag.Id WHERE phy.Physicion_id=@phy_id and pflag.visited_count=(select MAX(visited_count) from tbl_all_purple_flag_level )) --to calculate functional score declare @fun_level varchar(20),@result varchar(50) set @fun_level=@level_current-@level_initial; if @fun_level = 0 set @result='Maintained' if @fun_level = '-1' set @result='Minor Improvement' if @fun_level = '-2' set @result='Moderate Improvement' if @fun_level = '-3' set @result='Significant Improvement' if @fun_level = '-4' set @result='Substantial Improvement' if @fun_level = '1' set @result='Minor Reduction' if @fun_level = '2' set @result='Moderate Reduction' if @fun_level = '3' set @result='Significant Reduction' if @fun_level = '4' set @result='Substantial Reduction' return @result end

i used this select to call

select * from dbo.fun_functional_score('01091400003') as [er]

or

select * from dbo.fun_functional_score('01091400003')

both showing error "Invalid object name 'dbo.fun_functional_score'. "

where i made error . can anyone help me...