Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of using views. Why do we need
views when we have SPs?
- 4 Answers
- 16591 Views
- 247Customer, I also Faced
- E-Mail Answers
Answer Posted / saurabh
View are the image of table.
advantages:- 1> they hide the details of table from which
they get data.
2> they are working as table and, provide security from
unautherized acccess.
3> they are read only.
4> they update automatically when some changes occurs in
original table
| Is This Answer Correct ? | 23 Yes | 3 No |
Post New Answer View All Answers
what protocol both networks use? : Sql server database administration
What is a select query statement in ms sql server?
Where are sql server usernames and passwords stored in the sql server?
What is a view and what are its advantages?
Explain what are magic tables in sql server?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Explain the commands in sql server?
How to test subquery results with the exists operator?
What are the types of dml?
Explain what are partitioned views and distributed partitioned views?
How to scale out a federation by Sql statement?
Where in ms sql server is ’100’ equal to ‘0’?
if no size is defined while creating the database, what size will the database have? : Sql server administration
What is difference between inner join and join?
What is difference between Datepart() and Datename() in SqlServer?
