Answer / 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.

Answer / 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.

Answer / naren

The CHECKPOINT statement saves time in a subsequent
recovery by creating a point at which all modifications to
data and log pages are guaranteed to have been written to
disk.

Checkpoints also occur:

When a database option is changed with ALTER DATABASE. A
checkpoint is executed in the database in which the option
is changed.


When a server is stopped, a checkpoint is executed in each
database on the server. These methods of stopping Microsoft
SQL Server 2000 checkpoint each database

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers   Satyam,

---

What are the differences between local and global temporary tables?

0 Answers  

---

What is outer join in sql server joins?

0 Answers  

---

What is a database in ms sql server?

0 Answers  

---

What do u mean by orphan users, how will u list them in the DB

2 Answers   IBM,

---

Do you know what are acid properties of transaction?

0 Answers  

---

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

0 Answers  

---

Is port 1433 secure?

0 Answers  

---

How to execute stored procedure and set temp table in sql server?

0 Answers  

---

explain different types of jions with examples briefly?

3 Answers   Zensar,

---

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

0 Answers  

---

What do you mean by SQL injection attack?

0 Answers   Ittiam Systems,

---