Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / guest
When you use this option to create a view with a where
condition, the system wont allow to perform any action which
will invalidate the definition of the view.
ex:
create view test
as
select firstname,lastname from Employees where sal<10000
with Check option
If this returns 10 rows when you are updating the view if
any action is being done which updates the sal so that the
view returns lesser number of records is not allowed.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is openrowset sql server?
how to trace the traffic hitting a sql server? : Sql server database administration
when would you go for denormalization? : Sql server database administration
How to execute a stored procedure in ms sql server?
Why variables called the most powerful component of ssis?
what are triggers? : Sql server database administration
What is inner join? Explain with an example?
what is the difference between Tabular and Matrix report?
What is sql language?
Is BCNF better than 2NF & 3NF? Why?
Explain what is use of dbcc commands?
Can you pass expressions to function parameters?
Tell me what do we need queues in sql service broker?
How exceptions can be handled in sql server programming?
Why do we need different type of parameter?
