Q. What are different types of SQL Scripts? Q. What are advantages of SQL script? Ans. · SQL Script is executed and processed in the calculation engine within the HANA database. · SQL Script is able to perform complex calculations. · In SQL Script, a local variable can be declared to hold the interim result. · SQL Script Procedure can return more result by using "OUTPUT Parameter" while Normal SQL Procedure can return only one. · In SQL Script, you can define global or local tables types which can be used as parameters.
