Found 118 Articles for SQL

This can be created using following SQL query −CREATE USER TEST_122 PASSWORD Pass123$$

>Create View View_name as Select Col1,Col2 From Table_name;In the above SQL statement, you are creating a view that contains Col1 and Col2 from the table.Table Name − Emp_InfoExampleIdEmplNameEmpluserEmplpasswordJoining_Date1Employee 1Emp1Emp1Pwd9/11/20162 Employee 2Emp2 Emp2Pwd   16/08/20153Employee 3Emp3Emp3Pwd15/09/20164Employee 4Emp4   Emp4Pwd  3/07/20145Employee 5Emp5Emp5Pwd10/09/20126Employee 6Emp6  Emp6Pwd   1/10/2013                                                                                               To create a view, which contains only 3 columns you have to write->Create View View_EmpInfo As Select Id, EmplName,Joining_Date  From Emp_Info;This view can be used by users to get Id, EmplName, and Joining_date. 

You can achieve this by running the below SQL query −>CREATE USER TEST password “Welcome1$$”  VALID FROM ‘2017-12-05 11:00:00’ UNTIL ‘2018-12-08 12:00:00’; CREATE USER DUMMY password “Welcome1$$”  VALID FROM NOW UNTIL FOREVER;Note that password passed in this SQL should meet password policy of SAP HANA system otherwise user creation will be failed.

When a SQL query is executed, you can see the confirmation that the query is executed in time duration and also with server processing time. In this scenario, you can see the time taken by SAP HANA processor to create a new table in the HANA database as below −“Statement 'Create Table Demo_HANA ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) )' successfully executed in 3 ms 117 µs  (server processing time − 2 ms 458 µs) - Rows Affected − 0”

To run the query, click on green arrow button on top right corner  or press F8.

SAP HANA contains multiple components and it provides high computing power to HANA. Most important component of SAP HANA system is Index Server, which contains SQL/MDX processor to handle query statements for database.SAP HANA system also consists of Name Server, Preprocessor Server, Statistics Server and XS engine. XS engine is used to communicate and host small web applications and various other components on top of HANA database.

SAP HANA is not only a database but it is software and hardware innovation. You may get better result w.r.t Performance but HANA is not just a db with more memory.

New tables can be created using the two methods given below −Using SQL editorUsing GUI optionThe new table can be created using SQL Create Table statement –Create column Table Test1 (    ID INTEGER,    NAME VARCHAR(10),    PRIMARY KEY (ID) );When you run this SQL query, you get a message like this:The statement 'Create column Table Test1 ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) )' successfully executed in 5 ms 136 μs (server processing time: 4 ms 432 μs) - Rows Affected: 0To create a table using GUI, you need to right-click on any schema name -> New ... Read More

The following table lists all the key server components in HANA, the corresponding services, and OS process details.

In SAP HANA Modeling, Graphical Information Views are faster as compared to SQLScript in almost every scenario and also Graphical Information Views are easier for others to understand, remodel and change.There are scenarios where you need SQLScript, but it shouldn’t be viewed as a general-purpose solution to modeling problems.Note:It is never recommended that you code a Calculation View with SQL Script and use it inside another Calculation View with CE Functions as it results in a very bad performance.