ms sql update if exists else insert code example
Example: 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