Главная Обзор Помощь
Регистрация Вход
WEP
/
SQL
3
0
Ответвить 0
Файлы Задачи 0 Запросы на слияние 0 Вики
Дерево: cc27c7420e
Ветки Метки
SQL
/
WE_2024
/
CLEAN.sql

CLEAN.sql 11 KB
История Исходник

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103 
  1.  
    2. 

  2.  /*
    3. 

  3.  USE [We_AppDb_V2.2_Dev]; 
    4. 

  4.  DECLARE @NO NVARCHAR(50);	SET @NO='JY2001000010027';
    5. 

  5.  
    6. 

  6.  UPDATE [dbo].[Train_Camps] SET [CampState]=2,[StartDate]=NULL WHERE [Id]=@NO
    7. 

  7.  UPDATE [dbo].[Train_CampGroups] SET [CampGroupState]=1,[RunningInfo]=NULL,[StartDate]=NULL,[EngDate]=NULL,[RoundIndex]=1 WHERE [CampNo]=@NO
    8. 

  8.  UPDATE [dbo].[Train_CampGroupScores] SET [SystemScore]=0,[CorrectionScore]=0,[SpecialistScore]=0,[AudienceScore]=0,[ReferenceScore]=0,[FinalTotalScore]=0,[BehaviorTagScoreInfo]='' WHERE [CampNo]=@NO
    9. 

  9.  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 
    10. 

  10.  DELETE  [dbo].[Train_CampGroupScores] WHERE [CampNo]=@NO 
    11. 

  11.  DELETE  [dbo].[Train_CampGroupLogs] WHERE [CampNo]=@NO 
    12. 

  12.  DELETE  [dbo].[Train_CampGroupPortraits] WHERE [CampNo]=@NO
    13. 

  13.  DELETE  [dbo].[Train_CampGroupRoles] WHERE [GroupNo] like @NO+'%'
    14. 

  14.  
    15. 

  15.  
    16. 

  16. 

  17.  USE [We_AppDb_V2.2_Dev]; 
    18. 

  18.  DECLARE @NO NVARCHAR(50);	SET @NO='JY2001000010075——';
    19. 

  19. 

  20.  DELETE  [dbo].[Train_CampGroupScores] WHERE [CampNo]=@NO 
    21. 

  21.  DELETE  [dbo].[Train_CampGroupLogs] WHERE [CampNo]=@NO 
    22. 

  22.  DELETE  [dbo].[Train_CampGroupPortraits] WHERE [CampNo]=@NO
    23. 

  23.  DELETE  [dbo].[Train_CampGroupRoles] WHERE [GroupNo] like @NO+'%'
    24. 

  24.  --DELETE  [dbo].[Train_CampHelps] WHERE [CampNo]=@NO 
    25. 

  25.   --DELETE  [dbo].[Train_CampGroups] WHERE [CampNo]=@NO 
    26. 

  26.   --DELETE  [dbo].[Train_Camps] WHERE [Id]=@NO 
    27. 

  27. 

  28.  */
    29. 

  29. 

  30. /*
    31. 

  31. USE [We_AppDb_V2.2_Dev]; 
    32. 

  32. --关联学员提示信息(HD大面积停电)
    33. 

  33. DECLARE @CampNO NVARCHAR(50);	SET @CampNO='JY2001000010027';
    34. 

  34. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011001', @CampNO, N'2024-06-26', 3);
    35. 

  35. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011002', @CampNO, N'2024-06-26', 3);
    36. 

  36. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011003', @CampNO, N'2024-06-26', 3);
    37. 

  37. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011004', @CampNO, N'2024-06-26', 3);
    38. 

  38. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011005', @CampNO, N'2024-06-26', 3);
    39. 

  39. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011006', @CampNO, N'2024-06-26', 3);
    40. 

  40. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011007', @CampNO, N'2024-06-26', 3);
    41. 

  41. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011008', @CampNO, N'2024-06-26', 3);
    42. 

  42. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011009', @CampNO, N'2024-06-26', 3);
    43. 

  43. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011010', @CampNO, N'2024-06-26', 3);
    44. 

  44. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011011', @CampNO, N'2024-06-26', 3);
    45. 

  45. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011012', @CampNO, N'2024-06-26', 3);
    46. 

  46. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011013', @CampNO, N'2024-06-26', 3);
    47. 

  47. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011014', @CampNO, N'2024-06-26', 3);
    48. 

  48. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011015', @CampNO, N'2024-06-26', 3);
    49. 

  49. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011016', @CampNO, N'2024-06-26', 3);
    50. 

  50. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011017', @CampNO, N'2024-06-26', 3);
    51. 

  51. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011018', @CampNO, N'2024-06-26', 3);
    52. 

  52. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011019', @CampNO, N'2024-06-26', 3);
    53. 

  53. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011020', @CampNO, N'2024-06-26', 3);
    54. 

  54. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011021', @CampNO, N'2024-06-26', 3);
    55. 

  55. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011022', @CampNO, N'2024-06-26', 3);
    56. 

  56. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011023', @CampNO, N'2024-06-26', 3);
    57. 

  57. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011024', @CampNO, N'2024-06-26', 3);
    58. 

  58. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011025', @CampNO, N'2024-06-26', 3);
    59. 

  59. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011026', @CampNO, N'2024-06-26', 3);
    60. 

  60. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011027', @CampNO, N'2024-06-26', 3);
    61. 

  61. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011028', @CampNO, N'2024-06-26', 3);
    62. 

  62. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011029', @CampNO, N'2024-06-26', 3);
    63. 

  63. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011030', @CampNO, N'2024-06-26', 3);
    64. 

  64. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011031', @CampNO, N'2024-06-26', 3);
    65. 

  65. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011032', @CampNO, N'2024-06-26', 3);
    66. 

  66. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011033', @CampNO, N'2024-06-26', 3);
    67. 

  67. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011034', @CampNO, N'2024-06-26', 3);
    68. 

  68. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011035', @CampNO, N'2024-06-26', 3);
    69. 

  69. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011036', @CampNO, N'2024-06-26', 3);
    70. 

  70. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011037', @CampNO, N'2024-06-26', 3);
    71. 

  71. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011038', @CampNO, N'2024-06-26', 3);
    72. 

  72. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011039', @CampNO, N'2024-06-26', 3);
    73. 

  73. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011040', @CampNO, N'2024-06-26', 3);
    74. 

  74. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011041', @CampNO, N'2024-06-26', 3);
    75. 

  75. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011042', @CampNO, N'2024-06-26', 3);
    76. 

  76. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011043', @CampNO, N'2024-06-26', 3);
    77. 

  77. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011044', @CampNO, N'2024-06-26', 3);
    78. 

  78. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011045', @CampNO, N'2024-06-26', 3);
    79. 

  79. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011046', @CampNO, N'2024-06-26', 3);
    80. 

  80. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011047', @CampNO, N'2024-06-26', 3);
    81. 

  81. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011048', @CampNO, N'2024-06-26', 3);
    82. 

  82. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011049', @CampNO, N'2024-06-26', 3);
    83. 

  83. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011050', @CampNO, N'2024-06-26', 3);
    84. 

  84. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011051', @CampNO, N'2024-06-26', 3);
    85. 

  85. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011052', @CampNO, N'2024-06-26', 3);
    86. 

  86. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011053', @CampNO, N'2024-06-26', 3);
    87. 

  87. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011054', @CampNO, N'2024-06-26', 3);
    88. 

  88. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011055', @CampNO, N'2024-06-26', 3);
    89. 

  89. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011056', @CampNO, N'2024-06-26', 3);
    90. 

  90. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011057', @CampNO, N'2024-06-26', 3);
    91. 

  91. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011058', @CampNO, N'2024-06-26', 3);
    92. 

  92. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011059', @CampNO, N'2024-06-26', 3);
    93. 

  93. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011060', @CampNO, N'2024-06-26', 3);
    94. 

  94. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011061', @CampNO, N'2024-06-26', 3);
    95. 

  95. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011062', @CampNO, N'2024-06-26', 3);
    96. 

  96. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011063', @CampNO, N'2024-06-26', 3);
    97. 

  97. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011064', @CampNO, N'2024-06-26', 3);
    98. 

  98. INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011065', @CampNO, N'2024-06-26', 3);
    99. 

  99. 

  100. */
    101. 

  101. 

  102.   
    103. 

  103.  
    104.