Updating a view using sql server management studio

Posted on 2006-03-29
Last Modified: 2013-12-03
With SQL Server 2000 enterprise manager, I could create a view, then right click to get options for using the view for updating, insert into etc.

This doesn't seem to be available with SQL Server Management studio.

Am i missing some easy to use feature, or do i have to do it in the SQL mode, rather than designer mode?

If so, what's the syntax?

View format is like this:

Select A.Field1, B.Field2
From A join B on A.ID = B.ID

I want to update A.Field1 = B.Field2


Question by:tomfolinsbee

    Author Comment

    i just saved the view as ViewA then wrote a query

    Update ViewA
    Set FieldA = Field2

    Author Comment

    Still interested to knowif I'm missing something in the design view...
    LVL 7

    Expert Comment

    you can do right-click then "Open View". Is that you mean?
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    Hi luani,

    Exoand your database,
    expand  views on the left pane -> Right click on viewA and select modify ...
    LVL 75

    Assisted Solution

    by:Aneesh Retnakaran
    This will also give a graphical view (as we see in enterprise manager -> design Query ).. you can select / deselect  whatever fields u need..
    LVL 7

    Accepted Solution

    Hi aneeshattingal,

    I answered the very first question. And yes I missed the full way of "Open View" ;)
    I agree with your suggestion.

    Author Comment

    Thanks everyone... the feature i was looking for was the ability to change a select statment into an update /insert into/ insert fromt statement.
    With Enterprise manager you click on the name of  view and get an option to convert to various types of queries in design mode. Quite handy if, like me, you don't remember the syntax for these other queries. Time to learn them properly!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Viewers will learn how the fundamental information of how to create a table.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now