SQLScript Table Variables and Intermediate Tables
Tutorials that teach this
- TutorialIntermediate Table Variables
- TutorialUse Index-Based Cell Access
- TutorialParallel Processing and Parameters
- TutorialDebugging Stored Procedures
- TutorialUsing Index Based Cell Access
- TutorialDebugging Stored Procedures
- TutorialCreating Table User Defined Functions
- TutorialParallel Processing and Parameters
- TutorialUsing Table Variable Operators
- TutorialIntermediate Table Variables
- TutorialUse Table Variable Operators
Prerequisites
- ConceptSAP HANA Stored Procedure Creation and Execution
- ConceptSQL DDL and DML Statements (CREATE, INSERT, DROP)
- ConceptMTA Parallel Module Deployment
- ConceptSQL JOIN Operations (INNER JOIN)
- ConceptSQL Aggregate Functions (COUNT, MAX)
- ConceptSQL Nested Queries and Subqueries
- ConceptSAP HANA SQL API Usage
- ConceptSQLScript User Defined Libraries
- ConceptSAP HANA In-Memory Relational Database
- ConceptSQLScript HANA Database Procedure
Concepts that build on this
- ConceptParallel Processing in SAP HANA with SQLScript
- ConceptMapReduce with SQLScript in SAP HANA
- ConceptCDS Table Functions
- ConceptSQLScript Anonymous Blocks
- ConceptSQL JOIN Operations (INNER JOIN)
- ConceptSAP HANA Stored Procedure Creation and Execution
- ConceptSQLScript Table Variable Operators (INSERT, UPDATE, DELETE, SEARCH)
- ConceptSQLScript Index-Based Cell Access for Table Variables
- ConceptSQLScript Debugging with Breakpoints and Variable Inspection
- ConceptSQLScript Table User-Defined Functions
- ConceptSAP HANA Performance Monitoring and Tuning
- ConceptABAP Parallel Processing