Updating a view using sql server management studio

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

Thanks


tomfolinsbeeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tomfolinsbeeAuthor Commented:
i just saved the view as ViewA then wrote a query

Update ViewA
Set FieldA = Field2
0
tomfolinsbeeAuthor Commented:
Still interested to knowif I'm missing something in the design view...
0
Luan JubicaProject ManagerCommented:
you can do right-click then "Open View". Is that you mean?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Aneesh RetnakaranDatabase AdministratorCommented:
Hi luani,

Exoand your database,
expand  views on the left pane -> Right click on viewA and select modify ...
0
Aneesh RetnakaranDatabase AdministratorCommented:
This will also give a graphical view (as we see in enterprise manager -> design Query ).. you can select / deselect  whatever fields u need..
0
Luan JubicaProject ManagerCommented:
Hi aneeshattingal,

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tomfolinsbeeAuthor Commented:
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!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Fonts Typography

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.