title: Can I generate an INSERT statement in SQL Server 2008 with the selected values?
body: <p>If I am selecting a whole row from the Results pane of the SQL Server Management Studio 2008, is there a way to create an INSERT statement script automatically that can INSERT a new row with the selected row's values?</p>
  
  <p>Idea is, when I delete that row, I can use the generated INSERT statement to re-insert the same row again.</p>
  
  <p>Basically instead of creating a blank INSERT, create a script with <code>VALUES (val1,val2,val3...)</code> where the values comes from the selected row.</p>