/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 vote174 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote165 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
3 votes159 views1 answer
Insert into table from another table mysql
SQL
3 votes182 views1 answer
Sql multi column index performance
SQL
3 votes183 views1 answer
Stpop start psql server
SQL
0 vote177 views2 answers
Collation in sql
SQL
25 votes175 views5 answers
Uninstall mysql ubuntu
SQL
10 votes170 views3 answers
Sql check double value
SQL
4 votes184 views3 answers
Postgres set default value
SQL
0 vote169 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL