Until now, I´ve been using parameterized updatable views to retrieve, edit and update records from some tables.

Let`s say, in a form with a grid, the grid is bounded to a view, so I only have to "requery" the view to retrieve data, and "tableupdate" the view to get records inserted, updated and deleted in the related table(s).

Now, I`m facing my first project using SQL-Server as a data Back end and my question are:

How (if possible) do I get the same functionality described above?

Are SQL-Server views updatable and "parameterizable"?

How do I get the base table(s) of a view updated from changes made to the view?

TIA.

Cristóbal.