求教MySql函数问题: ?

Question

CREATE OR REPLACE FUNCTION FUN_GETBRNAME (pbrno varchar)returns varchar(80)begindeclare @pbrname varchar(80);set @pbrname = select br_name from TBL_ORG_DEPARTMENTS where br_no = pbrno;return @pbrname;end;这个找不到哪里有错误，请大神指正。

Answer 1

CREATE OR REPLACE FUNCTION FUN_GETBRNAME (pbrno varchar)
returns varchar(80)
begin
declare @pbrname varchar(80);
select br_name into @pbrname from TBL_ORG_DEPARTMENTS where br_no = pbrno;
return @pbrname;
end;

CREATE FUNCTION FUN_GETBRNAME (pbrno varchar(80))
    returns varchar(80)
 begin
   declare pbrname varchar(80);
    select br_name  into pbrname  from TBL_ORG_DEPARTMENTS where br_no = pbrno;
   return pbrname;
end;

Answer 2

这句错了，直接改成select @pbrname = br_name from TBL_ORG_DEPARTMENTS where br_no = pbrno;