Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
547 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
How to Edit all Records in a SQL Server 2008 Table |
---|
This blog explains how you can get access to all of the records in a SQL Server 2008 table when you try to edit them, rather than just the top 200. |
In SQL Server when you choose to view or edit the records in a table you can only do so to a limited number of records.
By default, when you right-click on a table you can only view the first 1000 and edit the top 200 records in a table.
Fortunately, you can change a setting to allow you to view and edit all the records. To do this, from the menu choose: Tools -> Options...
Expand the SQL Server Object Explorer group and click Commands. Change the Table and View Options shown here to any number you like. If you enter a value of 0 you will see all of the records in a table.
Once you've done this you can right-click on a table and view or edit all of the records in a table.
Now you can view or edit an entire table.
It's annoying to have to do this, but at least now you know how to!
Some other pages relevant to the above blog include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.