Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS THE USE AND DIFF B/W INSERT, UPDATE AND MODIFY
WHILE UPDATING THE DATABASE TABLES?
- 3 Answers
- 8638 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 are the modes in which any update tasks work?
What are the techniques involved in using SAP supplied programs? Do you prefer to write your own programs to load master data? Why?
What are the types of search helps? : sap abap data dictionary
What are the different window types in sapscript?
Did you use buffering?
Static and instance variable and method with live example. Why and when to use
What is the reserve command?
how to update the filed value in SAP in ZAWSYS and create time and date? please tell me the answer
Fallback class
What is the sap abap?
What are the steps to execute session method?
What are the user interfaces of interactive lists?
how to track records from data dictionary?
Type casting and error handling
IN SCRIPTS IF WE HAVE EMPTY SECOND LAYOUT AND IF WE HAVE MENTIONED ABOUT IT IN NEXT PAGE ATTRIBUTE THEN IN OUTPUT HOW WE GET THE SECOND PAGE OUTPUT.
