/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

2 votes182 views2 answers
Null column to 0 in mysql
SQL
0 vote167 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote171 views1 answer
Sp help text in postgresql
SQL
0 vote105 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote133 views1 answer
Mysql with
SQL
26 votes150 views2 answers
Mysql workbench download
SQL
1 vote153 views1 answer
Postgres count string length
SQL
0 vote141 views1 answer
Mariadb current date plus 1 day
SQL
19 votes137 views5 answers
Date between in mysql
SQL
0 vote169 views1 answer
Add new column in sql with foreign key
SQL