/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

1 vote119 views1 answer
Query for all indexes in table postgres
SQL
0 vote109 views1 answer
Bidirectional outer join sql
SQL
0 vote96 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
0 vote93 views1 answer
Mysql regex exact match
SQL
0 vote114 views1 answer
What is default mysql database password in linux
SQL
0 vote128 views1 answer
Sql quary stuf
SQL
0 vote100 views1 answer
Array aggre distinct postgres
SQL
24 votes93 views4 answers
Mssql get all table names
SQL
3 votes102 views2 answers
Postgres inner join vs join
SQL
5 votes99 views1 answer
Sql asynchronous stored procedure call
SQL