/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 vote266 views2 answers
How to see table associated with a schema in sql
SQL
0 vote364 views1 answer
Mysql show schema
SQL
0 vote269 views1 answer
Mysql remove tabs from string
SQL
1 vote300 views1 answer
Mamp mysql path mac
SQL
1 vote257 views1 answer
Sql comment header
SQL
0 vote288 views1 answer
Oracle query to find schema you are working on
SQL
0 vote278 views1 answer
Default password for mysql_secure_installation in mac
SQL
0 vote270 views1 answer
No suitable driver found for sqlite
SQL
0 vote275 views1 answer
Postgresql remove new line from string
SQL
1 vote301 views1 answer
Sql server loop over query
SQL