Select fro edit in Management studio 1

[serializer]

I have a lot of changes that I need to do manually. I have a very specific query I want to perform to pinpoint rows I need to edit. How can I make the grid editable on my custom query?

I know that I can select "Edit Top N rows" but I do not want all rows, just rows from my specific query. There must be some kind of way to write the query so that the grid is editable - how?

Thanks

 

[gmmastros]

In SQL Server Management studio...

Right click your table, and click Edit Top N Rows.
Right Click in the grid, click Pane, Click SQL
This will split the screen vertically with the SQL at the top and the rows below. You can change the number in the "top" part, and you can add a where clause.
After changing the sql, right click in the sql pane and click "Execute SQL".


-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[serializer]

Thank you!