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.
ALTER PROCEDURE sp_GetAllEvaluationVisit( @ParticipantID as int) AS BEGIN SET NOCOUNT ON --declare @ParticipantID as int --set @ParticipantID = '1' Select e.ParticipantID as [ParticipantID], e.DateEvaluation as [DateEvaluation], (case when (e.EvaluationID = 0) then '' when (e.EvaluationID = 1) then 'Program Begin' when (e.EvaluationID = 2) then 'Program End' when (e.EvaluationID = 3) then 'Six Month' end ) as [EvaluationType], (case when (s.SchoolID = 0) then '' when (s.SchoolID = 1) then 'Santee Educational Complex' when (s.SchoolID = 2) then 'Jefferson' when (s.SchoolID = 3) then 'Dorsey' when (s.SchoolID = 4) then 'Fremont' when (s.SchoolID = 5) then 'West Adams' end ) as [SchoolName], s.Age as [Age], (case when (s.Gender = 1) then 'Male' when (s.Gender = 2) then 'Female' end ) as [Gender] from tbl_EvaluationVisit e join tbl_Survey s on e.ParticipantID = @ParticipantID and s.ParticipantID = @ParticipantID
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.