编写sql中的函数

CREATE     function fun_getBaseXm
 (
    @str varchar(50)
 )
returns varchar(50)

as
begin
  declare @xmbh varchar(50),@fbh varchar(50),@returnbh varchar(50);

  set @xmbh=@str
  set @fbh=@str
  set @returnbh=@str
  if len(@str)>0
  begin
 while exists(select 1 from tjjxmb where xmbh = @xmbh)
            
                 begin
       select @fbh=fbh from tjjxmb where xmbh = @xmbh
              set @returnbh=@xmbh;
                     set @xmbh=@fbh
                 end
 end
 return @returnbh

end

 

 

调用时，dbo.fun_getBaseXm(xmbh)  方法名前必须要加dbo