WHAT IS THE USE AND DIFF B/W INSERT, UPDATE AND MODIFY
WHILE UPDATING THE DATABASE TABLES?
- 3 Answers
- 7145 Views
- Sony, I also Faced
- E-Mail Answers
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 is an interactive report? What is the obvious difference of such report compared with classical type reports?
dynamic programming in sap abap
wht is the diff. b/n initialization and lotus of event
How to write a bdc – how do you go about it?
What are the types of the software component being deployed in the sap?
Did you create any joins?
Difference between sap script and report?
What has to be done to the packed fields before submitting to a BDC session.
What are the attributes of the data? : abap data dictionary
What are the different types of the variable in the sap abap?
What is exception class and test class. How to use it?
Can i have some Realtime Scenarios on Reports.
What are the uses of the information in the data dictionary? : abap data dictionary
How do you get the number of lines in an internal table? How to use a specific number occurs statement?
How to display if the value entered contains records or not?
