Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
UPDATE newseason SET YearNumber = left(@SeasonNumber,4), YearName = left(@SeasonNumber,4), SeasonNumber = @SeasonNumber, SeasonNumber1 = @SeasonNumber, SeasonName = @SeasonName, MonthNumber = left(@SeasonNumber,4) + '0' + left(CONVERT(CHAR(8),TID,10),2), MonthName = DATENAME(MONTH,TID) , WeekName = REPLACE(('Week of ' + left(CONVERT(CHAR(8),TID,10),2) + '/' + substring(CONVERT(CHAR(8),(SELECT DATEADD(wk, DATEDIFF(wk,0,TID), 0)),10),4,2) + '/' + cast(Year(TID) as varchar)),'Week of 0','Week of '), WeekNumber = cast(Year(TID) as varchar) + '00' + cast(DATEDIFF(week, @FiscalYear, TID-1) as varchar)+1, DayNumber = cast(Year(TID) as varchar) + '0' + cast(DATEDIFF(day, @FiscalYear, TID+1) as varchar), DayName = (SELECT DATENAME(dw, TID))
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL Server Results to Excel File||18||76|
|creating a permanent table from the results of a select statement in sql server 2016||5||32|
|SQL Server Resume||5||45|
|SQL question - help with insert for missing info||5||19|