Edit records in SQL Management Studio
Data queries in Microsoft SQL Server Management Studio can only open and edit the first 200 records.
With a trick you can edit more records.
Subject:
SQL Server Management Studio SSMS, SQL Server, SQL Query Query, Edit Top 200 Rows
Manual:
You open a table in SQL Server Studio with the right mouse button -> Edit Top 200 Rows
In the SQl query you change in the context menu (right mouse button) -> Pane-> SQL
Then you delete the top (200) completely or increase the 200 to a higher number
SELECT TOP (200) IDFolder, IDParent, IDArea, Title0, Title1, Text0, Text1, OrderNr, dtCreated, dtEdit FROM tblSYS_Folders |
With Context-> Execute SQL you can update the query
Then you can also change records that are above the limit of 200.
Further solution
At the end of the SQL statement, you can use WHERE to create a query or limit the amount of data
SELECT TOP (200) IDFolder, IDParent, IDArea, Title0, Title1, Text0, Text1, OrderNr, dtCreated, dtEdit FROM tblSYS_Folders WHERE IDFolder>1234 |