title: How do I generate row number without using rownum() in sql server
body: <p>I have the following table:</p>
  
  <pre><code>CREATE table prd
  (
  prdid varchar(10)
  )
  insert into prd values ('prd1011'),('prd1023'),('prd4532'),('prd2341')
  </code></pre>
  
  <p>I need to return the same with rownumber without using ROWNUM() built in function.
  Is that possible?</p>