asked on

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

tomfolinsbee

ASKER

i just saved the view as ViewA then wrote a query

Update ViewA
Set FieldA = Field2

tomfolinsbee

ASKER

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

Luan Jubica

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

Aneesh

Hi luani,

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

SOLUTION

Aneesh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Luan Jubica

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tomfolinsbee

ASKER

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!