Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

WHAT IS THE USE AND DIFF B/W INSERT, UPDATE AND MODIFY
WHILE UPDATING THE DATABASE TABLES?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the events we use in dialog programming and explain them?

1015


How do you control printer functions from sapscript?

1302


A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain.? : abap data dictionary

1181


In Table Field when display the Name, whose first charecter should be capital letter and rest will be small letter.

2041


Can you define a field without a data element?

948


What is the function of the transport system and workbench organiser?

1101


How would you set the formatting options statically and dynamically within a report?

1083


Explain the concept of clusters in payroll

2764


Define alv programming in abap?

1234


How do you find if a logical database exists for your program requrements?

1098


What is a view? : abap data dictionary

1092


What does an exec sql statement do in abap? What is the disadvantage of using it?

1240


What are the update types possible?

1102


What is the difference between rfc and bapi function modules? : abap bdc

1139


​​What is the symbol to do “concatenation” operation in​​ nw​​ abap​​ 7.4​​ ?

1363