Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
We can achieve this with the help of SHOW command. Firstly, I will use my database with the help of USE command −mysql> USE business; Database changedWe are in the “business” database now. After that, we can check that how many tables are available for this database. The query is as follows −mysql> SHOW tables; The following is the output+------------------------+ | Tables_in_business | +------------------------+ | addcolumntable | | autoincrement | | autoincrementtable | | bookindexes | | chardemo ... Read More
Redeploy option is available under SAP HANA Modeler Perspective −
This option is used for bulk activation of inactive objects in HANA repository. You have the following Activation modes −Stop activation incase of inconsistencies in affected objectsActivate and ignore the inconsistencies in affected objects
This option can be used to activate inactivate objects in SAP HANA Repository. When you click on Activate, you need to select HANA system.All inactive objects in your workplace are preselected for activation.You can remove or add objects for validation using these options −Add AllAddRemoveRemove All
SAP HANA also provides few of built-in tools which can be used for data provisioning in HANA database −Flat File Load (Import../Export.. option)Smart Data Streaming (This is available with HANA SPS09)Smart Data Access
Firstly, we need to create a table to understand the limit clause (as we want for SQL server).We will create a table with the help of CREATE command.Creating a tablemysql> CREATE table limitDemo -> ( -> id int, -> primary key(id) -> ); Query OK, 0 rows affected (0.58 sec)After that, let us insert records into the table −mysql> INSERT into limitDemo values(1); Query OK, 1 row affected (0.16 sec) mysql> INSERT into limitDemo values(2); Query OK, 1 row affected (0.12 sec) mysql> INSERT into limitDemo values(3); Query OK, 1 row affected (0.11 sec) mysql> INSERT into ... Read More
Following RFC connection types are available in SAP system −Connection Type 3 (ABAP Connection) This connection type is used to specify connection between ABAP systems. You need to mention the host name and IP address of source system and also the logon information. This is applicable for both type of RFCs, between ABAP systems and external calls to ABAP systems.Connection Type I (Internal Connections)This connection Type I indicates ABAP systems connected to the same database as current system. Type I entries are predefined and you can’t edit these entries.Connection Type L (Logical Destinations)The logical destination connection type indicates a physical destination. ... Read More
To understand whether a column exist or not, we have the following approaches −With the help of DESC commandUsing SHOW commandFirstly, we will create a table with columns −mysql> CREATE table ColumnExistDemo -> ( -> UniqueId int, -> UniqueName varchar(200), -> UniqueAddress varchar(200) -> ); Query OK, 0 rows affected (0.57 sec)In the first approach, we will get the entire column name with meaningful information. The syntax is as follows −DESC yourTableName; Let us apply the above query to check whether the column name exists or not. However, this approach is not good since it display all the columns.mysql> DESC ... Read More
A trusted RFC connection is used to define Remote Function Call (RFC Connection) between two systems. By creating a trusted RFC connection between two systems, it allows you to create a trusted-trusting relationship between systems wherein, you can communicate and exchange information and data.To create a new trusted RFC connection, you can use T-Code − SM59. There are different RFC connections supported as per requirement.Click on the 3rd icon to open a new connection wizard → click on Create button and a new window will open.
Yes, we can include a number for column name in MySQL. We need to use the symbol backtick, which is as follows( ` `)To understand, we will make a table with the help of CREATE command. Let us create a table −mysql> CREATE table NumberColumnDemo -> ( -> `123` varchar(100) -> ); Query OK, 0 rows affected (0.51 sec)Above, I have created a column name as a number with the help of backtick symbol.Now, we can check the same by inserting records with the help of INSERT command. Let us insert a record, which is as follows −mysql> INSERT into ... Read More