Community discussion forum

Updatable View in SQL Server 2005

  • 1 year ago

    Hello everyone,

     How can I create an updatable view in sql server 2005

    Thanks.

  • 1 year ago

    Bit of an open question there.

    However, just create a view from a table (as normal), and then use that in your update statement. As long as you don't compromise RI you should find that its  updatable.

    Joe 

Post a reply

Enter your message below

Sign in or Join us (it's free).

Want to stay in touch with what's going on? Follow us on twitter!