title: Generate random int value from 3 to 6
body: <p>Is it possible in Microsoft SQL Server generate random int value from Min to Max (3-9 example, 15-99 e.t.c)</p>
  <p>I know, I can generate from 0 to Max, but how to increase Min border?</p>
  <p>This query generate random value from 1 to 6. Need to change it from 3 to 6.</p>
  <pre><code>SELECT table_name, 1.0 + floor(6 * RAND(convert(varbinary, newid()))) magic_number 
  FROM information_schema.tables
  </code></pre>
  <p><strong>Added 5 sec later</strong>:</p>
  <pre><code>SELECT table_name, 3.0 + floor(4 * RAND(convert(varbinary, newid()))) magic_number 
  FROM information_schema.tables
  </code></pre>