Views

Question

Views

satishthota

SSC Eights!

Points: 959
More actions
May 8, 2010 at 10:48 am

#386884

What is the difference between Non-Updateable Views and Updateable Views in SQL server?
Please Give me with examples?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeffrey Williams SSC Guru Points: 90301 More actions · Answer 1

One you can use an update statement to update the data, the other you can't. 😉

If you need additional information, please specify exactly what issue you are having and what you have tried so far to fix it.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

Jeff Moden SSC Guru Points: 1004284 More actions · Answer 2

satishthota (5/8/2010)
What is the difference between Non-Updateable Views and Updateable Views in SQL server?
Please Give me with examples?

Actually, this is covered in Books Online far better than any of us could. It explains what makes certain views non-updateable. Books Online is the free help system that comes with SQL Server. Give it a try....

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

satishthota SSC Eights! Points: 959 More actions · Answer 3

Can you please give me examples on

a) Non-Updateable Views

b) Updateable Views

Jeff Moden SSC Guru Points: 1004284 More actions · Answer 4

satishthota (5/8/2010)
Can you please give me examples on
a) Non-Updateable Views
b) Updateable Views

Ummm... since I think this is a test question or maybe an interview question, I really need you to show that you're willing to help yourself by looking it up in Books Online like I suggested.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)