SAP HANA 技能[四] 存储过程

CREATE PROCEDURE {schema.}name {({IN|OUT|INOUT} 
                                 param_name data_type {,...})} 
      {LANGUAGE <LANG>} {SQL SECURITY <MODE>} 
      {READS SQL DATA {WITH RESULT VIEW <view_name>}} AS 
BEGIN 
  ... 
END

CREATE PROCEDURE schema.name(IN IN_START_YM NVARCHAR(6))
SQL SECURITY INVOKER
LANGUAGE SQLSCRIPT 
AS
BEGIN 
····
END

DROP PROCEDURE {schema.}name {CASCADE}

把你存储过程的内容复制到SQL控制台，然后修改你的存储过程内容，将创建时的'CREATE'改为'ALTER'，运行即可