I made organizing Stored Procedures into Chapters and Steps a principle. These separation points are marked by comments and variables ...

10 Reasons for Organizing Stored Procedure into Chapters and Steps

  Characteristics of Static SQL The SQL statement code cannot be changed during the Stored Procedure execution.Variables and parameters can ...

Teradata Stored Procedures – Dynamic or Static SQL

Introduction to Teradata Stored Procedures & Error Handling Error handlers in Teradata provide similar functionality to modern procedural languages (C++, ...

Teradata Stored Procedures Error Handling

What Is A Cursor In A Teradata SQL Stored Procedure? When we are talking about Cursors in Teradata SQL stored ...

Mistakes To Avoid When Using Cursors in Teradata Stored Procedures

Variable declarations in a Teradata Stored Procedure are always local to the surrounding compound statement (BEGIN…END) and to all the ...

Teradata Stored Procedures – Scope Of Variable Declarations

Teradata Partition Elimination – the Stored Procedure Approach Sometimes we need to select the rows from a table’s character column starting with a ...

Teradata Partition Elimination with Stored Procedures