SET DATEFIRST

DATEPART function

T-SQL Datetime functions

The first day of the week

T-SQL Datetime functions