/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 vote243 views2 answers
Full join sql
SQL
0 vote255 views1 answer
Pgadmin see indexes
SQL
1 vote279 views1 answer
Postgresql append array
SQL
2 votes277 views1 answer
Alter table add column and foreign key mysql
SQL
0 vote255 views1 answer
Get the previous column of a table in mysql
SQL
1 vote244 views1 answer
Column with prefix in sql
SQL
0 vote244 views2 answers
Postgresql create role
SQL
0 vote263 views2 answers
Mysql row_number() example
SQL
0 vote246 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
10 votes254 views4 answers
Join with multiple conditions sql
SQL