/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 vote270 views1 answer
Update one column from another column in same table
SQL
0 vote271 views1 answer
Enable Rabbitmq management plugin
SQL
0 vote285 views1 answer
Renommer base sql
SQL
0 vote274 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
1 vote279 views2 answers
Regex starts with
SQL
4 votes271 views1 answer
Add constraint fk
SQL
0 vote280 views1 answer
Sql select where more than one record exists
SQL
-1 vote259 views1 answer
Mysql coalesce
SQL
10 votes281 views1 answer
User_dependencies
SQL
3 votes287 views1 answer
Two select sql
SQL