SQL IF ELSE

if not exists (select TOP(1) * from test_result_list where sub_cls_id ='C0000001-001' AND empno = '00000046')

insert into test_result_list (sub_cls_id,empno,is_pass,point) values('C0000001-001','00000046',0,12)

else

update test_result_list set sub_cls_id = 'C0000001-001',empno='00000046',is_pass=1,point=70 where sub_cls_id = 'C0000001-001' AND empno='00000046'