Merge in SQL Server

Introduction: I attended one interview and interviewer asked me below question. Q 1: Id EName ECode 1 Rajesh E001 2 Suresh E002 3 Ram E003 Write a single statement to insert, update and delete operation in this table. Q 2: Id EName ECode 1 Rajesh E001 2 Tiger E002 Write a insert query to insert … Read more