Answer Posted / Hemant Kumar Budakoti

In SAP HANA, INSERT, UPDATE, and MODIFY statements serve different purposes when working with data.

1) INSERT: This statement is used to add new rows into a table. The basic syntax for an INSERT statement is as follows:
INSERT INTO <table_name> (<column1>, <column2>, ..., <columnN>) VALUES (<value1>, <value2>, ..., <valueN>);

2) UPDATE: This statement modifies existing rows in a table. The basic syntax for an UPDATE statement is as follows:
UPDATE <table_name> SET <column_name1> = <new_value1>, <column_name2> = <new_value2>, ..., <column_nameN> = <new_valueN> WHERE <condition>;

3) MODIFY: This statement is used to change the data type or nullability of a column in an existing table. However, MODIFY is not supported in all scenarios and may have limitations based on the SAP HANA version and other factors.

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category