Databases

How to show Week Numbers in MS SQL Server

A quick guide to finding or calculating the current ISO week number within MS SQL Server.

code snippet
SELECT DATEPART(iso_week, GETDATE());

Free widgets for webmasters:

Free Analog Clock Widget | Free Digital Clock Widget | Free Text Clock Widget | Free Word Clock Widget