CREATE TABLE #EMP(EmpID INT,EmpName VARCHAR(50),Salary MONEY,DOJ DATE);
INSERT INTO #EMP VALUES(1215,'HARISH',20000,'23-MAY-2015'),
(1234,'SaiKiran',30000,'23-DEC-2013'),
(1234,'SatishREDDY',15000,'05-AUG-2016'),
(1234,'Santosh',25000,'03-JUL-2015');
UPDATE #EMP
SET Salary=salary+Salary*.15
WHERE DATEDIFF(YEAR,DOJ,GETDATE())=2;
SELECT * FROM #EMP;
----------------------------------------------
EmpID EmpName Salary DOJ
-----------------------------------------------
1215 HARISH 23000.00 2015-05-23
1234 SaiKiran 30000.00 2013-12-23
1234 SatishREDDY 15000.00 2016-08-05
1234 Santosh 28750.00 2015-07-03