increment the employee salary 15% if he has 2 years of experience? table name=employee_info columns are emp_id;emp_name;salary;dateofjoin. using SQL or SQL SERVER

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

SELECT salary + (salary * 15/100) as Salary, emp_name
FrOM employee_info
Where DATEDIFF(MONTH, dateofjoin, GETDATE())/12 =2

SELECT salary + (salary * 15/100) as NewSalary, emp_name
FrOM employee_info
Where DATEDIFF(MONTH, dateofjoin, GETDATE())/12 =2