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’s a “insert or update” and “update or insert”, how do we find the difference?



What’s a “insert or update” and “update or insert”, how do we find the..

Answer / Gautam Kishor

In SQL, an 'Insert or Update' operation attempts to insert a new record if it does not exist, and updates it if the record already exists. On the other hand, an 'Update or Insert' operation tries to update the existing record if it exists; otherwise, it inserts a new one. The main difference lies in the order of operations.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Talend Interview Questions

How can we schedule a job in Talend?

1 Answers  


What’s a “insert or update” and “update or insert”, how do we find the difference?

1 Answers  


What is the most current version of talend open studio?

1 Answers  


What is tmap component?

1 Answers  


Define the use of ‘Outline View’ in Talend Open Studio.

1 Answers  


How to create a Hadoop cluster in Talend?

1 Answers  


which command is used to check running jobs in server?

1 Answers  


Why is talend called a code generator?

1 Answers  


How to execute a Talend Job remotely?

1 Answers  


How does one deploy talend projects?

1 Answers  


How to perform aggregate operations/functions on data in talend?

1 Answers  


What are the operations which tmap follow?

1 Answers  


Categories