/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 vote214 views1 answer
Multiple count in sql
SQL
0 vote235 views1 answer
No query unable to fetch row sqlite
SQL
18 votes194 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
2 votes219 views1 answer
Oracle calculated column
SQL
0 vote218 views1 answer
Sqlite select split string
SQL
3 votes243 views3 answers
1396(hy00) mysql error
SQL
0 vote220 views2 answers
How to display enum value sql server
SQL
0 vote216 views1 answer
How to get data between a last week in mysql
SQL
6 votes217 views4 answers
Eloquent to sql with bindings
SQL
1 vote207 views2 answers
Mysql spring boot application.properties
SQL