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 |
how to create view in bdc..??
what is the significance of main window in a page, what are the types of windows? briefly explain the types of windows
SAP modifications and enhancements stored in which table?
Can we handle two transaction codes in the same program using call transaction bdc input method? : abap bdc
Suppose there is a secondary index on 4 non-key fields A,B,C & D. There are 3 select queries :- a) one on basis of A, B, C , D b) Second on basis of A, B, C c) Third on basis of D, C,B, A In which all situations , the above secondary index will be used?
Explain the disadvantage of using exec sql statement in abap?
What is Infotype and how it is different from tables
3 types of buffering techniqes. 1.bufering not allowed 2.buffering swithed on 3.buffering not allowed but switced on what does it means?
In Dialog Prog,i have created a screen and places one input/output box and named it was "A".In PBO i have given A=0 and In PAI A=1.when i run i program what i'll get and when i press enter(execute) wat i'll get output?
Where do you find info on new developments in SAP?
Difference between sy-tabix and sy-index? Can you check sy-subrc after perform?
what is table maitainance generator and how to create that? what is transaction code?