/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 views1 answer
Strat with in sql
SQL
1 vote166 views2 answers
Rebuild index sql server
SQL
0 vote183 views1 answer
How to input data as id in database sql c#
SQL
0 vote173 views1 answer
Savepoint mysql script
SQL
16 votes157 views4 answers
Ascending order mysql
SQL
0 vote151 views1 answer
Oracle list proxy users
SQL
1 vote155 views1 answer
Sql group by error
SQL
0 vote147 views1 answer
Sqlite closes value
SQL
0 vote155 views1 answer
Back up stored procedures mysql
SQL
1 vote156 views1 answer
Simple project for database
SQL