Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SSMS and Edit Top 200 rows
Message
From
21/05/2021 20:32:54
 
 
To
21/05/2021 17:42:25
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
01680651
Message ID:
01680676
Views:
56
This message has been marked as the solution to the initial question of the thread.
>>I just tried it...all I had to do was make sure I had hit ENTER after the change....and for safety sake, I click down to the next row. Not sure if that's needed, but I just realized I've always done that out of habit.
>>
>>But no, I didn't need to click SAVE. I made the change, went to another row, and then closed the dialog.
>>
>>Again, have only used that once in a great while, but don't recall ever having a problem with it.
>
>That's the problem. If the table has only record, the change is not committed. In order for the change to be committed, it has to have at least two records so the move into another record makes the save.

In "Edit 200 rows" mode, SSMS always shows an additional row filled with NULLs. You can go to that row to save your changes.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform