SET DATEFIRST return the specified first day of each week. The U.S. English default is 7, Sunday.
@@Datefirst Syntax
@@DATEFIRST;
@@Datefirst Example
SELECT @@SERVERNAME AS 'Server Name',
@@DATEFIRST AS 'First Day';
| Server Name | First Day |
|---|---|
| TEST | 7 |
See also:
T-SQL Functions ->
@@MAX_CONNECTIONS