edit records using SSMS

[iccsi]

SSMS has edit top 200 records from user interface.
I just wonder any way to use user interface to edit data more than 200
records?
Is it the only way to use UPDATE SQL to update records using SSMS?

Your information is great appreciated,


iccsi

[Erland Sommarskog]

Post by iccsi
SSMS has edit top 200 records from user interface.
I just wonder any way to use user interface to edit data more than 200
records?

I believe there is a setting to change this. The reason there is a 200
limit by default is that if you are casual and open a million row table,
you are asking for trouble.

Post by iccsi
Is it the only way to use UPDATE SQL to update records using SSMS?

UPDATE statements is certainly what I use.