Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#

Edit data in SQL query

 

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

 

Mobile
»
Edit data in SQL query, on SQL Server Management Studio SSMS
»
SQL Server: Copying a table
»
SQL Server: Saving changes is not allowed.
»
SQL Server: Cancel Single User Mode
»
SQL Server: Datenbank kopieren mit Zwischenspeicher Teil 2 von 2
»
SQL Server: Datenbank kopieren mit Zwischenspeicher Teil 1 von 2
»
SQL Server: Datenbank Daten exportieren, Datenbank kopieren
»
Installation der SQLExpress Server Instanz
»
Installation des SQL Server Express in Deutsch auf Strato V-Server 2012
»
Eine neue Tabelle erstellen unter SQL Server (Express Edition) mit Autowert

.

Contact for Jobs, Project Requests: raimund.popp@microsoft-programmierer.de