There are some special keywords introduced here which are only used in case of a stored procedure. Let’s see which all keywords are used for what purpose. There are 3 types of the parameter being specified. IN                – used for input type parameter only. OUT              – used for output type parameter only. INOUT           – INOUT [...]

If there is anything lacking in SQL to make it a complete programming language, Stored Procedures fulfills the same. Stored Procedures are written in SQL and consist of a set of control and condition handling statements. These features provide a server-based procedural interface to the Teradata Database for application programmers. What does this mean? It [...]