/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 vote390 views1 answer
How to select all fieldsin a soql query
SQL
11 votes344 views1 answer
How to get ddl for materialized view
SQL
0 vote395 views1 answer
Drop index in sql
SQL
1 vote361 views1 answer
Mysql backup skip table
SQL
0 vote383 views2 answers
How to prevent sql injection in java
SQL
3 votes369 views1 answer
MySQL DELETE JOIN
SQL
-1 vote391 views1 answer
Pl/sql how to delete a trigger
SQL
44 votes458 views4 answers
Mysql alter table add column first
SQL
9 votes338 views3 answers
Mysql get last id
SQL
0 vote373 views2 answers
What is the default password for sql server sa
SQL