In order for you to set up the logging framework, you will need help from your database administrator to set up the stored procedure logging directory and a user temporary table space.
为了构建这个日志框架,需要数据库管理员帮我们设置存储过程的日志目录并创建一个用户临时表空间。
A stored procedure P1 may declare a temporary table t, populate it, and wish to call procedures P2 and P3 to process the data.
存储过程P 1声明临时表t,填充它后并且希望调用过程P2和P 3来处理数据。
Use this option when atypical or temporary values are used in only a subset of queries belonging to the stored procedure.
请仅在属于存储过程的查询子集中使用非典型值或临时值时使用此选项。
Use the RECOMPILE query hint when atypical or temporary values are used in only a subset of queries that belong to the stored procedure.
如果非典型值或临时值仅用于属于存储过程的查询子集,则使用RECOMPILE查询提示。
The more usual way to do this would be to populate a temporary table with the values you need and then use the contents of that table from within the stored-procedure.
通常这种方法需要为这些数据创建一个临时表,然后在存储过程使用表中的内容。
I am importing Excel data in a stored procedure and storing the records in a temporary table.
我导入Excel数据在存储过程和临时表中存储的记录。
I am importing Excel data in a stored procedure and storing the records in a temporary table.
我导入Excel数据在存储过程和临时表中存储的记录。
应用推荐