Results 1 to 10 of 10

Thread: Views, Triggers, Normalization

  1. #1
    Contributing Member
    Join Date
    May 2006
    Answers
    78

    Views, Triggers, Normalization

    Can any body explain in detail for
    1. What is meant by Views, triggers, Normalization?
    2. what is purpose of views, triggers, Normalization in sql server?


  2. #2
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Views, Triggers, Normalization

    your question is toomuch theoritical to explain here. It is beyond the scope of this discussion to explain all that here.Please go through some good books ,mauals or u can find vast resources by little web searching


  3. #3
    Junior Member
    Join Date
    Jun 2007
    Answers
    4

    Re: Views, Triggers, Normalization

    Views aviews are nothing but saved sql statements, and are sometimes referred as “virtual tables”. Keep in mind that views cannot store data (except for indexed views); rather they only refer to data present in tables. Let’s checkout the basic syntax for creating a view: create view as