CREATE TABLE #EMP (EmpID INT IDENTITY(1,1),EmpName VARCHAR(100),Designation VARCHAR(10))
    INSERT INTO #EMP(EmpName, Designation)
    VALUES('Ramesh','Teamlead')
    ,('Suresh','Manager')
1
2
3
4

DECLARE @EmpID INT
SELECT @EmpID = EmpID
FROM #EMP WHERE EmpName = 'Ramesh' AND Designation = 'Teamlead'
IF @@ROWCOUNT = 0
    INSERT INTO #EMP(EmpName, Designation)
    VALUES('Ramesh','Teamlead')
1
2
3
4
5
6

IF NOT EXISTS(
    SELECT NULL FROM #EMP 
    WHERE EmpName = 'Ramesh' AND Designation = 'Teamlead'
    )
BEGIN
 INSERT INTO #EMP(EmpName, Designation)
 VALUES('Ramesh','Teamlead')
    ,('Suresh','Manager')
END
1
2
3
4
5
6
7
8
9