Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
MySQL Articles
Page 355 of 355
How OLD and NEW keywords enable us to access columns in row affected byna trigger?
As we know that in trigger definition, we can refer to columns of the row being inserted, updated or deleted. Following are the ways OLD and NEW keywords enable us to access columns − We must have to prefix the column name with a qualifier of OLD to refer to a value from the original row. We must have to prefix the column name with a qualifier of NEW to refer to a value in the new row. Now, the use of OLD and NEW must be done appropriately because the triggering event Determines which of them are ...
Read MoreHow can we create a MySQL view with GROUP BY clause?
We can use GROUP BY to group values from a column, and, if we want, we can perform calculations on that column. You can use COUNT, SUM, AVG, etc., functions on the grouped column. To understand GROUP BY clause with views we are creating a view named ‘Info’ using the base table ‘Student_info’ having the following data − mysql> Select * from Student_info; +------+---------+------------+------------+ | id | Name | Address | Subject | +------+---------+------------+------------+ | 101 | YashPal | Amritsar | History ...
Read MoreCondition Variables within Sub-Query in SAP
One line answer - Sub-Queries are not allowed. But if you need to handle your scenario, then you can do the following: Encapsulate your entire query into a stored procedure and then use the stored procedure. Create a view. The view is created to handle either your main query or sub-query. Create a table level variable and store the end results of view in it and then go ahead and fetch the value of table variable in the main query.
Read MoreUsing memory analyzer in SAP
There are lots of free and proprietary tools to do the same. You can use Memory Analyzer project done by SAP. It lets you find memory leaks against in-memory objects via simple SQL statements. Also, you can use JHAT (Java Heap Analysis tool) command line tool to examine the memory. It lets you examine heap memory via histogram and can be of good help. Also, you can go for HeapWalker from Netbeans or Visual VM. Also, Eclipse has Eclipse memory analyzer which is a freeware and can handle good size with dump and provides a fair deal of memory analysis.
Read MoreHow to use SUM function for NUMC type field?
NUMC is numeric text. As this is text, SUM function cannot be implemented as it is of type varchar in the database.There is no simple solution to do it. The one method is to copy the data to internal tables, convert the NUMC data into DEC by looping through all the rows, SUM and GROUP them and then convert back the DEC values back to NUMC values.
Read MoreIn SAP Business One SDK, filling a gridview and button saves in database
This can be achieved in multiple ways. You can either use a SAP DI documents, an open SQL or use data transfer workbench for this purpose.You can use a direct SQL write as this is one of straight way to do this. It is also possible to use SAP-DI Documents object to iterate over the Purchase Orders.One more option is using Data Transfer Workbench (DTW), where you export it to a file and then using DTW. It also provides error handling incase any exception occurs.
Read MoreCan't create a Dictionary Object: View by adding two db tables
When you create a view, it is created on top of multiple database tables using an inner join. Note that basis table of database views should be transparent tables.To create a view on 2 tables, you have to enter the primary table you want to maintain and place the cursor in that field and click on the button below the list of tables and select the other table to add the view. If you are not getting this option, it means Relationship is wrong.To know more about database Views: https://help.sap.com/doc/abapdocu_750_index_htm/7.50/en-US/abenddic_database_views.htm
Read More