ofrendo
3/31/2016 - 8:31 AM

SQLSCRIPT HANA: Sequence

SQLSCRIPT HANA: Sequence

-- https://help.sap.com/saphelp_hanaplatform/helpdata/en/20/d509277519101489029c064d468c5d/content.htm
CREATE SEQUENCE seq START WITH 1;  
SELECT seq.NEXTVAL FROM DUMMY; -- NEXTVAL returns 1.
SELECT seq.CURRVAL FROM DUMMY; -- CURRVAL returns 1.