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
06/12/2013
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment