SQLScript Table Variables (DECLARE ... TABLE LIKE)
Tutorials that teach this
- Tutorial Parallel Processing and Parameters
- Tutorial Using Index Based Cell Access
- Tutorial Parallel Processing and Parameters
- Tutorial Debugging Stored Procedures
- Tutorial Using Table Variable Operators
- Tutorial Use Index-Based Cell Access
- Tutorial Anonymous Blocks
- Tutorial Anonymous Blocks
- Tutorial Intermediate Table Variables
- Tutorial Intermediate Table Variables
- Tutorial Use Table Variable Operators
Prerequisites
Concepts that build on this
- Concept Scalar User Defined Functions (UDF) in SAP HANA
- Concept Index-Based Cell Access in SQLScript Table Variables
- Concept Table User Defined Functions in SAP HANA
- Concept SQL INNER JOIN for Combining Tables
- Concept SQL Aggregate Functions (COUNT, MAX, GROUP BY)
- Concept Creating SQLScript Stored Procedures in SAP HANA
- Concept SQLScript Table Functions in SAP HANA
- Concept SQLScript Table Variable Operators (INSERT, UPDATE, DELETE, SEARCH)
- Concept SQLScript User Defined Libraries
- Concept Defining Output Parameters in SQLScript Procedures
- Concept SQLScript Debugger in SAP HANA Database Explorer
- Concept SQLScript Anonymous Blocks (do begin...end)
- Concept Parallel Processing with Table Variables in SAP HANA SQLScript