/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

5 votes204 views3 answers
Sql max value in column
SQL
0 vote247 views1 answer
Oracle swap partition
SQL
27 votes195 views5 answers
Add column in table
SQL
22 votes254 views4 answers
Date format mysql
SQL
0 vote214 views1 answer
Insert value in identity
SQL
0 vote217 views4 answers
Sql server date format yyyy-mm-dd
SQL
1 vote195 views1 answer
Mysql list bigger table
SQL
0 vote173 views1 answer
Count the table indatabase
SQL
0 vote190 views1 answer
Sqlite referential integrity
SQL
5 votes198 views3 answers
Postgres show databases
SQL