/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 vote195 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote180 views2 answers
Mysql output csv
SQL
0 vote186 views1 answer
Mysql locate
SQL
37 votes253 views6 answers
Mysql update
SQL
0 vote196 views1 answer
Insert using condition postgres
SQL
0 vote178 views2 answers
How to update the multiple rows in sql
SQL
0 vote172 views2 answers
MySQL top percent
SQL
1 vote185 views1 answer
Sql upsert
SQL
2 votes168 views2 answers
Insert all in sql
SQL
0 vote175 views1 answer
Sql server beginning of month
SQL