API tools faq
paste
Advertisement
Guest User

MCVE

a guest
Jan 12th, 2022
130
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.62 KB | None | 0 0
raw download clone embed print report
  1. DECLARE
  2. @sql AS NVARCHAR(MAX) = '',
  3. @someVar AS BIT
  4.  
  5. --First Chunk
  6. SET @sql = @sql +
  7. 'Line 1Line 1Line 1Line 1Line 1
  8. Line 2Line 2Line 2Line 2Line 2
  9.  
  10. Line 4Line 4Line 4Line 4Line 4
  11.  
  12. Line 6Line 6Line 6Line 6Line 6
  13. Line 7Line 7Line 7Line 7Line 7
  14. Line 8Line 8Line 8Line 8Line 8
  15.  
  16. Line 10Line 10Line 10Line 10Line 10
  17.  
  18. Line 12Line 12Line 12Line 12Line 12
  19.  
  20. Line 14Line 14Line 14Line 14Line 14
  21. Line 15Line 15Line 15Line 15Line 15
  22. Line 16Line 16Line 16Line 16Line 16
  23.  
  24. Line 18Line 18Line 18Line 18Line 18
  25.  
  26. Line 20Line 20Line 20Line 20Line 20
  27.  
  28. Line 22Line 22Line 22Line 22Line 22
  29. Line 24Line 24Line 24Line 24Line 24
  30. Line 23Line 23Line 23Line 23Line 23
  31.  
  32. Line 26Line 26Line 26Line 26Line 26
  33.  
  34. Line 28Line 28Line 28Line 28Line 28
  35.  
  36. Line 30Line 30Line 30Line 30Line 30
  37. Line 31Line 31Line 31Line 31Line 31Line 31
  38. Line 32Line 32Line 32Line 32Line 32Line 32
  39.  
  40. Line 34Line 34Line 34Line 34Line 34Line 34
  41.  
  42. Line 36Line 36Line 36Line 36Line 36Line 36
  43.  
  44. Line 38Line 38Line 38Line 38Line 38Line 38
  45. Line 39Line 39Line 39Line 39Line 39Line 39
  46. Line 40Line 40Line 40Line 40Line 40Line 40'
  47.  
  48. --Second Chunk
  49. IF 0 = 1 BEGIN
  50. SET @sql = @sql + '
  51. This doesn''t get appended, so it doesn''t matter what it says.'
  52. END
  53.  
  54. --Third Chunk
  55. SET @sql = @sql + '
  56.  
  57. Begin Chunk 3
  58. Line 43Line 43Line 43
  59. Line 44Line 44Line 44
  60. Line 45Line 45Line 45
  61. Line 46Line 46Line 46
  62. Line 47Line 47Line 47
  63. Line 48Line 48Line 48
  64. Line 49Line 49Line 49
  65. Line 50Line 50Line 50
  66. Line 51Line 51Line 51
  67. Line 52Line 52Line 52
  68. Line 53Line 53Line 53
  69. Line 54Line 54Line 54
  70. Line 55Line 55Line 55
  71. Line 56Line 56Line 56
  72. Line 57Line 57Line 57
  73. Line 58Line 58Line 58
  74. Line 59Line 59Line 59
  75. Line 60Line 60Line 60
  76. Line 61Line 61Line 61
  77. Line 62Line 62Line 62
  78. Line 63Line 63Line 63
  79. Line 64Line 64Line 64
  80.  
  81. Line 66Line 66Line 66
  82. Line 67Line 67Line 67
  83. Line 68Line 68Line 68
  84. Line 69Line 69Line 69
  85. Line 70Line 70Line 70
  86. Line 71Line 71
  87. Line 72Line 72
  88. End Chunk 3'
  89.  
  90. --Set some variable
  91. IF 1 = 1
  92. SET @someVar = 1
  93. ELSE SET @someVar = 2
  94.  
  95. --Fourth Chunk
  96. SET @sql = @sql + '
  97.  
  98. Begin Chunk 4
  99. Line 76 Line 76
  100. Line 77Line 77 Line 77
  101. Line NNLine NN Line NN
  102. Line NNLine NN Line NN
  103. Line NNLine NN Line NN
  104. Line NNLine NN Line NN
  105. Line NNLine NN Line NN
  106. Line NNLine NN Line NN
  107. Line NNLine NN Line NN
  108. Line NNLine NN Line NN
  109. Line NNLine NN Line NN
  110. Line NNLine NN Line NN
  111. Line NNLine NN Line NN
  112. Line NNLine NN Line NN
  113. Line NNLine NNLine NN Line NN
  114. Line NN Line NN
  115. Line NNLine NNLine NN Line NN
  116. Line NNLine NNLine NNLine NN
  117. Line NNLine NN
  118. Line NNLine NN
  119. Line NN Line NN
  120. Line NNLine NNLine NNLine NN
  121. Line NNLine NN
  122. Line NNLine NN
  123. Line NN Line NN
  124. Line NNLine NNLine NNLine NN
  125. Line NNLine NN
  126. Line NNLine NN
  127. Line NN Line NN
  128. Line NNLine NNLine NNLine NN
  129. Line NNLine NN
  130. Line NNLine NN
  131. Line NN Line NN
  132. Line NNLine NNLine NNLine NN
  133. Line NNLine NNLine NN
  134. Line NNLine NNLine NN
  135. Line NN Line NN
  136. Line NNLine NNLine NNLine NN
  137. Line NNLine NN
  138. Line NNLine NN
  139. Line NN Line NN
  140. --Line NNLine NNLine NNLine NN
  141. Line NN
  142. Line NNLine NNLine NN
  143. Line NNLine NNLine NN
  144. Line NNLine NNLine NN
  145. Line NNLine NNLine NN
  146. Line NNLine NN Line NN
  147. Line NNLine NN Line NN
  148. Line NNLine NN Line NN
  149. Line NN Line NN
  150. --Line NNLine NN Line NN
  151. Line NNLine NN Line NN
  152. Line NNLine NNLine NNLine NNLine NN
  153. Line NNLine NNLine NNLine NNLine NN Line NN
  154. Line NN Line NN
  155. Line NN Line NN
  156. Line NN Line NN
  157. Line NN Line NN
  158. Line NN Line NN
  159. Line NN Line NN
  160. Line NN Line NN
  161. Line NN Line NN
  162. Line NN Line NN
  163. Line NN Line NN
  164. Line NN Line NN
  165. Line NN Line NN
  166. Line NN Line NN
  167. Line NN Line NN
  168. Line NN Line NN
  169. Line NN Line NN
  170. Line NN Line NN
  171. Line NN Line NN
  172. Line NN Line NN
  173. Line NN Line NN
  174. Line NN Line NN
  175. Line NN Line NN
  176. Line NN Line NN
  177. Line NN Line NN
  178. Line NN Line NN
  179. Line NN Line NN
  180. Line NN Line NN
  181. Line NN Line NN
  182. Line NN Line NN
  183. Line NN Line NN
  184. Line NN Line NN
  185. Line NN Line NN
  186. Line NN Line NN
  187. Line NN Line NN
  188. Line NN Line NN
  189. Line NN Line NN
  190. Line NN Line NN
  191. Line NN Line NN
  192. Line NN Line NN
  193. Line NN Line NN
  194. Line NN Line NN
  195. Line NN Line NN
  196. Line NNLine NNLine NN Line NN
  197. Line NN Line NN
  198. Line NN Line NN
  199. Line NN Line NN
  200. Line NN Line NN
  201. Line NN Line NN
  202. Line NN Line NN
  203. Line NN Line NN
  204. Line NN Line NN
  205. Line NN Line NN
  206. Line NN Line NN
  207. Line NN Line NN
  208. Line NN Line NN
  209. Line NN Line NN
  210. Line NN Line NN
  211. Line NN Line NN
  212. Line NN Line NN
  213. Line NN Line NN
  214. Line NN Line NN
  215. Line NN Line NN
  216. Line NN Line NN
  217. Line NN Line NN
  218. Line NN Line NN
  219. Line NN Line NN
  220. Line NN Line NN
  221. Line NN Line NN
  222. Line NN Line NN
  223. Line NN Line NN
  224. Line NN Line NN
  225. Line NN Line NN
  226. Line NN Line NN
  227. Line NN Line NN
  228. Line NN Line NN
  229. Line NN Line NN
  230. Line NN Line NN
  231. Line NN Line NN
  232. Line NNLine NNLine NNLine NN
  233. Line NNLine NNLine NN Line NN
  234. Line NNLine NNLine NNLine NN
  235. Line NN
  236. Line NNLine NNLine NN Line NN
  237. Line NN Line NN
  238. Line NN Line NN
  239. Line NN Line NN
  240. Line NN Line NN
  241. Line NN Line NN
  242. Line NN Line NN
  243. Line NN Line NN
  244. Line NN
  245. Line NNLine NNLine NNLine NN Line NN
  246. Line NN
  247. Line NN Line NN
  248. Line NNLine NNLine NNLine NN Line NN
  249. Line 226 Line 226'
  250.  
  251. --For Debugging
  252. DECLARE
  253. @Printed INT = 0,
  254. @ToPrint INT = LEN(@sql)
  255.  
  256. WHILE @Printed < @ToPrint BEGIN
  257. PRINT(SUBSTRING(
  258. @sql, @Printed, 4000))
  259. SET @Printed = @Printed + 4000
  260. PRINT('Printed: ' + CONVERT(VARCHAR, @Printed))
  261. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!