Advantages
Views are used for several different reasons:
1.
To hide data complexity.
Instead of forcing your users to learn the T-SQL JOIN syntax you might wish to
provide a view that runs a commonly requested SQL statement.
2.
To protect the data. If
you have a table containing sensitive data in certain columns, you might wish
to hide those columns from certain groups of users....
Welcome
Prakash Chheatry
