/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 vote136 views1 answer
Create email address from first and last name in sql
SQL
3 votes136 views3 answers
C# sql select
SQL
0 vote156 views1 answer
Function plsql
SQL
0 vote131 views1 answer
Automate mysql cli query
SQL
0 vote139 views1 answer
Test sql query
SQL
3 votes256 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
5 votes145 views3 answers
MySql get fields of table
SQL
2 votes136 views1 answer
How to select first row of database sql
SQL
0 vote148 views1 answer
Tsql pad left
SQL
0 vote142 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL