How to update a field in a table via SSMS ?
Posted on 2014-10-16
I updated table in a db by right clicking and selecting Edit Top 200 Rows.
Then I realized I made a spelling error. missed a letter.
I did the same thing again, selecting Edit Top 200 Rows
In SQL Query pane the following shows:
SELECT TOP (200) SITE_ID, SITE_NAME, TIMEZONE
Then further down columns and rows
SITE_ID SITE_NAME TIMEZONE
1 FisingCO NULL
NULL NULL NULL
I add the change the FisingCO to FishingCO in row 1 above and hit the execute exclamation Icon but it doesn't update.
How do I get this updated for the first 200 columns. ( I know how to change 2000 to more from the Tools menu later if I need.)
Version info: (2008)
Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )