/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

1 vote295 views1 answer
Mariadb get column names from table
SQL
0 vote279 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote260 views1 answer
Mysql date time string format for marshmellow field schema
SQL
0 vote277 views1 answer
Postgres grep entire database
SQL
3 votes255 views3 answers
How to set up an auto incrementing id db browser
SQL
1 vote262 views1 answer
Decalre temp table sql
SQL
0 vote260 views2 answers
T SQl Checking Your Username
SQL
2 votes275 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote461 views1 answer
Get first match in each group mysql query
SQL
0 vote291 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL