The default value for editing table only 200 rows, and the rest i have to do it using script. A bit tedious because i cannot actually read the data and edit it.
But here is the solution yey :D
Tools >Options >SQL Server Object Explorer, Expand this tree > ‘Commands’
I change the '200' to 0 , and i will get all data :)
No comments:
Post a Comment