set @Month_From_Date = datepart(month,@Date) --here i have take month from date(02) set @Month_From_Date =@Month_Value --(month_value : 05 place in month_From_Date variable)
SELECT DATEADD(month, 1, '2006-08-30');
select replace( '22/02/2013 12:00:00 AM',substring('22/02/2013 12:00:00 AM',4,2),'05')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)