/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 vote150 views1 answer
GROUP BY postgres
SQL
0 vote201 views1 answer
Sql server is not
SQL
0 vote174 views1 answer
Select 1 from orders
SQL
12 votes149 views1 answer
Psql drop column
SQL
31 votes143 views1 answer
Postgresql add column with constraint
SQL
4 votes214 views1 answer
Sql select limit range
SQL
0 vote149 views1 answer
Mysql query to add hours to column in table
SQL
0 vote148 views1 answer
Multiple left join mysql
SQL
5 votes176 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
0 vote165 views1 answer
Postgresql import data from csv
SQL