Context - Here we will see one quite useful auto generated column in Hana table $rowid$ and its usages. $rowid$ - Returns the internal row ID value for each row of the table. Whenever any new row is inserted in a Hana table new unique numeric ID i...

Requirement – One of most common requirement in Hana is to move user defined table from one Hana environment to another (Ex: Dev > QA > Prod). Here is one of the method i.e. Export & Import we can use. Solution – Will migrate the Hana Table from S...

Requirement - Sometime we have to divide two numbers in Hana Sql or in Hana views. If denominator comes as 0 there is no logic implemented handle 0 in denominator then Hana will throw Divide by 0 error during Query execution. Also this is good pract...

Requirement - Many times working in Hana Modelling we have to use Stored Procedures to perform multiple DML operation on a single or multiple tables. One scenario is that in stored procedures we need to perform multiple DML operation (Insert\Update...

Requirement The requirement is to convert 12 hour format time into 24 hour format. We are saving Time in a column in 12 Hour format but in the output we need to show the time in 24 Hour format. Example below - Source Time Format Expected Output...