/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 vote256 views1 answer
Java sql timestamp now
SQL
0 vote234 views1 answer
Oracle select partition
SQL
0 vote236 views1 answer
Sql server check whether column has same equal values
SQL
0 vote184 views1 answer
Deleted table in sql trigger
SQL
12 votes225 views4 answers
Mysql version query
SQL
1 vote244 views1 answer
Where date = max(date) in sql
SQL
0 vote248 views1 answer
Dockerfile example for Django
SQL
2 votes235 views1 answer
Mysql change data type of column
SQL
1 vote234 views1 answer
Moodle query item quiz
SQL
0 vote240 views2 answers
Mysql calcular idade
SQL