title: There is a way to generate a list of GUID's using NEWID function?
body: <p>I need to create a list of GUID's in SQL Server 2008 R2 and I am using the <code>NEWID()</code> function.</p>
  
  <p>This is what I am trying but I just get only one ID:</p>
  
  <pre><code>SELECT TOP 100 NEWID() 
  </code></pre>
  
  <p>I am new to SQL Server and I don't know if there is a way to do that or a way to create a loop for do it.</p>
  
  <p>I don't need to persist those GUID's I just want to show them on screen.</p>