摘要:
-- run 1_datatype_data.sql before running this script ALTER SESSION SET CURRENT_SCHEMA = SqlScriptDocumentation; drop procedure dynamic_sql_proc; CREATE PROCEDURE dynamic_sql_proc LANGUAGE SQLSCR...
阅读全文
posted @ 2013-04-25 23:21
沧海-重庆
阅读(3200)
推荐(0)
编辑
摘要:
-- run 1_datatype_data.sql before running this script ALTER SESSION SET CURRENT_SCHEMA = SqlScriptDocumentation; drop procedure cursor_proc; CREATE PROCEDURE cursor_proc LANGUAGE SQLSCRIPT AS ...
阅读全文
posted @ 2013-04-25 23:20
沧海-重庆
阅读(4365)
推荐(0)
编辑
摘要:
-- run 1_datatype_data.sql before running this script ALTER SESSION SET CURRENT_SCHEMA = SqlScriptDocumentation; drop procedure while_proc; CREATE PROCEDURE while_proc LANGUAGE SQLSCRIPT AS ...
阅读全文
posted @ 2013-04-25 23:19
沧海-重庆
阅读(4360)
推荐(0)
编辑
摘要:
ALTER SESSION SET CURRENT_SCHEMA = SqlScriptDocumentation; DROP PROCEDURE addDiscount; CREATE PROCEDURE addDiscount( IN it_books tt_sales_books, OUT ot_books tt_sales_books) LANGUAGE SQLSCRI...
阅读全文
posted @ 2013-04-25 23:18
沧海-重庆
阅读(3507)
推荐(0)
编辑
摘要:
DROP SCHEMA SqlScriptDocumentation CASCADE; CREATE SCHEMA SqlScriptDocumentation; ALTER SESSION SET CURRENT_SCHEMA = SqlScriptDocumentation; --test data CREATE COLUMN TABLE publishers( pub_id IN...
阅读全文
posted @ 2013-04-25 23:17
沧海-重庆
阅读(2605)
推荐(0)
编辑
摘要:
SAP HANA中的用户是没有功能进行直接的拷贝的,但是我们可以通过建立存储过程调用,通过sql语句的方式进行拷贝: 存储过程定义如下,各位可根据自己的需求进行修改: CREATE PROCEDURE SYSTEM.COPY_USER (IN V_SOURCE_USER NVARCHAR(256), IN V_TARGET_USER NVARCHAR(256), IN V_TARGET_PWD ...
阅读全文
posted @ 2013-04-25 22:46
沧海-重庆
阅读(1292)
推荐(0)
编辑