LessThanDot Site Logo


A decade of helpful technical content

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.

Browsing "iso"

ISO Week In SQL Server

ISO Week in SQL Server First let’s take a look at what ISO week is, from WikiPedia: Week date representations are in the format as shown below. YYYY-Www or YYYYWww YYYY-Www-D or YYYYWwwD [YYYY] indicates the so-called ISO year which is slightly different than the calendar year (see below). [Www] is the week number prefixed […]


ISO-11179 Naming Conventions

Straight from the man himself comes this statement posted in the microsoft.public.sqlserver.programming forum: “You need to read ISO-11179 so you use proper data element names. You actually had “tbl-“on the table names! Sometimes “id” id a prefix and sometimes it is a postfix.” Of course you know who I am talking about? No? Joe Celko […]