This page offers some tips for users that have experience with T-SQL (Microsoft SQL Server) and are switching to SAP HANA SQL.

• HANA database objects (tables, columns, etc.) are enclosed in double-quotes. Tables do not need to be but it is easier to do it for consistency.
• HANA database objects are case-sensitive. For example, “CardCode” is valid while “cardcode” would not be recognized.
• When dealing with null values, the HANA expression is IFNULL, not ISNULL. Otherwise the syntax is the same.
• HANA uses the function CURRENT_DATE instead of getdate().