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
What are the events we use in dialog programming and explain them?
How do you control printer functions from sapscript?
A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain.? : abap data dictionary
In Table Field when display the Name, whose first charecter should be capital letter and rest will be small letter.
Can you define a field without a data element?
What is the function of the transport system and workbench organiser?
How would you set the formatting options statically and dynamically within a report?
Explain the concept of clusters in payroll
Define alv programming in abap?
How do you find if a logical database exists for your program requrements?
What is a view? : abap data dictionary
What does an exec sql statement do in abap? What is the disadvantage of using it?
What are the update types possible?
What is the difference between rfc and bapi function modules? : abap bdc
What is the symbol to do “concatenation” operation in nw abap 7.4 ?