Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SSMS and Edit Top 200 rows
Message
De
21/05/2021 20:32:54
 
 
À
21/05/2021 17:42:25
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
01680651
Message ID:
01680676
Vues:
57
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform