/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 vote146 views2 answers
Py sqlite if entry exists
SQL
0 vote145 views1 answer
Trigger vérifier stock
SQL
1 vote145 views1 answer
Create new table from old table
SQL
5 votes141 views1 answer
Sql add column after another
SQL
1 vote152 views1 answer
Sqlite3 read only
SQL
0 vote96 views1 answer
Postgresql subquery
SQL
27 votes172 views5 answers
Mysql set password for user
SQL
0 vote126 views1 answer
How to execute stored output to csv files
SQL
0 vote141 views1 answer
Mysql cli output to a file
SQL
0 vote146 views1 answer
Ansi sql count duplicate rows
SQL