/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

14 votes174 views1 answer
Excel
SQL
1 vote183 views1 answer
Mysql backup skip table
SQL
10 votes169 views5 answers
Mysql create user
SQL
0 vote167 views1 answer
How to connect postgresql database with java
SQL
0 vote187 views1 answer
Select all columns except one sql
SQL
0 vote193 views1 answer
Mysql replication change database name
SQL
0 vote167 views1 answer
Mysql multiple count
SQL
0 vote210 views1 answer
How to find symmetric pairs in sql
SQL
0 vote194 views1 answer
How to inner join 4 tables in sql
SQL
0 vote176 views1 answer
Update top 100 sql
SQL