Updateable results grid in SQL Management Studio? -- sql server new users

Usenet User
6/8/2007 9:41:56 AM

In SQL Enterprise Manager (2000) I can right-click a table and then
select Open Table > Query. In this mode I can specify a query, execute
it and then edit the results right there in the grid. This gives me
quick-and-dirty way to modify data w/o much hassle.

Is there a way to do the above in SQL Management Studio 2005? If I
right-click a table on Object Explorer, it only gives me Open Table
option with no ability to filter the results...

Any suggestions?

John Bell
6/9/2007 2:27:00 AM

Hi

[quoted text, click to view]

If you use the Open Table option and right click the table you get an menu
that allows you show other panes such as SQL and Criteria which means you can
change the SQL used and add a where clause to restrict the data displayed.

HTH

sql server new users : Updateable results grid in SQL Management Studio?