Databases
StackOverflow2013
Postsdbo
POVisual Studio SQL Server design and inline editing features missing
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POVisual Studio SQL Server design and inline editing features missing
    primarykey
    data
    text
    <p>In Visual Studio 2012 I have two database connections configured in the Server Explorer. One is for a SQL Server 2008 R2 database, the other is for a SQL Server 2012 database. I've always been able to make quick inline edits to the data with SQL 2008 databases by right clicking on the table and selecting "Show Table Data".</p> <p><img src="https://i.stack.imgur.com/9S8Hu.png" alt="Show Table Data command"></p> <p>I could then pop open the SQL pane and query the data, put a cursor directly in the field and edit the data in the result set. I relied on this method heavily when making quick edits to the data without the need to script.</p> <p><img src="https://i.stack.imgur.com/Rnfmq.png" alt="Inline editing of data"></p> <p>It seems this option is not available for SQL Server 2012 connections. When I try to do the same it seems to open in the context of SQL Server Database Tools (SSDT). I will see an initial result set of 1000 records but unlike SQL 2008 no way simple way to run a more precise SELECT query and edit data inline by selecting and overwriting values in the result set. The screenshot below is the closest I can get by directly opening the new query window, but still no way to inline edit the results.</p> <p><img src="https://i.stack.imgur.com/PTWUF.png" alt="SSDT Window with no way to edit"></p> <p>Is it possible to get the 2012 database to behave like the 2008 database in Visual Studio? Did I miss a component on the installation of SQL 2012 that is preventing this behaviour? Or has Microsofts pulled these features away? I desperately want to get inline editing back, I don't want to have to write UPDATE queries to correct single lines of data, it's slower and it seems riskier.. if a clause is inadvertently missed it could end up corrupting a lot of data?</p> <p>Any thoughts would be much appreciated.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USQFDev
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POVisual Studio SQL Server design and inline editing features missing
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POVisual Studio SQL Server design and inline editing features missing
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POVisual Studio SQL Server design and inline editing features missing
      1. This table or related slice is empty.
      1. VTUpMod
    1. COTry right-clicking a table and selecting "Edit top 200 rows". That might work.
      singulars
      1. POVisual Studio SQL Server design and inline editing features missing
      1. USPeter Schott
    2. COWhere are you seeing "Edit top 200 rows"? I can't find this option anywhere in Visual Studio only SSMS.
      singulars
      1. POVisual Studio SQL Server design and inline editing features missing
      1. USQFDev
    3. COSQL Server Object Explorer from within SSDT, right-click a table, select "View Data". I was thinking SSMS 2012, but I just checked this in SSDT using the VS2012 shell.
      singulars
      1. POVisual Studio SQL Server design and inline editing features missing
      1. USPeter Schott
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload