WHAT IS THE USE AND DIFF B/W INSERT, UPDATE AND MODIFY
WHILE UPDATING THE DATABASE TABLES?
Answer Posted / sudhakar1207
INSERT IS USE TO INSERT THE RECORDS INTO A DB TABLE.
UPDATE IS USED TO CHANGE DATA OF THE EXISTING RECORDS IN THE DB TABLE.
MODIFY IS ALSO USED TO CHANGE DATA.
BUT THE MAIN DIFF B/W UPDATE AND MODIFY IS
UPDATE ONLY CHANGE THE EXISTING RECORD. IF THE RECORD DOES NOT EXIST IT WILL GIVE A SHORT DUMP.
MODIFY CHANGE THE DATA IF THE RECORD EXISTS, OTHERWISE IT WILL INSERT NEW RECORD.
| Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
Explain what are the events used in interactive reports?
What will happen when we use fully buffered in abap?
What is the difference between refresh and free statements?
What is a data element?
How to get that a secondary index is attached to a select query?
The commands through which an abap/4 module can “branch to “ or “call” the next screen are?
How do you set up background jobs in sap? What are the steps? What are the events driven batch jobs?
What is the use of at new statement ?
Explain the sequences of event block?
when u prefer lsmw?
Which function module would you use to check the user’s authorization to access files before opening a file?
Explain the differences between interactive and drill down reports?
It is possible to assign a local data object defined in a subroutine or function module to a field group. State true or false. : abap modularization
What are the different database integrities?
How did you test the form you developed? How did you taken print?