立即与支持人员聊天
与支持团队交流

SQL Optimizer for SAP ASE 3.9.1 - Release Notes

User-Defined Temp Tables Tutorial

When your SQL statement uses a temporary table, you must create a temporary table before you use the SQL statement in several modules. When you exit from the program or connect to another session, all the temporary tables you created are dropped.

Create Temporary Tables 

  1. Click image\B_UserDefinedTempTable.gif.

  2. On the Creation tab, type in the statements for creating the temp table. You may include CREATE, SELECT INTO, INSERT, UPDATE and DELETE statements.

  3. Click Execute.

 

Related Topic

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级