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.
When I compare the Month and year in DateColumn1 against DateColumn2, it should tell me that DateColumn1 is less (i.e, earlier) than DateColumn2, even though the Month October in DateColumn1 is a later month compare to Jan, theDatColumn1 is in the past year and DateColumn2 is in the current year.
Case 1: For Eg DateColumn1 = '01-OCT-2013' DateColumn2 = '01-JAN-2014'
Here it should tell me that the difference is 0 as the month and the year match in this case.
Case 2: DateColumn1 = '01-JAN-2014' DateColumn2 = '02-JAN-2014'
Here it should tell me that the DateColumn2 is lesser than DateColumn1.
Case 3: DateColumn1 = '01-Aug-2014' DateColumn2 = '02-JAN-2014'
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|converting integer data type to time data type in sql||4||60|
|SQL 2008 SSRS issue with displaying bmp images on the report||2||33|
|Estimating my database size||7||51|
|Adding columns to a table which has non null columns||3||43|
Join the community of 500,000 technology professionals and ask your questions.