/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 vote327 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote285 views1 answer
Narural join
SQL
39 votes351 views4 answers
Select duplicates in sql
SQL
0 vote269 views1 answer
Oracle last connection
SQL
0 vote301 views1 answer
Laravel migration sql dump
SQL
1 vote276 views1 answer
Tsql random number
SQL
1 vote313 views1 answer
Primary key with prefix sql
SQL
0 vote287 views1 answer
Table or view does not exist
SQL
8 votes432 views4 answers
Convert date to dd/mm/yyyy sql
SQL
1 vote268 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL