sql server programming: Writeable views -- sql server programming

Writeable views

Just D
6/30/2006 8:29:06 PM

sql server programming: 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.

Re: Writeable views

Tom Cooper
7/1/2006 1:42:11 AM

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

Tom

[quoted text, click to view]