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.

How can you hide the sql server instances?

987

---

What is single-user mode?

886

---

How to install sql server 2005 express edition?

1070

---

How to modify existing triggers using "alter trigger"?

960

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

945

---

How to check parameter value in stored procedure sql server?

937

---

Can we write ddl in trigger?

884

---

How real and float literal values are rounded?

1114

---

Can a unique index be created on a column, which contains null?

894

---

What is SQL Server?

1162

---

What are the different types of replication are there in sql server 2000?

1004

---

What do you mean by normalisation?

988

---

When would you use it?

959

---

What is function of ROLLUP ?

1055

---

what method you can use to reduce the overhead of Reporting Services data sources?

244

---