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 are the different types of backups that exist?
Explain what is dbcc?
How you can change a cross join into an inner join?
What is 'write-ahead log' in sql server 2000 ?
Explain the properties of subqueries in sql server?
What is open database communication (odbc)?
What are the advantages of user defined function?
What is difference between createstatement and preparedstatement?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
How can you insert values in multiple rows using one Insert statement?
Are semicolons required at the end of sql statements in sql server 2005?
How sql server enhances scalability of the database system?
How can you insert null values in a column while inserting the data?
Give the query of getting last two records from the table in SQL SERVER?
role of sql sever 2005 in database rather than any other database
