Post reply

Views

  • 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?

  • May 8, 2010 at 11:34 am

    #1164589

    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
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

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

  • May 8, 2010 at 7:45 pm

    #1164645

    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)
    Intro to Tally Tables and Functions

  • May 8, 2010 at 7:51 pm

    #1164646

    Can you please give me examples on

    a) Non-Updateable Views

    b) Updateable Views

  • May 8, 2010 at 8:16 pm

    #1164653

    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)
    Intro to Tally Tables and Functions

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

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