sysbase存储过程学习

CREATE PROCEDURE PROC_ACCOUNT
/* [ (@param_name datatype [= default] [output] ), ... ] */
(
    @in_code    varchar(30) in,
    @out_name   varchar(10)='AAA' output
)
AS
BEGIN
    /* declare statement */
    declare
    @bureauid int,
    @exist_flag int,
    @areacode_char varchar(1),
    @resultCode int,
    @resultDesc varchar(50)
   
    /* assign value statement */
    select @bureauid = -1, @exist_flag = 0
    select @resultCode = -1
   
    /* process statement */
    select T.ID, T.NAME, T.CODE, T.EMAIL from ACCOUNT T
   
    insert into ACCOUNT(ID, NAME, CODE, EMAIL) values(1, '22', '33', '44')
   
    select @out_name='test'
    commit
END