/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 vote169 views1 answer
Sql server synonym
SQL
0 vote147 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote153 views1 answer
How to check replication lag in mySQL
SQL
3 votes160 views1 answer
Oracle user privileges
SQL
0 vote146 views2 answers
Drop check constraint in ms sql
SQL
1 vote150 views3 answers
Mysql parse int
SQL
1 vote170 views1 answer
Mysql how to truncate table with foreign keys
SQL
1 vote153 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote149 views1 answer
Oracle sql procedure return value
SQL
0 vote174 views1 answer
Mysql export data with a where clause
SQL