WHAT IS THE USE AND DIFF B/W INSERT, UPDATE AND MODIFY
WHILE UPDATING THE DATABASE TABLES?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / prasath
insert is used to insert new record,
update is used to update record in the table. if the record
doesn't found it will rise error message,
modify will modify the existing record. if the record not
found it will insert new record.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / mohamed hanifa. s
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 USED TO CHANGE THE TABLE SETTINGS LIKE DATA TYPE
OF THE COLUMN OR NAME OF THE COLUMN
Is This Answer Correct ? | 0 Yes | 4 No |
what are the Pre requisites for binary search?
How to decide whether we can use BDC (OR) LSMW for a given transaction?
if multiple badi can be active at a time, how will we know which implementation will be fired first . how to know the sequence in which implementation is fired.
Reports: Event functionality.
how many types of windows are there in SMARTFORMS?not in scripts?
When was the sap abap being created?
Difference between check table and value table.
3 Answers vCentric Technologies,
What is a function group?
field symbol work as a pointer,but it store address of value.my question is ,it got address from sap memory or abap memory or in database server ? i mean that address indicate to which memory ?
1 Answers Infosys, Tata Technologies, TCS,
Name the abap/4 modularization techniques?
Can we add a field to the sap standard screen? If so, how?
In Dialog Programming Table Control,how to make only one row editable?