title: Edit selected rows manually in SQL Server
body: <p>I have a database in which some editing operations have to be done manually on some rows. I have the SQL Server Management Studio Express. In SSMS, to edit the rows, normally the option is:</p>
  
  <p><code>Select DB &gt; Table &gt; Right Click &gt; Edit top 200 rows</code></p>
  
  <p>But, the problem here is that I only have to edit some selected rows. I am able to retrieve these selected rows by the following query:</p>
  
  <pre><code>/****** Script for SelectTopNRows command from SSMS  ******/
  SELECT *
    FROM [test].[dbo].[Sheet1] WHERE Item1 IS NULL OR Item2 IS NULL
  </code></pre>
  
  <p>Now, I have to perform some edit operations (moving some data from some columns to others) which can't be performed with a query because of no single observable pattern for editting. So, the question remains, how can I get these rows in edit mode to do my task?</p>