/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

11 votes151 views1 answer
Oracle export view ddl
SQL
26 votes140 views2 answers
Mysql workbench download
SQL
1 vote132 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
1 vote169 views1 answer
Apex run 404
SQL
0 vote130 views1 answer
Mariadb search columns
SQL
1 vote136 views1 answer
Add many column to sap iq table
SQL
2 votes139 views1 answer
Metasploit start postgresql
SQL
0 vote139 views1 answer
Add unique constraint sql server multiple columns
SQL
7 votes141 views2 answers
Sql server drop temp table if exists
SQL
0 vote133 views1 answer
Oracle enable chain
SQL