What are the advantages of using views. Why do we need
views when we have SPs?
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
When would you use a before or after trigger?
Equi join and non equi join is possible with sql server?
How do I clean up sql server transaction log?
What happens if the update subquery returns no rows in ms sql server?
What are window functions in sql server?
What have included columns when we talk about sql server indexing?
Can the query output be sorted by multiple columns in ms sql server?
What is dirty page?
Difference between report and query parameter.
How to concatenate two strings in SQL Server.
How to retrieve error messages using odbc_errormsg()?
How to use order by with union operators in ms sql server?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
What are the difference between clustered and a non-clustered index?
What methods do you follow to protect from sql injection attack?