can u please help me with this code in charp
in need to update bulk data .
if
t1.cola=t2.cola
t1.colb=t2.colb from tab1 t1 and tab2 t2
where t2. colc is not null
then,
set t1.colc=t2.colc
else
set t1.colc=t2.cold where t2.colc is null