/SQL/Sql server if exists update else insert

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

Source: c-sharpcorner.com

Similar codes

1 vote295 views2 answers
Mysql select tables with name like
SQL
0 vote303 views1 answer
Mysql min value row
SQL
4 votes302 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote325 views1 answer
Sql with example
SQL
1 vote292 views2 answers
Mysql error 1215
SQL
0 vote258 views1 answer
Get only first row mysql
SQL
0 vote318 views1 answer
Select true if exists on another table or false sqlserver
SQL
2 votes308 views1 answer
Set auto increment from 1
SQL
2 votes338 views2 answers
Create table mysql integer NOT null
SQL
7 votes301 views3 answers
Python and mysql connectivity
SQL