title: Generate UPDATE statement in SQL Server for specific table
body: <p>I'm wondering if there is a tool to generate the <code>UPDATE</code> statement based on data already inserted on a table. I know there is <code>MERGE</code> statement but I would like to know if I can do it from another way. I'm using SQL Server 2014</p>
  
  <p>Let's say I have a TableA:</p>
  
  <pre><code>Id int,
  Name nvarchar(50),
  Description nvarchar(100),
  Active bit
  </code></pre>
  
  <p>Then my TableA has this record and more:</p>
  
  <pre><code>Id   Name       Description   Active
  1    blablabla  sdjfhksj      1
  </code></pre>
  
  <p>I want to create the update statement for each row on this table</p>
  
  <pre><code>Update TableA
     set Name = 'blablabla',
         Description = 'sdjfhksj',
         Active = 1
   where Id = 1
  </code></pre>