Sqlserver edits data in the query interface (similar to Oracle's edit and ROWID)

SQLserver Edit row data for specific conditions ## similar oracle Of edit and rowid

1. Recently, I've been doing... For engineers MES When the project is , It is found that the engineering personnel have modified sqlserver Requirements for specific condition data , similar oracle Of edit and rowid sentence . Then I found some information on the Internet , Find that they are not what they want . Later on Microsoft sqlserver Management tools Can achieve .

1. Open the table that needs to be modified , Click before selection 200 That's ok ,

2.（ The most important step ）, Right click the open pre edit 200 Row data , Select the pane , Then choose SQL

3. Now we can modify it here before 200 Row data , But it's not what we want . We just need to add our own restrictions to this specific window .

4. for example , I need to modify name=1232131 The data of . Write down your terms SQL, Then right-click and select execute SQL

SELECT   Id, Name FROM   Table_1 WHERE   (Name = '1232131 ')

As above, you have modified the specific condition data you want to modify .

Important points ： Before the revision 200 Modify this condition in the window of line SQL sentence , Change to your own specific conditions SQL Sentence can be used .**（ Make sure you don't copy this SQL Modify in the new query interface , Otherwise, it's just a query statement , Data cannot be modified ）*** *.

here sqlserver Of tools The tools that operate on the database tables are not good , Personal recommendations **navicat Tools **,navicat Can quickly modify the table data of specific conditions , And it also supports importing , Export function .