This article is tagged with:
Sql server if exists update else insert
and mysql
sql server if exists update else insert
if exists(SELECT * from Student where FirstName='Akhil' and LastName='Mittal')           Â
BEGINÂ Â Â Â Â Â Â Â Â Â Â Â
 update Student set FirstName='Anu' where FirstName='Akhil' Â
End                   Â
else           Â
begin Â
insert into Student values(1,'Akhil','Mittal',28,'Male',2006,'Noida','Tenth','LFS','Delhi') Â
endÂ