/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

17 votes167 views2 answers
How to assign date field for table in mysql
SQL
0 vote130 views1 answer
Sql replace id with name from another table
SQL
0 vote151 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote125 views1 answer
Sql gap missing values
SQL
0 vote135 views1 answer
Value of sold product using having and group by in sql
SQL
1 vote199 views1 answer
Alter constraint postgres
SQL
0 vote151 views2 answers
Insert data mysql with cmd
SQL
0 vote134 views1 answer
Mysql_union
SQL
2 votes138 views1 answer
SQL column name Postgre
SQL
8 votes154 views1 answer
Alter tablespace add datafile autoextend
SQL