/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

-1 vote277 views10 answers
Delete Query in SQL Server
SQL
1 vote304 views2 answers
Sql groub by count
SQL
0 vote320 views1 answer
Windows aggregate functions in postgresql
SQL
1 vote331 views1 answer
Mysql list bigger table
SQL
0 vote345 views2 answers
Oracle chain rules
SQL
1 vote346 views1 answer
Get current date in pyspark sql
SQL
0 vote444 views1 answer
Sql developer export connections
SQL
0 vote359 views1 answer
Traccar mysql
SQL
5 votes299 views2 answers
Oracle tables with column name
SQL
2 votes300 views1 answer
Sql select min value from multiple columns
SQL