/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 vote187 views1 answer
Inserting data into different tables at once in oracle sql
SQL
37 votes315 views3 answers
Sql check duplicate value in column
SQL
2 votes194 views1 answer
Delete all value query
SQL
2 votes216 views1 answer
Install postgresql centos 5
SQL
1 vote215 views1 answer
Select users with same username
SQL
0 vote199 views1 answer
My sql data file extention
SQL
0 vote182 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote199 views1 answer
Postgresql list extensions
SQL
1 vote229 views2 answers
Postgres select from last 3 months
SQL
3 votes193 views1 answer
Ms sql skip take
SQL