Answer Posted / sanjeev kumar

CREATE VIEW Authorsview
AS
SELECT au_id, au_fname, au_lname, phone, state, contract
FROM authors
WHERE state = 'ca'

This is an updatable view and a user can change any column value
like:
UPDATE Authorsview SET state='NY'


Example: but when we create With Check Option then Same as
above but the state column cannot be changed.

CREATE VIEW Authorsview
AS
SELECT au_id, au_fname, au_lname, phone, state, contract
FROM authors
WHERE state = 'ca'
With Check Option

The view is still updatable, except for the state column:

UPDATE Authorsview SET state='NY'

This will cause an error and the state will not be changed
because we have use check option with state.

What are the indexes in sql server?

1023

---

What is transaction server auto commit?

984

---

What is the purpose of grouping data in a report?

907

---

Why use view instead of a table?

880

---

What are the new features of sql server 2008 r2 reporting service?

193

---

How to create new tables with "select ... Into" statements in ms sql server?

930

---

Can we use max in where clause?

880

---

how to avoid cursors? : Sql server database administration

904

---

What is 2nf example?

941

---

What is database black box testing?

984

---

How do I create a stored procedure in dbml?

927

---

Do you know what are the steps to process a single select statement?

918

---

What is exporting utility?

952

---

Do you know what is replace and stuff function in sql server?

940

---

How to insert and update data into a table with "insert" and "update" statements?

917

---