/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 vote216 views1 answer
Group by max date
SQL
0 vote204 views1 answer
Postgres enumerated type
SQL
0 vote201 views2 answers
Create fulltext index mysql
SQL
0 vote247 views2 answers
Remove mysql workbench ubuntu
SQL
0 vote206 views1 answer
Drop all triggers oracle
SQL
1 vote213 views1 answer
Table infromation in sql server
SQL
5 votes206 views3 answers
Day of week postgresql
SQL
1 vote203 views1 answer
Declare variables sql
SQL
0 vote204 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote268 views1 answer
Drop view sql
SQL