sql 取年月

select DATEPART(yyyy,getdate())

select cast(year(getdate()) as varchar)+'/'+cast(month(getdate()) as varchar)

select convert(varchar(7),getdate(),111)  --此法為偷吃步,月數較ok