/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

17 votes233 views2 answers
How to assign date field for table in mysql
SQL
1 vote172 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
0 vote193 views1 answer
Oracle decode
SQL
0 vote166 views1 answer
Fast sql column count
SQL
0 vote193 views1 answer
Mysql insert into select transaction c#
SQL
0 vote180 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote186 views1 answer
Systems sql
SQL
9 votes179 views2 answers
SELECT User,Host FROM mysql.user;
SQL
0 vote196 views1 answer
What is logical database schema
SQL
0 vote170 views2 answers
T SQl Checking Your Username
SQL