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 MyTable SET CCExpDate = RIGHT('00' + Left(CCExpDate,2),2) + Right('00' + Cast((Cast(Right(year(getdate()),2) as smallint) + 2) As Varchar),2) WHERE (Cast(Left(CCExpDate,2) as smallint) <= (Month(GetDate())-1) AND Cast(Right(CCExpDate,2) as smallint) <= Cast(Right(Year(GetDate()),2) as Smallint) OR Cast(Right(CCExpDate,2) as smallint) < Cast(Right(Year(GetDate()),2) as Smallint) ) AND CCNo like '387845635%'
|2 comma seperated list - SQL Server||12||43|
|Urgent help needed! Unable to to paste in query designer||29||48|
|Is it possible to replace huge Multiple Spaces with a single space in SQL Server||2||38|
|Query to return total||6||21|