正文部分
写个存储过程的吧,简单的写法如下:
drop procedure getTopUsers; create procedure getTopUsers (IN filter_cond NVARCHAR(200)) as begin vUsers = SELECT DISTINCT user_name, creator FROM USERS; if (:filter_cond is NULL) then TopUsers = select TOP 5 user_name FROM :vUsers; else tTopUsers = APPLY_FILTER(:vUsers, :filter_cond); TopUsers = SELECT TOP 5 user_name FROM :tTopUsers; end if; SELECT user_name FROM :TopUsers; end; call getTopUsers ('CREATOR != ''SYS'' '); call getTopUsers (NULL);
博客转移,点击进入:SAP HANA条件判断是NULL的写法
我在公众号里写了很多SAP的文章
有兴趣可以关注一下