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 internal tables? How to use a specific number occurs statement?
What are types of select statements?
Hi to all abap guru's my querry is as follows How to trigger the page break in smartforms forcibly ? and how to trigger the page break in the scripts forcibly ? means for every 10 records i have to trigger the page break ? and in smart form also ? thanks in advance
how is data transported from module to program?
Reuse-ALV-commentatory?
When you are in support, who will give you a Flat file or Excel file(Legacy Data) to upload into SAP System in day-to- day activity?
HOW DO YOU CONFIGURE ALE BETWEEN TWO DIFFERENT VERSIONS OF SAP ?
if there is no top-of-page event in reports then what happens?
how to download sap Smart form in text format
i have ztable for that i had created screen in that screen i had designed tablecontrol and save button calling ztable fields thorugh tablecontrol i have to insert the data in ztable if i press save button the data which i had enter in table control that should b save in ztable can any one send me the code for this for this. example is sm30 there we can directly insert the values directly in a single shot right?. urgent
list the important field symbol?
What is Smart Forms?