Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've always used Edit Top 200 Rows and then edited the query in the SQL pane of SQL Server 2008 Management Studio to find the rows I want to edit data for.

Now I have the tools inside Visual Studio 2012. I want to be able to change the query after right-clicking a table and choosing "View Data", but I can't see that this is possible.

Has the "SQL Pane" feature been removed or am I not seeing something?

share|improve this question
up vote 1 down vote accepted

You are right. With SQL Server Data Tools (SSDT), which is the new Visual Studio experience, there is no possibility to change the query, today.

This feature may return in the future. If you need it now, you have to use SQL Server Management Studio (SSMS).

share|improve this answer
OK. Thanks for the info! – Johan Kronberg Sep 13 '12 at 14:14
SSDT appear to have gone backwards with this. In Visual Studio I used to be able to "Show Data", pop open the SQL pane, run a query and then directly edit the results. Now MS in their infinite wisdom have pulled this feature when working on a 2012 SQL DB instance. – QFDev Jul 23 '13 at 14:35

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.