SQLScript Table Variables and Intermediate Tables
Tutorials that teach this
- Tutorial Using Index Based Cell Access
- Tutorial Creating Table User Defined Functions
- Tutorial Use Table Variable Operators
- Tutorial Using Table Variable Operators
- Tutorial Intermediate Table Variables
- Tutorial Parallel Processing and Parameters
- Tutorial Use Index-Based Cell Access
- Tutorial Debugging Stored Procedures
- Tutorial Intermediate Table Variables
- Tutorial Parallel Processing and Parameters
- Tutorial Debugging Stored Procedures
Prerequisites
- Concept SQL JOIN Operations (INNER JOIN)
- Concept MTA Parallel Module Deployment
- Concept SQL Aggregate Functions (COUNT, MAX)
- Concept SQL Nested Queries and Subqueries
- Concept SAP HANA Stored Procedure Creation and Execution
- Concept SQLScript HANA Database Procedure
- Concept SAP HANA In-Memory Relational Database
Concepts that build on this
- Concept SQLScript Debugging with Breakpoints and Variable Inspection
- Concept MapReduce with SQLScript in SAP HANA
- Concept SAP HANA Graph Algorithms (Neighbors, Shortest Path)
- Concept CDS Table Functions
- Concept Parallel Processing in SAP HANA with SQLScript
- Concept SQLScript Index-Based Cell Access for Table Variables
- Concept SQLScript Scalar User-Defined Functions (UDFs)
- Concept SQLScript Table User-Defined Functions
- Concept SQLScript Table Variable Operators (INSERT, UPDATE, DELETE, SEARCH)
- Concept SAP HANA Performance Monitoring and Tuning
- Concept ABAP Parallel Processing
- Concept SQLScript Anonymous Blocks