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

Explain what are the events used in interactive reports?

991


What will happen when we use fully buffered in abap?

1065


What is the difference between refresh and free statements?

1186


What is a data element?

951


How to get that a secondary index is attached to a select query?

1358


The commands through which an abap/4 module can “branch to “ or “call” the next screen are?

1150


How do you set up background jobs in sap? What are the steps? What are the events driven batch jobs?

1010


What is the use of at new statement ?

1793


Explain the sequences of event block?

1025


when u prefer lsmw?

1065


Which function module would you use to check the user’s authorization to access files before opening a file?

1054


Explain the differences between interactive and drill down reports?

1033


It is possible to assign a local data object defined in a subroutine or function module to a field group. State true or false. : abap modularization

1279


What are the different database integrities?

1047


How did you test the form you developed? How did you taken print?

1029