sysbase存储过程学习

最新推荐文章于 2021-04-09 06:15:12 发布

lishushan

最新推荐文章于 2021-04-09 06:15:12 发布

阅读量148

点赞数

分类专栏： sysbase

本文链接：https://blog.csdn.net/lishushan/article/details/83709141

版权

sysbase 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

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