/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 vote365 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote335 views1 answer
Recover deleted data from mysql database
SQL
0 vote350 views1 answer
Sql convert datetime to year
SQL
2 votes309 views1 answer
Oracle current date without time
SQL
0 vote380 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote342 views3 answers
Get free card roblox
SQL
5 votes362 views1 answer
Dbms_metadata.get_ddl table
SQL
3 votes353 views1 answer
Force using index plsql
SQL
5 votes347 views1 answer
Sql select ciunt
SQL
7 votes369 views3 answers
Convert ansi sql
SQL