SQL Server Performance

How to Edit Result Pane Rows

Discussion in 'SQL Server 2008 General DBA Questions' started by tolgay.gul, Nov 24, 2009.

  1. tolgay.gul New Member

    Hi,
    Eventhough joined tables we are able to edit result pane's rows on SQL 2000 Server EnterpriseManager (select * from a, b where a.id=b.id)
    Isthere any way to edit joined tables query's result on result pane via SSMS? We can edit one table's data with "Edit top 2000 Rows" but when we add atable and join it to the first table the result pane data is changed read only mode.
    The same query’s results can be edited on Ent.Man but It can’t bedone on SSMS (SQL Server Manager Studio).
    http://technet.microsoft.com/en-us/library/ms186382%28SQL.90%29.aspx
    The article says "Queries that include columns from more than one table or view can't be updated" What is your opinion about it?

    Do you have any comments how to edit the results without writingupdate query?
    Thx,
    Tolgay Gul
  2. FrankKalis Moderator

    Welcome to the forum!
    To be honest, SSMS is not the tool of choice for such data manipulation. Maybe it's better to get into the habit to write UPDATE statements?

Share This Page