Advertisement
Inverth

db dumb

Feb 5th, 2021
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.99 KB | None | 0 0
  1. update [Order]
  2. set [Price] = 300
  3. where [ID] = 1
  4.  
  5. update [Order]
  6. set ExecutionDate = '2021-01-01'
  7. where [ID] = 1
  8.  
  9. update [Order]
  10. set OrderDate = '2021-01-01'
  11. where [ID] = 1
  12.  
  13. update [Order]
  14. set [Price] = 904
  15. where [ID] = 2
  16.  
  17. update [Order]
  18. set ExecutionDate = '2021-01-10'
  19. where [ID] = 2
  20.  
  21. update [Order]
  22. set OrderDate = '2021-01-10'
  23. where [ID] = 2
  24.  
  25. update [Order]
  26. set [Price] = 1070
  27. where [ID] = 3
  28.  
  29. update [Order]
  30. set ExecutionDate = '2021-03-01'
  31. where [ID] = 3
  32.  
  33. update [Order]
  34. set OrderDate = '2021-03-01'
  35. where [ID] = 3
  36.  
  37. update [Order]
  38. set [Price] = 50
  39. where [ID] = 4
  40.  
  41. update [Order]
  42. set ExecutionDate = '2021-02-01'
  43. where [ID] = 4
  44.  
  45. update [Order]
  46. set OrderDate = '2021-02-01'
  47. where [ID] = 4
  48.  
  49. update [Order]
  50. set [Price] = 1850
  51. where [ID] = 5
  52.  
  53. update [Order]
  54. set ExecutionDate = '2021-02-04'
  55. where [ID] = 5
  56.  
  57. update [Order]
  58. set OrderDate = '2021-02-04'
  59. where [ID] = 5
  60.  
  61. update [Order]
  62. set [Price] = 50
  63. where [ID] = 6
  64.  
  65. update [Order]
  66. set ExecutionDate = '2021-04-01'
  67. where [ID] = 6
  68.  
  69. update [Order]
  70. set OrderDate = '2021-04-01'
  71. where [ID] = 6
  72.  
  73. update [Order]
  74. set [Price] = 51
  75. where [ID] = 7
  76.  
  77. update [Order]
  78. set ExecutionDate = '2021-04-02'
  79. where [ID] = 7
  80.  
  81. update [Order]
  82. set OrderDate = '2021-04-02'
  83. where [ID] = 7
  84.  
  85. update [Order]
  86. set [Price] = 52
  87. where [ID] = 8
  88.  
  89. update [Order]
  90. set ExecutionDate = '2021-04-03'
  91. where [ID] = 8
  92.  
  93. update [Order]
  94. set OrderDate = '2021-04-03'
  95. where [ID] = 8
  96.  
  97. update [Order]
  98. set [Price] = 80
  99. where [ID] = 9
  100.  
  101. update [Order]
  102. set ExecutionDate = '2021-05-01'
  103. where [ID] = 9
  104.  
  105. update [Order]
  106. set OrderDate = '2021-05-01'
  107. where [ID] = 9
  108.  
  109. update [Order]
  110. set [Price] = 300
  111. where [ID] = 10
  112.  
  113. update [Order]
  114. set ExecutionDate = '2021-05-01'
  115. where [ID] = 10
  116.  
  117. update [Order]
  118. set OrderDate = '2021-05-01'
  119. where [ID] = 10
  120.  
  121. update [Order]
  122. set [Price] = 700
  123. where [ID] = 11
  124.  
  125. update [Order]
  126. set ExecutionDate = '2021-06-01'
  127. where [ID] = 11
  128.  
  129. update [Order]
  130. set OrderDate = '2021-06-01'
  131. where [ID] = 11
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement