mssql_fiddle_data.sql 6.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213
  1. create table table1 (
  2. id int primary key,
  3. a varchar(40),
  4. b varchar(40),
  5. c varchar(40)
  6. );
  7. create table table2 (
  8. id int primary key,
  9. ref_id int,
  10. d varchar(40)
  11. );
  12. INSERT INTO table1 (id, a, b, c)
  13. VALUES (0, '0', '0', '0');
  14. INSERT INTO table1 (id, a, b, c)
  15. VALUES (1, '1', '1', '1');
  16. INSERT INTO table1 (id, a, b, c)
  17. VALUES (2, '2', '2', '2');
  18. INSERT INTO table1 (id, a, b, c)
  19. VALUES (3, '3', '3', '3');
  20. INSERT INTO table1 (id, a, b, c)
  21. VALUES (4, '4', '4', '4');
  22. INSERT INTO table1 (id, a, b, c)
  23. VALUES (5, '5', '5', '5');
  24. INSERT INTO table1 (id, a, b, c)
  25. VALUES (6, '6', '6', '6');
  26. INSERT INTO table1 (id, a, b, c)
  27. VALUES (7, '7', '7', '7');
  28. INSERT INTO table1 (id, a, b, c)
  29. VALUES (8, '8', '8', '8');
  30. INSERT INTO table1 (id, a, b, c)
  31. VALUES (9, '9', '9', '9');
  32. INSERT INTO table1 (id, a, b, c)
  33. VALUES (10, '10', '10', '10');
  34. INSERT INTO table1 (id, a, b, c)
  35. VALUES (11, '11', '11', '11');
  36. INSERT INTO table1 (id, a, b, c)
  37. VALUES (12, '12', '12', '12');
  38. INSERT INTO table1 (id, a, b, c)
  39. VALUES (13, '13', '13', '13');
  40. INSERT INTO table1 (id, a, b, c)
  41. VALUES (14, '14', '14', '14');
  42. INSERT INTO table1 (id, a, b, c)
  43. VALUES (15, '15', '15', '15');
  44. INSERT INTO table1 (id, a, b, c)
  45. VALUES (16, '16', '16', '16');
  46. INSERT INTO table1 (id, a, b, c)
  47. VALUES (17, '17', '17', '17');
  48. INSERT INTO table1 (id, a, b, c)
  49. VALUES (18, '18', '18', '18');
  50. INSERT INTO table1 (id, a, b, c)
  51. VALUES (19, '19', '19', '19');
  52. INSERT INTO table1 (id, a, b, c)
  53. VALUES (20, '20', '20', '20');
  54. INSERT INTO table1 (id, a, b, c)
  55. VALUES (21, '21', '21', '21');
  56. INSERT INTO table1 (id, a, b, c)
  57. VALUES (22, '22', '22', '22');
  58. INSERT INTO table1 (id, a, b, c)
  59. VALUES (23, '23', '23', '23');
  60. INSERT INTO table1 (id, a, b, c)
  61. VALUES (24, '24', '24', '24');
  62. INSERT INTO table1 (id, a, b, c)
  63. VALUES (25, '25', '25', '25');
  64. INSERT INTO table1 (id, a, b, c)
  65. VALUES (26, '26', '26', '26');
  66. INSERT INTO table1 (id, a, b, c)
  67. VALUES (27, '27', '27', '27');
  68. INSERT INTO table1 (id, a, b, c)
  69. VALUES (28, '28', '28', '28');
  70. INSERT INTO table1 (id, a, b, c)
  71. VALUES (29, '29', '29', '29');
  72. INSERT INTO table1 (id, a, b, c)
  73. VALUES (30, '30', '30', '30');
  74. INSERT INTO table1 (id, a, b, c)
  75. VALUES (31, '31', '31', '31');
  76. INSERT INTO table1 (id, a, b, c)
  77. VALUES (32, '32', '32', '32');
  78. INSERT INTO table1 (id, a, b, c)
  79. VALUES (33, '33', '33', '33');
  80. INSERT INTO table1 (id, a, b, c)
  81. VALUES (34, '34', '34', '34');
  82. INSERT INTO table1 (id, a, b, c)
  83. VALUES (35, '35', '35', '35');
  84. INSERT INTO table1 (id, a, b, c)
  85. VALUES (36, '36', '36', '36');
  86. INSERT INTO table1 (id, a, b, c)
  87. VALUES (37, '37', '37', '37');
  88. INSERT INTO table1 (id, a, b, c)
  89. VALUES (38, '38', '38', '38');
  90. INSERT INTO table1 (id, a, b, c)
  91. VALUES (39, '39', '39', '39');
  92. INSERT INTO table1 (id, a, b, c)
  93. VALUES (40, '40', '40', '40');
  94. INSERT INTO table1 (id, a, b, c)
  95. VALUES (41, '41', '41', '41');
  96. INSERT INTO table1 (id, a, b, c)
  97. VALUES (42, '42', '42', '42');
  98. INSERT INTO table1 (id, a, b, c)
  99. VALUES (43, '43', '43', '43');
  100. INSERT INTO table1 (id, a, b, c)
  101. VALUES (44, '44', '44', '44');
  102. INSERT INTO table1 (id, a, b, c)
  103. VALUES (45, '45', '45', '45');
  104. INSERT INTO table1 (id, a, b, c)
  105. VALUES (46, '46', '46', '46');
  106. INSERT INTO table1 (id, a, b, c)
  107. VALUES (47, '47', '47', '47');
  108. INSERT INTO table1 (id, a, b, c)
  109. VALUES (48, '48', '48', '48');
  110. INSERT INTO table1 (id, a, b, c)
  111. VALUES (49, '49', '49', '49');
  112. INSERT INTO table2 (id, ref_id, d)
  113. VALUES (0, '0', '0');
  114. INSERT INTO table2 (id, ref_id, d)
  115. VALUES (1, '1', '1');
  116. INSERT INTO table2 (id, ref_id, d)
  117. VALUES (2, '2', '2');
  118. INSERT INTO table2 (id, ref_id, d)
  119. VALUES (3, '3', '3');
  120. INSERT INTO table2 (id, ref_id, d)
  121. VALUES (4, '4', '4');
  122. INSERT INTO table2 (id, ref_id, d)
  123. VALUES (5, '5', '5');
  124. INSERT INTO table2 (id, ref_id, d)
  125. VALUES (6, '6', '6');
  126. INSERT INTO table2 (id, ref_id, d)
  127. VALUES (7, '7', '7');
  128. INSERT INTO table2 (id, ref_id, d)
  129. VALUES (8, '8', '8');
  130. INSERT INTO table2 (id, ref_id, d)
  131. VALUES (9, '9', '9');
  132. INSERT INTO table2 (id, ref_id, d)
  133. VALUES (10, '10', '10');
  134. INSERT INTO table2 (id, ref_id, d)
  135. VALUES (11, '11', '11');
  136. INSERT INTO table2 (id, ref_id, d)
  137. VALUES (12, '12', '12');
  138. INSERT INTO table2 (id, ref_id, d)
  139. VALUES (13, '13', '13');
  140. INSERT INTO table2 (id, ref_id, d)
  141. VALUES (14, '14', '14');
  142. INSERT INTO table2 (id, ref_id, d)
  143. VALUES (15, '15', '15');
  144. INSERT INTO table2 (id, ref_id, d)
  145. VALUES (16, '16', '16');
  146. INSERT INTO table2 (id, ref_id, d)
  147. VALUES (17, '17', '17');
  148. INSERT INTO table2 (id, ref_id, d)
  149. VALUES (18, '18', '18');
  150. INSERT INTO table2 (id, ref_id, d)
  151. VALUES (19, '19', '19');
  152. INSERT INTO table2 (id, ref_id, d)
  153. VALUES (20, '20', '20');
  154. INSERT INTO table2 (id, ref_id, d)
  155. VALUES (21, '21', '21');
  156. INSERT INTO table2 (id, ref_id, d)
  157. VALUES (22, '22', '22');
  158. INSERT INTO table2 (id, ref_id, d)
  159. VALUES (23, '23', '23');
  160. INSERT INTO table2 (id, ref_id, d)
  161. VALUES (24, '24', '24');
  162. INSERT INTO table2 (id, ref_id, d)
  163. VALUES (25, '25', '25');
  164. INSERT INTO table2 (id, ref_id, d)
  165. VALUES (26, '26', '26');
  166. INSERT INTO table2 (id, ref_id, d)
  167. VALUES (27, '27', '27');
  168. INSERT INTO table2 (id, ref_id, d)
  169. VALUES (28, '28', '28');
  170. INSERT INTO table2 (id, ref_id, d)
  171. VALUES (29, '29', '29');
  172. INSERT INTO table2 (id, ref_id, d)
  173. VALUES (30, '30', '30');
  174. INSERT INTO table2 (id, ref_id, d)
  175. VALUES (31, '31', '31');
  176. INSERT INTO table2 (id, ref_id, d)
  177. VALUES (32, '32', '32');
  178. INSERT INTO table2 (id, ref_id, d)
  179. VALUES (33, '33', '33');
  180. INSERT INTO table2 (id, ref_id, d)
  181. VALUES (34, '34', '34');
  182. INSERT INTO table2 (id, ref_id, d)
  183. VALUES (35, '35', '35');
  184. INSERT INTO table2 (id, ref_id, d)
  185. VALUES (36, '36', '36');
  186. INSERT INTO table2 (id, ref_id, d)
  187. VALUES (37, '37', '37');
  188. INSERT INTO table2 (id, ref_id, d)
  189. VALUES (38, '38', '38');
  190. INSERT INTO table2 (id, ref_id, d)
  191. VALUES (39, '39', '39');
  192. INSERT INTO table2 (id, ref_id, d)
  193. VALUES (40, '40', '40');
  194. INSERT INTO table2 (id, ref_id, d)
  195. VALUES (41, '41', '41');
  196. INSERT INTO table2 (id, ref_id, d)
  197. VALUES (42, '42', '42');
  198. INSERT INTO table2 (id, ref_id, d)
  199. VALUES (43, '43', '43');
  200. INSERT INTO table2 (id, ref_id, d)
  201. VALUES (44, '44', '44');
  202. INSERT INTO table2 (id, ref_id, d)
  203. VALUES (45, '45', '45');
  204. INSERT INTO table2 (id, ref_id, d)
  205. VALUES (46, '46', '46');
  206. INSERT INTO table2 (id, ref_id, d)
  207. VALUES (47, '47', '47');
  208. INSERT INTO table2 (id, ref_id, d)
  209. VALUES (48, '48', '48');
  210. INSERT INTO table2 (id, ref_id, d)
  211. VALUES (49, '49', '49');