How to Directly Modify SQL Server Records from a Query Result?

Data and Databases
1

How can I update query results in SQL Server Management Studio without using the Edit Top 100 Rows option?

SELECT * FROM StudentData WHERE ID = 2;
2

hey, have u tried a straight update query? sometimes running update StudentData set field = newValue where id=2 works without deviceing into edit mode. facing any permission issues? what results are u seeing?

3

hey, you can run an update directly. if u have rights then try something like update StudentData set field = value where id =2. make sure the changes are testd first in a safe enviroment.