Sql server® 2012 t-sql fundamentals

1. 

Today is the last day of the year.

2. 

Today is the last day of the month but not the last day of the year.

3. 

Today is not the last day of the month.

www.it-ebooks.info

---

346  

Microsoft SQL Server 2012 T-SQL Fundamentals

IF YEAR(SYSDATETIME()) <> YEAR(DATEADD(day, 1, SYSDATETIME())) 

  PRINT 'Today is the last day of the year.'; 

ELSE 

  IF MONTH(SYSDATETIME()) <> MONTH(DATEADD(day, 1, SYSDATETIME())) 

    PRINT 'Today is the last day of the month but not the last day of the year.'; 

  ELSE 

    PRINT 'Today is not the last day of the month.';

If you need to run more than one statement in the IF or ELSE sections, you need to use a state-

ment block. You mark the boundaries of a statement block with the BEGIN and END keywords. For 

example, the following code shows how to run one type of process if it’s the first day of the month, 

and another type of process if it isn’t.

IF DAY(SYSDATETIME()) = 1 

BEGIN 

  PRINT 'Today is the first day of the month.'; 

  PRINT 'Starting first-of-month-day process.'; 

  /* ... process code goes here ... */ 

  PRINT 'Finished first-of-month-day database process.'; 

END 

ELSE 

BEGIN 

  PRINT 'Today is not the first day of the month.'; 

  PRINT 'Starting non-first-of-month-day process.'; 

  /* ... process code goes here ... */ 

  PRINT 'Finished non-first-of-month-day process.'; 

END