Community discussion forum

Updatable View in SQL Server 2005

• • Reply

  1 year ago

  by Goodway

  Goodway

  , United States

  Joined 5 years ago

  Hello everyone,

   How can I create an updatable view in sql server 2005

  Thanks.

  Report abuse
• • Reply

  1 year ago

  by joe90

  J Alan

  , United Kingdom

  Joined 4 years 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 

  Report abuse