/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 vote204 views1 answer
Safe mysql
SQL
4 votes189 views1 answer
Refresh postgres config
SQL
0 vote184 views1 answer
Login failed for login due to trigger execution
SQL
0 vote138 views1 answer
Sqlalchemy filter relationship
SQL
0 vote181 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
0 vote180 views1 answer
Database xml sql
SQL
51 votes599 views6 answers
Installing mysql on ubuntu
SQL
1 vote284 views1 answer
Oracle see column type
SQL
0 vote181 views1 answer
Insert or update sql query
SQL
8 votes203 views1 answer
Declare table variable sql server
SQL