This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- A comma-separated list of fully-qualified table names that should be marked for recompile | |
| DECLARE @ObjectRecompileList VARCHAR(MAX) = 'dbo.Table1,dbo.Table2,dbo.Proc1'; | |
| DECLARE @ObjectsToRecompile TABLE | |
| ( | |
| ObjectId INT, | |
| ObjectSchema VARCHAR(1000), | |
| ObjectName VARCHAR(1000) | |
| ) | |
| DECLARE @ObjectsToVerify TABLE |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| public static class DateTimeExtensions | |
| { | |
| public static DateTime GetNextDayOfWeek(this DateTime date, DayOfWeek targetDayOfWeek) => date.AddDays(targetDayOfWeek - date.DayOfWeek + (date.DayOfWeek < targetDayOfWeek ? 0 : 7)); | |
| } |