title: Audit trigger in sql azure
body: <p>I added a trigger to the table to copy the inserted data to an audit table. </p>
  
  <ul>
  <li>I got all the column names of the table from INFORMATION_SCHEMA.</li>
  <li>I used "SELECT * INTO #INSERTED FROM INSERTED" to copy inserted data to a temporary table.</li>
  <li><p>Then used the following dynamic query to get the data from temporary table for each column.</p>
  
  <p>SET @sqlText = N'SELECT ' + @ColName + ' FROM #INSERTED'</p></li>
  </ul>
  
  <p>where @ColName is the column name.</p>
  
  <p>It was working fine with sql server 2008.
  Now we moved to sql azure. <code>select into</code> is not supported in sql azure. I cannot create a temporary table and then use insert on it, as my table contains over 70 columns and also, I cannot use <code>INSERTED</code> table for a dynamic query. </p>
  
  <p>So, please suggest any solution\workaround for it.</p>