title: How to add one year to a date using SQL script in SQL server?
body: <p>I am getting a date parameter value as '4-1-2009' from front end.  Now I want to make it as</p>
  
  <p>'4-1-2010'  in my stored procedure. I am trying like below.</p>
  
  <pre><code>ALTER PROCEDURE [dbo].[SP_EMP]                    
  
   @STARTDATE DATETIME,
  
   @ENDDATE DATETIME,
  
   @STARTDATE2 DATETIME, 
  
   SET  @STARTDATE2=DATEADD(yy, 1, @STARTDATE)
  
  
  AS                      
  BEGIN 
  
  SELECT EMPNAME FROM EMP WHERE JOINDATE&gt;@STARTDATE2
  
  ----//  SOME JOINS //----
  
  END
  </code></pre>
  
  <p>How can I do this?
  Please tell me.</p>
  
  <p>Regards,
  N.SRIRAM</p>