Question d’entretien chez ITC Infotech

what are the SQL locks resources and model how do you insert and updated at same time without using temp table,table variable,cte