select DATEPART(WEEK,GETDATE()). If that is not useful for your requirements, you can also think of to create date table in SQL Server.
確定! 回上一頁