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/