/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 vote346 views2 answers
Sql join on wildcard
SQL
1 vote380 views1 answer
Sql string function update replace
SQL
1 vote326 views1 answer
Oracle current sequence value
SQL
0 vote342 views1 answer
Oracle gather table statistics
SQL
0 vote351 views1 answer
Oracle free up space in tablespace
SQL
0 vote354 views1 answer
Report in database
SQL
0 vote327 views1 answer
Sqldf change user
SQL
0 vote391 views1 answer
Doesn't have default value mysql
SQL
0 vote348 views1 answer
Mysql find missing values
SQL
0 vote399 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL