Writeable views

1 Jul 2006 3:29 AM

Just D

All,

I know that in some conditions the views can be writeable. Did anybody see
or maybe know the links where we can find this information in detail? I mean
if we have many tables in our views using INNER JOIN and we need to insert
some new data what are limitation for the writeable views? Are the views
always writeable, when we can't write into the views etc.?

I got one idea, I guess I can significantly simplify the whole DB SP logic
using this approach... But some details are still not clear.

Thanks,
Just D.

1 Jul 2006 5:42 AM

Tom Cooper

Look up CREATE VIEW in BOL, Scroll down and you will see a discussion of
"Updateable Views". It will show you the requirements.

Tom

"Just D" <no@spam.please> wrote in message

news:__lpg.8901$Nv.5472@fed1read10...
Show quote

> All,
>
> I know that in some conditions the views can be writeable. Did anybody see
> or maybe know the links where we can find this information in detail? I
> mean if we have many tables in our views using INNER JOIN and we need to
> insert some new data what are limitation for the writeable views? Are the
> views always writeable, when we can't write into the views etc.?
>
> I got one idea, I guess I can significantly simplify the whole DB SP logic
> using this approach... But some details are still not clear.
>
> Thanks,
> Just D.
>
>