title: Changing Alias name dynamically
body: <p>While I was working on a small task I came across a situation </p>
  
  <pre><code>DECLARE   @i  INT ,
      @l  INT ,
      @desc  CHAR(50)
  
  SET    @l = 1 
  SET    @i = 20
  WHILE   ( @l &lt;= @i ) 
  BEGIN
    SELECT  'Test'   AS   'Test'+@l
    SET @l =   @l  +  1
  END
  </code></pre>
  
  <p>In this code I want when a loop run all time column name changed with the value of @l.</p>