/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

0 vote275 views2 answers
Denormalization in sql
SQL
0 vote313 views1 answer
What is between operator
SQL
1 vote311 views1 answer
Sql injection
SQL
0 vote327 views1 answer
How to execute stored output to csv files
SQL
3 votes320 views4 answers
Mysql decimal
SQL
15 votes347 views4 answers
Mysql export database command line
SQL
4 votes326 views2 answers
Show all database inside postgresql
SQL
1 vote317 views1 answer
List index mysql cli
SQL
2 votes368 views1 answer
Where clause for child record apex
SQL
0 vote355 views1 answer
Sql select sum group by id laravel join
SQL