Skip to content

Instantly share code, notes, and snippets.

@zippy1981

zippy1981/random_250x22000.sql

Created July 7, 2011 18:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save zippy1981/1070131 to your computer and use it in GitHub Desktop.
Save zippy1981/1070131 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
random_250x22000.sql
DROP TABLE etr;
GO
CREATE TABLE etr (
col_1 real NOT NULL,
col_2 real NOT NULL,
col_3 real NOT NULL,
col_4 real NOT NULL,
col_5 real NOT NULL,
col_6 real NOT NULL,
col_7 real NOT NULL,
col_8 real NOT NULL,
col_9 real NOT NULL,
col_10 real NOT NULL,
col_11 real NOT NULL,
col_12 real NOT NULL,
col_13 real NOT NULL,
col_14 real NOT NULL,
col_15 real NOT NULL,
col_16 real NOT NULL,
col_17 real NOT NULL,
col_18 real NOT NULL,
col_19 real NOT NULL,
col_20 real NOT NULL,
col_21 real NOT NULL,
col_22 real NOT NULL,
col_23 real NOT NULL,
col_24 real NOT NULL,
col_25 real NOT NULL,
col_26 real NOT NULL,
col_27 real NOT NULL,
col_28 real NOT NULL,
col_29 real NOT NULL,
col_30 real NOT NULL,
col_31 real NOT NULL,
col_32 real NOT NULL,
col_33 real NOT NULL,
col_34 real NOT NULL,
col_35 real NOT NULL,
col_36 real NOT NULL,
col_37 real NOT NULL,
col_38 real NOT NULL,
col_39 real NOT NULL,
col_40 real NOT NULL,
col_41 real NOT NULL,
col_42 real NOT NULL,
col_43 real NOT NULL,
col_44 real NOT NULL,
col_45 real NOT NULL,
col_46 real NOT NULL,
col_47 real NOT NULL,
col_48 real NOT NULL,
col_49 real NOT NULL,
col_50 real NOT NULL,
col_51 real NOT NULL,
col_52 real NOT NULL,
col_53 real NOT NULL,
col_54 real NOT NULL,
col_55 real NOT NULL,
col_56 real NOT NULL,
col_57 real NOT NULL,
col_58 real NOT NULL,
col_59 real NOT NULL,
col_60 real NOT NULL,
col_61 real NOT NULL,
col_62 real NOT NULL,
col_63 real NOT NULL,
col_64 real NOT NULL,
col_65 real NOT NULL,
col_66 real NOT NULL,
col_67 real NOT NULL,
col_68 real NOT NULL,
col_69 real NOT NULL,
col_70 real NOT NULL,
col_71 real NOT NULL,
col_72 real NOT NULL,
col_73 real NOT NULL,
col_74 real NOT NULL,
col_75 real NOT NULL,
col_76 real NOT NULL,
col_77 real NOT NULL,
col_78 real NOT NULL,
col_79 real NOT NULL,
col_80 real NOT NULL,
col_81 real NOT NULL,
col_82 real NOT NULL,
col_83 real NOT NULL,
col_84 real NOT NULL,
col_85 real NOT NULL,
col_86 real NOT NULL,
col_87 real NOT NULL,
col_88 real NOT NULL,
col_89 real NOT NULL,
col_90 real NOT NULL,
col_91 real NOT NULL,
col_92 real NOT NULL,
col_93 real NOT NULL,
col_94 real NOT NULL,
col_95 real NOT NULL,
col_96 real NOT NULL,
col_97 real NOT NULL,
col_98 real NOT NULL,
col_99 real NOT NULL,
col_100 real NOT NULL,
col_101 real NOT NULL,
col_102 real NOT NULL,
col_103 real NOT NULL,
col_104 real NOT NULL,
col_105 real NOT NULL,
col_106 real NOT NULL,
col_107 real NOT NULL,
col_108 real NOT NULL,
col_109 real NOT NULL,
col_110 real NOT NULL,
col_111 real NOT NULL,
col_112 real NOT NULL,
col_113 real NOT NULL,
col_114 real NOT NULL,
col_115 real NOT NULL,
col_116 real NOT NULL,
col_117 real NOT NULL,
col_118 real NOT NULL,
col_119 real NOT NULL,
col_120 real NOT NULL,
col_121 real NOT NULL,
col_122 real NOT NULL,
col_123 real NOT NULL,
col_124 real NOT NULL,
col_125 real NOT NULL,
col_126 real NOT NULL,
col_127 real NOT NULL,
col_128 real NOT NULL,
col_129 real NOT NULL,
col_130 real NOT NULL,
col_131 real NOT NULL,
col_132 real NOT NULL,
col_133 real NOT NULL,
col_134 real NOT NULL,
col_135 real NOT NULL,
col_136 real NOT NULL,
col_137 real NOT NULL,
col_138 real NOT NULL,
col_139 real NOT NULL,
col_140 real NOT NULL,
col_141 real NOT NULL,
col_142 real NOT NULL,
col_143 real NOT NULL,
col_144 real NOT NULL,
col_145 real NOT NULL,
col_146 real NOT NULL,
col_147 real NOT NULL,
col_148 real NOT NULL,
col_149 real NOT NULL,
col_150 real NOT NULL,
col_151 real NOT NULL,
col_152 real NOT NULL,
col_153 real NOT NULL,
col_154 real NOT NULL,
col_155 real NOT NULL,
col_156 real NOT NULL,
col_157 real NOT NULL,
col_158 real NOT NULL,
col_159 real NOT NULL,
col_160 real NOT NULL,
col_161 real NOT NULL,
col_162 real NOT NULL,
col_163 real NOT NULL,
col_164 real NOT NULL,
col_165 real NOT NULL,
col_166 real NOT NULL,
col_167 real NOT NULL,
col_168 real NOT NULL,
col_169 real NOT NULL,
col_170 real NOT NULL,
col_171 real NOT NULL,
col_172 real NOT NULL,
col_173 real NOT NULL,
col_174 real NOT NULL,
col_175 real NOT NULL,
col_176 real NOT NULL,
col_177 real NOT NULL,
col_178 real NOT NULL,
col_179 real NOT NULL,
col_180 real NOT NULL,
col_181 real NOT NULL,
col_182 real NOT NULL,
col_183 real NOT NULL,
col_184 real NOT NULL,
col_185 real NOT NULL,
col_186 real NOT NULL,
col_187 real NOT NULL,
col_188 real NOT NULL,
col_189 real NOT NULL,
col_190 real NOT NULL,
col_191 real NOT NULL,
col_192 real NOT NULL,
col_193 real NOT NULL,
col_194 real NOT NULL,
col_195 real NOT NULL,
col_196 real NOT NULL,
col_197 real NOT NULL,
col_198 real NOT NULL,
col_199 real NOT NULL,
col_200 real NOT NULL,
col_201 real NOT NULL,
col_202 real NOT NULL,
col_203 real NOT NULL,
col_204 real NOT NULL,
col_205 real NOT NULL,
col_206 real NOT NULL,
col_207 real NOT NULL,
col_208 real NOT NULL,
col_209 real NOT NULL,
col_210 real NOT NULL,
col_211 real NOT NULL,
col_212 real NOT NULL,
col_213 real NOT NULL,
col_214 real NOT NULL,
col_215 real NOT NULL,
col_216 real NOT NULL,
col_217 real NOT NULL,
col_218 real NOT NULL,
col_219 real NOT NULL,
col_220 real NOT NULL,
col_221 real NOT NULL,
col_222 real NOT NULL,
col_223 real NOT NULL,
col_224 real NOT NULL,
col_225 real NOT NULL,
col_226 real NOT NULL,
col_227 real NOT NULL,
col_228 real NOT NULL,
col_229 real NOT NULL,
col_230 real NOT NULL,
col_231 real NOT NULL,
col_232 real NOT NULL,
col_233 real NOT NULL,
col_234 real NOT NULL,
col_235 real NOT NULL,
col_236 real NOT NULL,
col_237 real NOT NULL,
col_238 real NOT NULL,
col_239 real NOT NULL,
col_240 real NOT NULL,
col_241 real NOT NULL,
col_242 real NOT NULL,
col_243 real NOT NULL,
col_244 real NOT NULL,
col_245 real NOT NULL,
col_246 real NOT NULL,
col_247 real NOT NULL,
col_248 real NOT NULL,
col_249 real NOT NULL,
col_250 real NOT NULL
);
DECLARE @i int
SET @i=0
WHILE @i < 22000
BEGIN
INSERT INTO etr (
col_1,
col_2,
col_3,
col_4,
col_5,
col_6,
col_7,
col_8,
col_9,
col_10,
col_11,
col_12,
col_13,
col_14,
col_15,
col_16,
col_17,
col_18,
col_19,
col_20,
col_21,
col_22,
col_23,
col_24,
col_25,
col_26,
col_27,
col_28,
col_29,
col_30,
col_31,
col_32,
col_33,
col_34,
col_35,
col_36,
col_37,
col_38,
col_39,
col_40,
col_41,
col_42,
col_43,
col_44,
col_45,
col_46,
col_47,
col_48,
col_49,
col_50,
col_51,
col_52,
col_53,
col_54,
col_55,
col_56,
col_57,
col_58,
col_59,
col_60,
col_61,
col_62,
col_63,
col_64,
col_65,
col_66,
col_67,
col_68,
col_69,
col_70,
col_71,
col_72,
col_73,
col_74,
col_75,
col_76,
col_77,
col_78,
col_79,
col_80,
col_81,
col_82,
col_83,
col_84,
col_85,
col_86,
col_87,
col_88,
col_89,
col_90,
col_91,
col_92,
col_93,
col_94,
col_95,
col_96,
col_97,
col_98,
col_99,
col_100,
col_101,
col_102,
col_103,
col_104,
col_105,
col_106,
col_107,
col_108,
col_109,
col_110,
col_111,
col_112,
col_113,
col_114,
col_115,
col_116,
col_117,
col_118,
col_119,
col_120,
col_121,
col_122,
col_123,
col_124,
col_125,
col_126,
col_127,
col_128,
col_129,
col_130,
col_131,
col_132,
col_133,
col_134,
col_135,
col_136,
col_137,
col_138,
col_139,
col_140,
col_141,
col_142,
col_143,
col_144,
col_145,
col_146,
col_147,
col_148,
col_149,
col_150,
col_151,
col_152,
col_153,
col_154,
col_155,
col_156,
col_157,
col_158,
col_159,
col_160,
col_161,
col_162,
col_163,
col_164,
col_165,
col_166,
col_167,
col_168,
col_169,
col_170,
col_171,
col_172,
col_173,
col_174,
col_175,
col_176,
col_177,
col_178,
col_179,
col_180,
col_181,
col_182,
col_183,
col_184,
col_185,
col_186,
col_187,
col_188,
col_189,
col_190,
col_191,
col_192,
col_193,
col_194,
col_195,
col_196,
col_197,
col_198,
col_199,
col_200,
col_201,
col_202,
col_203,
col_204,
col_205,
col_206,
col_207,
col_208,
col_209,
col_210,
col_211,
col_212,
col_213,
col_214,
col_215,
col_216,
col_217,
col_218,
col_219,
col_220,
col_221,
col_222,
col_223,
col_224,
col_225,
col_226,
col_227,
col_228,
col_229,
col_230,
col_231,
col_232,
col_233,
col_234,
col_235,
col_236,
col_237,
col_238,
col_239,
col_240,
col_241,
col_242,
col_243,
col_244,
col_245,
col_246,
col_247,
col_248,
col_249,
col_250
) VALUES ( RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND(),
RAND()
)
SET @i=@i+1
--PRINT 'ROW #' + CAST(@i AS varcharmax())
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment