/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 vote143 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote173 views1 answer
Mysql grant access to one database
SQL
0 vote125 views1 answer
Get number of tables in database sql
SQL
0 vote118 views2 answers
Mysql output csv
SQL
4 votes124 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote154 views1 answer
How to change the field size of an existing column
SQL
0 vote150 views1 answer
How much space does sql server take per row
SQL
0 vote119 views1 answer
Sql database connectivity
SQL
2 votes125 views1 answer
Mysql last 7 days including today
SQL
0 vote130 views1 answer
Merge clause with inner join
SQL