Visually edit records for any query using SQL Management Studio

home
database
view story

1 Kicks

Visually edit records for any query using SQL Management Studio(www.diaryofaninja.com)

submitted by wiredone(917) 1 year, 6 months ago

I watched an interesting thing take place the other day, in the form of someone using the visual tooling in SQL Management Studio to “Edit Top 200 rows” in a table, then realising that the record they wanted was not there, running a manual SELECT query to find the record, and then running a manual UPDATE command to edit the row. This can all be done a lot quicker using the same visual tooling they used in the first action – it’s just sneakily hidden in SQL Management Studio.

add a comment |category: Database |Views: 0
Tweet