/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 vote228 views1 answer
Mssql find deadlocks
SQL
1 vote199 views1 answer
Mysql how to reset primary key
SQL
6 votes182 views5 answers
Get current date sql
SQL
0 vote181 views1 answer
Sql comparison operators
SQL
0 vote206 views1 answer
Select row from mysql where date more than 30 days
SQL
1 vote190 views1 answer
What is int in mysql
SQL
1 vote213 views1 answer
Load mysql dumb
SQL
10 votes371 views4 answers
Mysql if else
SQL
-1 vote195 views1 answer
Sql oracle take only last results
SQL
3 votes250 views1 answer
Sql select second max
SQL