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 |
VVVV.Urgent- How can i develop more than 30 interactive lists in reports.
what is the major advantage of start-form?
What is a badi?
How move-corresponding works
how can we print both side in smartforms?
How to handle errors in call transaction bdc method without using bdcmsgcoll internal table? : abap bdc
how to added data in list box?
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,
what next in SAP-ABAP/4 is it going to be change?
Did u create the script or u have only modified?how did u modified Medruck?did u came across any errors while modifying?after adding the logo wer did u store that?
Sales Order Information Report that lists information like sales order no, Item no, material no, Quantity, Quantity unit, Net value, Currency,Sub Total, Grand Total. plz mention the detail coding Tahnks, Rahul
Modes in Call Transaction?