How do I create an updateable view?

• rconway-574047

  Mr or Mrs. 500

  Points: 522

  More actions

  January 15, 2009 at 7:14 am

  #383738

  We used to have SQL Server 2000 and then we upgraded to 2005. I had a couple of views in 2000 where we could put in a filter and run the view and then manually update the results. Using those same query views in 2005 does not react in the same way. All cells are read only. Is there a way to make the views in 2005 updateable?

  Thanks in advance!!

  RC

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  January 15, 2009 at 7:55 am

  #927324

  Make sure you include the primary key for each and one table involved in view.

  ---

  N 56°04'39.16"
  E 12°55'05.25"