/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 vote326 views2 answers
Changes not showing on website server odoo
SQL
39 votes401 views4 answers
Select duplicates in sql
SQL
3 votes319 views1 answer
Oracle user privileges
SQL
0 vote314 views2 answers
Mysql updating multiple column values from array variable
SQL
4 votes315 views1 answer
Create column mysql terminal
SQL
0 vote419 views1 answer
Run docker container with database as rds metabase
SQL
0 vote303 views1 answer
Sql roll up rows into columns
SQL
0 vote534 views1 answer
The differnece between to values in sql
SQL
1 vote307 views1 answer
Mysql date diff in seconds
SQL
0 vote327 views1 answer
Mysql utc timestamp
SQL