title: How to edit SQL records using Select statement
body: <p>I got like 2000 rows of data, when I do select statement I can narrow my query but I cant change any value, as I have to change 50 columns, I dont want to use Update Command as then because values I have to update for each row is unique.</p>
  
  <p>Anyone knows any easier way of selecting data using select command and then edit it.</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>I just went to SQL Management studio, clicked on DB I am working on then find the table, I right clicked on it and then it says "Select top 1000 rows" so Now I can see the query and the data, I added  "Where" into query and got what I wanted, but I cant modify the table rows below :S</p>
  
  <p>*<em>Edit 2 *</em></p>
  
  <p>Or I can develop a Utility that will take Table Name , Column Name and its New value and simply updates it :)</p>