SQL/WE_2024/CLEAN.sql

 
 /*
 USE [We_AppDb_V2.2_Dev]; 
 DECLARE @NO NVARCHAR(50);	SET @NO='JY2001000010027';
 
 UPDATE [dbo].[Train_Camps] SET [CampState]=2,[StartDate]=NULL WHERE [Id]=@NO
 UPDATE [dbo].[Train_CampGroups] SET [CampGroupState]=1,[RunningInfo]=NULL,[StartDate]=NULL,[EngDate]=NULL,[RoundIndex]=1 WHERE [CampNo]=@NO
 UPDATE [dbo].[Train_CampGroupScores] SET [SystemScore]=0,[CorrectionScore]=0,[SpecialistScore]=0,[AudienceScore]=0,[ReferenceScore]=0,[FinalTotalScore]=0,[BehaviorTagScoreInfo]='' WHERE [CampNo]=@NO
 UPDATE  [dbo].[Train_CampGroupLogs] SET LogState=1  WHERE LogType=2 AND (LogState=2 OR LogState=3 OR LogState=4  OR LogState=5) AND [CampNo]=@NO 
 DELETE  [dbo].[Train_CampGroupScores] WHERE [CampNo]=@NO 
 DELETE  [dbo].[Train_CampGroupLogs] WHERE [CampNo]=@NO 
 DELETE  [dbo].[Train_CampGroupPortraits] WHERE [CampNo]=@NO
 DELETE  [dbo].[Train_CampGroupRoles] WHERE [GroupNo] like @NO+'%'
 
 

 USE [We_AppDb_V2.2_Dev]; 
 DECLARE @NO NVARCHAR(50);	SET @NO='JY2001000010075——';

 DELETE  [dbo].[Train_CampGroupScores] WHERE [CampNo]=@NO 
 DELETE  [dbo].[Train_CampGroupLogs] WHERE [CampNo]=@NO 
 DELETE  [dbo].[Train_CampGroupPortraits] WHERE [CampNo]=@NO
 DELETE  [dbo].[Train_CampGroupRoles] WHERE [GroupNo] like @NO+'%'
 --DELETE  [dbo].[Train_CampHelps] WHERE [CampNo]=@NO 
  --DELETE  [dbo].[Train_CampGroups] WHERE [CampNo]=@NO 
  --DELETE  [dbo].[Train_Camps] WHERE [Id]=@NO 

 */

/*
USE [We_AppDb_V2.2_Dev]; 
--关联学员提示信息
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo], [CampNo], [CreationTime], [CreatorUserId]) VALUES (N'', N'', '2024-06-26', 3);

*/