/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

32 votes140 views6 answers
Rename column mysql
SQL
0 vote122 views1 answer
Get id if is not equal in certain table
SQL
0 vote128 views1 answer
Start and stop mysql
SQL
4 votes120 views1 answer
Sql delete where in select
SQL
2 votes129 views1 answer
Show max_allowed_packet mysql
SQL
0 vote141 views1 answer
How to join result table in mysql
SQL
3 votes120 views1 answer
Make a field auto_increment mysql
SQL
0 vote121 views1 answer
Sql server bool select
SQL
0 vote120 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote134 views1 answer
Oracle lower in where clause
SQL