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;這個(gè)找不到哪里有錯(cuò)誤，請(qǐng)大神指正。
2 回答
千巷貓影
TA貢獻(xiàn)1829條經(jīng)驗(yàn) 獲得超7個(gè)贊
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;
呼啦一陣風(fēng)
TA貢獻(xiàn)1802條經(jīng)驗(yàn) 獲得超6個(gè)贊
這句錯(cuò)了，直接改成select @pbrname = br_name from TBL_ORG_DEPARTMENTS where br_no = pbrno;
- 2 回答
- 0 關(guān)注
- 1311 瀏覽
添加回答
舉報(bào)
0/150
提交
取消