/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

4 votes113 views1 answer
Oracle show errors compilation
SQL
0 vote115 views1 answer
Mysql DDL
SQL
0 vote143 views2 answers
How to take recent row without limit in mysql
SQL
0 vote67 views1 answer
Sql query with date
SQL
0 vote70 views1 answer
Now() -1 mysql
SQL
14 votes115 views2 answers
How to auto increment in sql
SQL
0 vote84 views1 answer
Mysql offset from bottom
SQL
1 vote110 views1 answer
Mamp mysql path mac
SQL
5 votes108 views2 answers
Add column postgres with default value
SQL
0 vote118 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL