i working on server migration oracle sql server 2012.
in stored procedure have
select @months = datediff(m, getdate(), cast('12/01/' + cast(year(getdate()) + 1 varchar(4)) datetime))
do need make changes query run in sql server? or work fine ? functions used here (in oracle) works same in sql server (right don't have link server test).
getdate(), datediff(), , cast() valid in sql server