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 is ms sql server triggers?

1019

---

Explain the difference between function and stored procedure?

950

---

what are the Prerequisites for Replication?

11359

---

What is the purpose of self join?

976

---

What is xdr?

996

---

How is foreign key related to primary key?

973

---

How extra digits are handled with numeric data type literals?

973

---

Where do we use trace frag?

1023

---

What is difference between index and primary key?

1103

---

Explain forward - only cursors?

1077

---

What is tablix?

165

---

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1173

---

Explain the concept of recursive stored procedure.

966

---

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

312

---

What is the native system stored procedure to execute a command against all databases?

1035

---