/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

2 votes214 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote228 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote197 views1 answer
Connexion mysql
SQL
0 vote202 views1 answer
Oracle current timestamp insert statement
SQL
0 vote223 views1 answer
Postgres change the name of schema
SQL
3 votes207 views1 answer
Index using in query plsql
SQL
0 vote249 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote227 views1 answer
How to get button for every record from mysql
SQL
11 votes204 views2 answers
Having in sql
SQL
0 vote207 views1 answer
Phpmyadmin mysql conflict
SQL