• why query for step 2 result only 5 rows--

    What will the original SELECT * FROM VOrder_Details (Step 2 above) statement return when executed?

    As, I think that when we made any changes in any table then changes will get effected automatically into its corresponding view. Am i right or wrong?

    I am confused why step 2 return 5 columns...

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/