Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dohamsg
Starting Member
22 Posts |
 Posted - 2008-10-31 : 12:22:27
|
| Hi, SQL Server 2005.CREATE MyView AS SELECT table1.col1, table1.col2, table2.colX ...GOUpdate myView SET Col1 = <>, Col2 = <>Though Col1 and Col2 belongs to the same table, and listed first in the view; the update command fails, saying something like : "multi table"Should I specify which table is updatable, if so please tell me what's the command to achieve that.Thanks indeed. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-31 : 12:26:46
|
| either try to update the base table directly and if you really want to update it through view, create an INSTEAD OF UPDATE trigger on view which will cause update to base table from its code inside. |
 |
|
|
|
|
|
How to update one table in multitable view?