CREATE TABLE #Employees (Emp_No INT, EName VARCHAR(5), Sal INT)

delete #Employees

INSERT INTO #Employees (Emp_No, EName, Sal)

SELECT 111, 'AAAA', 9999 UNION ALL

...