Readdy Write

Edit data in SQL query

08.11.2018 (๐Ÿ‘4889)


 

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

 


0,00 €