/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

24 votes341 views6 answers
Rename a column in sql server
SQL
4 votes376 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
7 votes312 views2 answers
Create index mysql
SQL
0 vote336 views1 answer
Show table structure mysql console
SQL
0 vote364 views1 answer
Sql server user permissions and roles
SQL
4 votes326 views1 answer
Create column mysql terminal
SQL
10 votes325 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote338 views1 answer
Mysql select field if condition
SQL
0 vote306 views1 answer
Sql random decimal
SQL
0 vote316 views1 answer
What is the essence of SQL?
SQL