/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 votes170 views1 answer
Plsql left() function
SQL
11 votes179 views2 answers
Safe mode off mysql
SQL
0 vote167 views1 answer
Sql join on a subquery
SQL
1 vote164 views3 answers
How to filter repeated same result using sql query
SQL
0 vote168 views1 answer
Suse status MySQL
SQL
1 vote173 views1 answer
Oracle apex prevent initial load
SQL
1 vote259 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote196 views1 answer
Test sql query
SQL
1 vote168 views1 answer
Drush sql-dump
SQL
1 vote164 views2 answers
Mysql order by date asc null last
SQL