Updating a view using sql server management studio
Posted on 2006-03-29
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