/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 vote104 views1 answer
Show database not empty tables postgres
SQL
0 vote116 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
3 votes128 views1 answer
Oracle function return
SQL
4 votes134 views2 answers
Dbms output
SQL
0 vote110 views1 answer
Drop a field in psql django
SQL
0 vote175 views4 answers
Stored procedure sql
SQL
1 vote159 views1 answer
Sqlite show columns in table
SQL
0 vote127 views1 answer
On delete set default
SQL
3 votes107 views1 answer
Oracle undo tablespace list by user
SQL
0 vote105 views1 answer
Vowels in sql
SQL