title: Generate a random 9 digit number
body: <p>I am trying to generate a random 9 digit number</p>
  
  <p>for example <code>0987654321</code> note that each digit appear once..</p>
  
  <p>i tried this :</p>
  
  <pre><code>select convert(numeric(10,0),rand() * 8999999999) + 10000000
  </code></pre>
  
  <p>it generates but at some point numbers repeat. but it is client need to make sure in 9 digit sequence no number appears twice..</p>
  
  <p>required output like this..</p>
  
  <pre><code>1234567890
  9870654321
  1234098567
  8976543120
  </code></pre>