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 you will doing the bypass by using select statment
How many ways you can create table? : abap data dictionary
Is a logical database a requirement/must to write an abap/4 query?
Select up to 1 row and select single difference ?
what is ment by view?how many types are there ?what are they?and what is the difference between data base view and projection view?
What is a transport?
What are dml commands in abap?
Different between Interface and Abstract classes?
A field containing quantity amounts (data type quan) must be assigned to a reference table and a reference field. Explain? : abap data dictionary
How to get the no of records using select statement?
what all we can see in TMG? what is its use?
What are the organizational related Infotypes