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;這個找不到哪里有錯誤，請大神指正。
2 回答
千巷貓影
TA貢獻1829條經驗 獲得超7個贊
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;
- 2 回答
- 0 關注
- 1272 瀏覽
添加回答
舉報
0/150
提交
取消